MySQL 备份恢复

1
mysqldump -u root -p \
2
  --databases db1 db2 db3 \
3
  --single-transaction \
4
  --set-gtid-purged=OFF \
5
  --quick \
6
  --routines \
7
  --events \
8
  > /var/lib/mysql/multiple-databases.sql

1
mysqldump -u root -p \
2
  --all-databases \
3
  --single-transaction \
4
  --quick \
5
  --routines \
6
  --events \
7
  > /var/lib/mysql/all-databases.sql

1
docker run --rm percona/percona-toolkit \
2
  pt-show-grants --user=root --password=pwd --host=192.168.50.21 > /var/lib/mysql/grants.sql

1
mysql -u root -p < backup.sql