"MySQL Backup/restore"

Backup library: mysqldump-uroot-p123456 MySQL (name of database to be backed up) >/tem/mysql.sql

Recovery library: mysql-uroot-p123456 MySQL (name of database to be backed up) </tmp/mysql.sql

Backup table: mysqldump-uroot-p123456 mysql (database name to be backed up) User (table name) >/tem/user.sql

Recovery table: mysqldump-uroot-p123456 mysql (name of database to be backed up) </tem/user.sql

View Backup Table Sql:less/tmp/user.sql

Back up all libraries: MySQL dump-uroot-p123456-a >/tmp/all.sql

Back up table structure only: mysqldump-uroot-p123456-d MySQL (database name) >/tmp/mysql.sql

: Where to save

<: Restore back

"MySQL Backup/restore"