zh:notes:mysql_backup_restore
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 两侧同时换到之前的修订记录 前一修订版 后一修订版 | 前一修订版 | ||
|
zh:notes:mysql_backup_restore [2022/10/19 15:31] pzczxs |
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 > backupfile.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 > multibackupfile.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 > structurebackupfile.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> | ||
| ===== Backup All Databases ===== | ===== Backup All Databases ===== | ||
| <code bash> | <code bash> | ||
| - | > mysqldump –all-databases > allbackupfile.sql | + | > mysqldump –all-databases > database-backup.sql |
| </code> | </code> | ||
| ===== Restore a Database ===== | ===== Restore a Database ===== | ||
| <code bash> | <code bash> | ||
| - | >mysql -hhostname -uusername -ppassword databasename < backupfile.sql | + | >mysql -uusername -ppassword databasename < database-backup.sql |
| </code> | </code> | ||
| + | |||
| + | ~~DISCUSSION:closed~~ | ||
zh/notes/mysql_backup_restore.1666164668.txt.gz · 最后更改: 2022/10/19 15:31 由 pzczxs