备份前准备 创建单独用于备份的用户，并授予相应的权限 1 2 3 createuserdb_backup@'localhost'identifiedby'backup123';grantselect,locktables,showview,trigger,eventonbackup_database.*todb_backup@'localhost';grantreload,Replicationclienton*.*todb_backup@'localhost'; 方案1：全量逻辑备份(使用mysqldump,方案1) 备份 1 2 3 4 5 6 7 8 9 10 11 #!/bin/bash backup_file_name=db_backup_`date '+%Y-%m-%d'`.sql.gz mysqldump -udb_backup -pbackup123 --single-transaction --flush-logs --master-data=2 backup_database | gzip > $backup_file_name if [ -e $backup_file_name ] ;then echo "Start to copy files" # scp $backup_file_name lihu@ubuntu-vm-02:/home/lihu else echo "No file to copy" fi 额外的参数 --skip-add-drop-table：生成的备份文件中……

阅读全文