要求:![](https://i-blog.csdnimg.cn/direct/ca9945667de44fbfa269b55ab5602a25.png)
一备份
1
mysqldump -u root -p booksDB > booksDB_all_tables.sql
2
mysqldump -u root -p booksDB books > booksDB_books_table.sql
3
mysqldump -u root -p --databases booksDB test > booksDB_and_test_databases.sql
4
mysql -u root -p booksDB < booksDB_books_table.sql
5
USE booksDB;
SOURCE /path/to/booksDB_books_table.sql;