MYSQL database backup and recovery

Mysqldump-h host name-P port-u user name-p password (-database) database name file name. SQL backup MySQL database command mysqldump-hhostname-uusername-ppassworddatabasenamebackupfile. SQL backup MySQL database with Delete table type, can make the backup overwrite existing database without manual Deletion

Mysqldump-h host name-P port-u user name-p password (-database) database name file name. SQL backup MySQL database command mysqldump-hhostname-uusername-ppassword databasename backupfile. the SQL backup MySQL database adopts the "Delete table" format, which allows the backup to overwrite existing databases without manual deletion.

Mysqldump-h host name-P port-u user name-p password (-database) database Name> file name. SQL

Command for backing up MySQL database

Mysqldump-hhostname-uusername-ppassword databasename> backupfile. SQL

Backing up a MySQL database is in the format of a table with deletion, so that the backup can overwrite existing databases without the need to manually delete the original database.
Mysqldump -- add-drop-table-uusername-ppassword databasename> backupfile. SQL

Directly compress and back up the MySQL database
Mysqldump-hhostname-uusername-ppassword databasename | gzip> backupfile. SQL .gz

Back up a MySQL database table
Mysqldump-hhostname-uusername-ppassword databasename specific_table1 specific_table2> backupfile. SQL

Back up multiple MySQL databases at the same time
Mysqldump-hhostname-uusername-ppassword-databases databasename1 databasename2 databasename3> multibackupfile. SQL

Back up database structures only
Mysqldump-no-data-databases databasename1 databasename2 databasename3> structurebackupfile. SQL

Back up all databases on the server
Mysqldump-all-databases> allbackupfile. SQL

Command for restoring MySQL database
Mysql-hhostname-uusername-ppassword databasename <backupfile. SQL

Restore a compressed MySQL database
Gunzip <backupfile. SQL .gz | mysql-uusername-ppassword databasename

Transfer database to new server

Mysqldump-uusername-ppassword databasename | mysql-host = *. *-C databasename

========================================================== ======================================

JAVA code call command Method

Process p = runtime.getruntime(cmd.exe c ("cmd/c mysqldump-h127.0.0.1-P3306-uroot-p123456 customer> d:/opt/customer/dbback/backupfile-1351022418812. SQL "); // wait until compilation ends. waitFor (); // check the return code to see if the compilation fails. Int ret = p. exitValue (); System. out. println (ret );