,但在处理myisam时需要加一个读锁;
<李>
<李>
<李>
<李>
<李>
<李>
<李>
<李>
指定表格中<坳/> <坳/> <坳/> <坳/> 指定表格中
mysql>, create user “备份”@“localhost”, identified by “123456”;
Query 好吧,,0,rows affected (0.04,秒)
mysql>, grant 重载,lock 表、replication 客户端,process 提醒*。*,用“备份”@“localhost”, identified by “123456”;
Query 好吧,,0,rows affected (0.30,秒)
mysql>, flush 特权;
Query 好吧,,0,rows affected (0.04, sec)
[root@MySQL-01 ~] # mkdir /备份
[root@MySQL-01 ~] # cd /选择
#,下载可能较慢。
[root@MySQL-01 选择]# wget https://www.percona.com/downloads/xtrabackup/percona - xtrabackup 2.4.7/binary/redhat/6/x86_64/percona xtrabackup - 24 - 2.4.7 2. el6.x86_64.rpm
#,安装的时候出现报错,原因为依赖包未安装。
[root@MySQL-01 选择]# rpm -ivh percona xtrabackup - 24 - 2.4.7 2. el6.x86_64.rpm
警告:,percona xtrabackup - 24 - 2.4.7 2. el6.x86_64.rpm:, Header V4 DSA/SHA1 签名,,key ID cd2efd2a: NOKEY
错误:,Failed 依赖关系:
libev.so.4()(64位),is needed by percona xtrabackup - 24 - 2.4.7 2. el6.x86_64
perl (DBD:: mysql), is needed by percona xtrabackup - 24 - 2.4.7 2. el6.x86_64
#,安装相关依赖包
[root@MySQL-01 选择]# yum -y install libev-devel perl-DBD-MySQL
[root@MySQL-01 选择]# rpm -ivh percona xtrabackup - 24 - 2.4.7 2. el6.x86_64.rpm
警告:,percona xtrabackup - 24 - 2.4.7 2. el6.x86_64.rpm:, Header V4 DSA/SHA1 签名,,key ID cd2efd2a: NOKEY
准备……,,,,,,,,,,,,,,,,# # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #,(100%)
1:percona-xtrabackup-24 , # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #, (100%)
[root@MySQL-01 选择]# rpm -ql percona xtrabackup - 24 - 2.4.7 2. el6.x86_64/usr/bin/innobackupex ,,,,,,,,,,,,,,, # innobackupex脚本工具/usr/bin/xbcloud/usr/bin/xbcloud_osenv/usr/bin/xbcrypt/usr/bin/xbstream/usr/bin/xtrabackup ,,,,,,,,,,,,,,,,,,, #最主要的备份工具/usr/share/doc/percona-xtrabackup-24-2.4.7/usr/share/doc/percona-xtrabackup-24-2.4.7/复制/usr/share/man/man1/innobackupex.1.gz/usr/share/man/man1/xbcrypt.1.gz/usr/share/man/man1/xbstream.1.gz/usr/share/man/man1/xtrabackup.1。广州
#,配defaults-file: my . cnf中所做置路径
[root@MySQL-01 选择]# innobackupex ——defaults-file=/app/mysql/my.cnf ——用户=backup ——密码=123456/备份
#,查看备份目录下已经有备份文件
[root@MySQL-01 选择]# ll /备份/total 4
drwxr-x——安康;5,root root 4096年,Jul 14, 17:25 2017 - 07 - 14 - _17 - 25 - 24
[root@MySQL-01 选择]# ls /备份/2017 - 07 - 14 - _17 - 25 - 24/backup-my.cnf , performance_schema ,,,, xtrabackup_checkpoints
ibdata1 ,,,,,,, rep ,,,,,,,,,,,,,,,,,,, xtrabackup_info
mysql ,,,,,,,,, xtrabackup_binlog_info xtrabackup_logfile
[root@MySQL-01 选择]# cat /备份/2017 - 07 - 14 - _17 - 25 - 24/xtrabackup_checkpoints
时间=backup_type full-backuped ,,,,,,, #备份方式为全量备份
from_lsn =, 0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, #由于是全备,其实LSN号为0
to_lsn =, 13835894,,,,,,,,,,,,,,,,,,,,,,,, #截止LSN号
last_lsn =13835894
compact =0
recover_binlog_info =, 0
#,将数据库停掉
(root@MySQL-01 ~) # service mysqld 停止
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
null
