centos 7 mysqlhotcopy 安装,使用 笔记

1,安装perl-DBI 和 perl-DBD-MySQL,否则在运行mysqlhotcopy时会保错:

[root@localhost ~]# mysqlhotcopy -u root -p mysqlname /opt/sql_back/
Warning: /usr/bin/mysqlhotcopy is deprecated and will be removed in a future version.
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at (eval 11) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge.
 at /usr/bin/mysqlhotcopy line 199.

安装方法:

[root@localhost ~]# yum install perl-DBD* -y

2,备份

[root@localhost ~]# /bin/mysqlhotcopy -u root -p '' --addtodest mysqlname /opt/sql_back/

3,还原

[root@localhost~]# cp -arp /opt/sql_back/mysqlname /var/lib/mysql/        --将备份的数据移到mysql数据根目录