31

两个场景下Mysqldump数据库备份恢复-流年似水

 4 years ago
source link: https://blog.51cto.com/14322729/2419515
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
完全备份mysqldump-A-F--single-transaction--master-data=2>/backup/fullbak`date+%F`.sqlless/backup/fullbak2019-07-11.sql模拟2点到18点的数据修改模拟存放数据库的硬盘损坏,所有数据库丢失还原数据库已经故障确保用户无法访问vi/etc/my.cnf#添加一行systemctlrestartma

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK