Skip to main content

mysql dump 备份回滚数据

全库备份

mysqldump -h mysql.domain.com -P3306  -u root -p discuz  > dump-discuz.sql
password:

登陆目标数据库, 然后在命令行里执行source语句, 运行备份的sql文件进行恢复.

mysql -h xxx

source ./dump-discuz.sql

参考​

How to backup and restore MySQL databases using the mysqldump command

https://www.sqlshack.com/how-to-backup-and-restore-mysql-databases-using-the-mysqldump-command/

  • 备份单数据库
mysqldump -u root -p sakila > C:\MySQLBackup\sakila_20200424.sql
  • 只备份数据结构, 不备份具体数据
mysqldump -u root -p --no-data sakila > C:\MySQLBackup\sakila_objects_definition_20200424.sql
  • 恢复数据库
mysql> create database sakila_dummy;
mysql> use sakila_dummy;
mysql> source C:\MySQLBackup\sakila_20200424.sql