Shulou(Shulou.com)06/01 Report--

Brief introduction:

Mysqldump is commonly used for logical backups of MySQL databases.

Backup operation:

1. Back up all libraries: mysqldump-uroot-pyourpass-- all-databases > / tmp/all.dump2. Back up a single library: mysqldump-uroot-pyourpass test > test.dump3. Backup sheet: mysqldump-uroot-pyourpass test test_tb > test_tb.sql4. Backup stored procedure: mysqldump-uroot-pyourpass-n-d-t-R test > test_procedure.sql

Restore operation:

Make sure that the database to be restored exists before recovery

Restore a single library: mysql-uroot-pyourpass test

/ tmp/test_tb.sql-- filter out the table-building statement cat test.dump | grep-- ignore-case 'insert into `test_ tb`' > / tmp/insert_test_tb.sql-- filter the insert statements that insert data

Then execute the corresponding sql in the database as needed to recover the single table.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.