Mysql备份
备份整个数据库
mysqldump --all-databases --single-transaction --quick --lock-tables=false > full-backup-$(date +%F).sql -u root -p
备份指定数据库
mysqldump -u root -p dbname --single-transaction --quick --lock-tables=false > db1-backup-$(date +%F).sql
// 备份ghost数据库
mysqldump -u root -p ghost --single-transaction --quick --lock-tables=false > ghost-backup-$(date +%F).sql
备份单张表
mysqldump -u root -p --single-transaction --quick --lock-tables=false db1 table1 > db1-table1-$(date +%F).sql
// 备份ghost库的users表
mysqldump -u root -p --single-transaction --quick --lock-tables=false ghost users > ghost-users-$(date +%F).sql
