"MySQL" Table backup

Some of the more well-spoken information:

Http://www.cnblogs.com/liangshaoye/p/5464794.html: Explains the hot spare, Win Bei, cold, incremental backup, differential backup and many other concepts.

Http://www.cnblogs.com/guoyibao/p/3867634.html: Introduced the various selection parameters in Mysqldump, mainly the concept of lock

Http://www.cnblogs.com/youngjoy/p/3912623.html: Example Intuitive and concise

Back up the test_db database in tables A, B, c to file Bak.sql, username is root, password is 12345678

- - -- Lock-tables test_db a b C > bak.sql

Note:-P follows the password directly, with no spaces. This is not very good to write, easy to reveal the password. You can also enter the following command and then enter the password separately.

- - -- Lock-tables test_db a b C > bak.sql

--lock-tables indicates that all tables are locked to avoid data inconsistencies.

"MySQL" Table backup