zh:notes:mysql_backup_restore
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 后一修订版 | 前一修订版 | ||
|
zh:notes:mysql_backup_restore [2022/10/19 15:25] pzczxs 创建 |
zh:notes:mysql_backup_restore [2022/10/20 17:20] (当前版本) pzczxs |
||
|---|---|---|---|
| 行 1: | 行 1: | ||
| ====== Backup and Restore MySQL Database ====== | ====== Backup and Restore MySQL Database ====== | ||
| + | ===== Backup One Database ===== | ||
| + | <code bash> | ||
| + | > mysqldump -uusername -ppassword databasename > database-backup.sql | ||
| + | </code> | ||
| + | ===== Backup Multiple Tables in a Database ===== | ||
| + | <code bash> | ||
| + | > mysqldump -uusername -ppassword databasename specific_table1 specific_table2 > database-backup.sql | ||
| + | </code> | ||
| + | |||
| + | ===== Backup Multiple Databases ===== | ||
| + | <code bash> | ||
| + | > mysqldump -uusername -ppassword –databases databasename1 databasename2 databasename3 > database-backup.sql | ||
| + | </code> | ||
| + | |||
| + | ===== Backup the Structure of a Database ===== | ||
| + | <code bash> | ||
| + | > mysqldump --no-data -uusername -ppassword databasename > database-structure.sql | ||
| + | </code> | ||
| + | |||
| + | ===== Backup the Structures of Multiple Databases ===== | ||
| + | <code bash> | ||
| + | > mysqldump --no-data -uusername -ppassword –-databases databasename1 databasename2 databasename3 > database-structure.sql | ||
| + | </code> | ||
| + | |||
| + | ===== Backup All Databases ===== | ||
| + | <code bash> | ||
| + | > mysqldump –all-databases > database-backup.sql | ||
| + | </code> | ||
| + | |||
| + | ===== Restore a Database ===== | ||
| + | <code bash> | ||
| + | >mysql -uusername -ppassword databasename < database-backup.sql | ||
| + | </code> | ||
| + | |||
| + | ~~DISCUSSION:closed~~ | ||
zh/notes/mysql_backup_restore.1666164318.txt.gz · 最后更改: 2022/10/19 15:25 由 pzczxs