MySql and SQL Server backup with code
I try to back up from MySQL with codes. Is it possible?
If it开发者_JAVA技巧 will possible, I could use this code getting backup from SQL Server.
Thank a lot.
The easiest way is to use the command-line tool mysqldump
.
mysqldump -u username -ppassword -h hostname databasename > filename.sql
It can create dumps from local or remote databases.
It is a part of the mySQL installation package (in the /bin
directory)
精彩评论