MySQL logical backup and recovery

Backup: Mysqldump-uroot-p YYZC Department >/home/admin/yyzc_backup.sql

Recovery: Mysql-uroot-p Yyzc

Back up all databases

Mysqldump-uroot-p--all-database > All.sql

Back up the database test

Mysqldump-uroot-p Test > Test.sql

Back up the table EMP under Database test:

Mysqldump-uroot-p Test emp > Emp.sql

Back up the database test under Table EMP and dept:

Mysqldumo-uroot-p Test EMP Dept > emp_dept.sql

All tables under the backup data test are comma-delimited text, backed up to/tmp:

MYSQLDUMP-UROOT-T/tmp Test emp--fields-terminated-by ', '

More Emp.txt

Mysqldumo a lot of options, the amount can use Mysqldump-help view Help;

Nine o'clock in the morning, back up the database:

Mysqldump-uroot-p-l-f Test>test.dmp

-L represents a read lock for all tables, and-F indicates that a new log file is generated.

9:30 After the backup is complete, insert the new data:

mysql> INSERT INTO EMP values (5,)

MySQL logical backup and recovery