Mysql backup and recovery methods

 

Mysqldump

Back up the entire database

Mysqldump-u root-ppassword databasename> data. SQL

// Enter the root password.

Back up one or more tables

Mysqldump-u root-p databasename table1name table2name> data. SQL

// Enter the root password.

Back up data structures only

Mysqldump-u root-p databasename-no-data> data. SQL

// Enter the root password.

Restore

Mysql-u root-p-database = databasename

// Enter the root password.

 

Backup:

/Usr/local/mysql/bin/mysqldump-add-drop-table-all-databases-opt-f-uroot-pabc>/back/mysql-back. SQL/whole database

Tar czvf/back/mysql-back.tgz/back/mysql-back. SQL

 

/Usr/local/mysql/bin/mysqldump-add-drop-table-opt-f-uroot-p123 ywrc>/home/back/www/ywrc. SQL // single database

Tar czvf/home/back/www/tar/ywrc-back.tgz/home/back/www/ywrc. SQL

 

Recovery:

Mysql ywrc <ywrc. SQL