zh:notes:mysql_backup_restore
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 两侧同时换到之前的修订记录 前一修订版 | |||
|
zh:notes:mysql_backup_restore [2022/10/19 15:34] pzczxs [Restore a Database] |
zh:notes:mysql_backup_restore [2022/10/20 17:20] (当前版本) pzczxs |
||
|---|---|---|---|
| 行 3: | 行 3: | ||
| ===== Backup One Database ===== | ===== Backup One Database ===== | ||
| <code bash> | <code bash> | ||
| - | > mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql | + | > mysqldump -uusername -ppassword databasename > database-backup.sql |
| </code> | </code> | ||
| ===== Backup Multiple Tables in a Database ===== | ===== Backup Multiple Tables in a Database ===== | ||
| <code bash> | <code bash> | ||
| - | > mysqldump -hhostname -uusername -ppassword databasename specific_table1 specific_table2 > database-backup.sql | + | > mysqldump -uusername -ppassword databasename specific_table1 specific_table2 > database-backup.sql |
| </code> | </code> | ||
| ===== Backup Multiple Databases ===== | ===== Backup Multiple Databases ===== | ||
| <code bash> | <code bash> | ||
| - | > mysqldump -hhostname -uusername -ppassword –databases databasename1 databasename2 databasename3 > database-backup.sql | + | > mysqldump -uusername -ppassword –databases databasename1 databasename2 databasename3 > database-backup.sql |
| </code> | </code> | ||
| ===== Backup the Structure of a Database ===== | ===== Backup the Structure of a Database ===== | ||
| <code bash> | <code bash> | ||
| - | > mysqldump --no-data --user=name --password=pwd –-databases databasename1 databasename2 databasename3 > database-structure.sql | + | > 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> | </code> | ||
| 行 28: | 行 33: | ||
| ===== Restore a Database ===== | ===== Restore a Database ===== | ||
| <code bash> | <code bash> | ||
| - | >mysql -hhostname -uusername -ppassword databasename < database-backup.sql | + | >mysql -uusername -ppassword databasename < database-backup.sql |
| </code> | </code> | ||
| ~~DISCUSSION:closed~~ | ~~DISCUSSION:closed~~ | ||
zh/notes/mysql_backup_restore.1666164862.txt.gz · 最后更改: 2022/10/19 15:34 由 pzczxs