mysqldump备份操作最佳实践-亲试ok

常用语法：

mysqldump  [options]  databases [tables]

mysqldump  [options]  --databases [options] db1  db2

mysqldump  [options]  --all-databases [options]

1、创建备份用户

mysql> create user 'backup'@'localhost' identified by '123456';

Query OK, 0 rows affected (0.36 sec)

2、为用户授权

mysql> grant select,reload,lock tables,replication client,show view,event,process on *.* to 'backup'@'localhost';

Query OK, 0 rows affected, 1 warning (0.02 sec)

3、备份操作

[root@localhost run]# mysqldump -hlocalhost -ubackup -p123456  --master-data=2 --single-transaction --routines --triggers --events --set-gtid-purged=OFF myown >/data/back/myown.sql

mysqldump: [Warning] Using a password on the command line interface can be insecure.