1.
Https://launchpad.net/mydumper/+download
2. Installation
The new version supports Gtid 0.9.1 because the database I maintain has gtid enabled.
Yum install gcc-c++ cmake glib2-devel pcre-devel.x86_64-y
TAR-ZXVF mydumper-0.9.1.tar.gz-c/usr/local/
cd/usr/local/mydumper*
CMake.
echo $?
Make
Make install
Mydumper--help
Compile error
COLLECT2:LD return 1
MAKE[2]: * * [Mydumper] Error 1
MAKE[1]: * * [Cmakefiles/mydumper.dir/all] Error 2
Make: * * * [ALL] Error 2
Report this mistake, remove reinstall again.
3. Simple full-Library backup
[Email protected] fullbak_2017-01-01]# mydumper-u root-p root-t 8-o/data/db_backup/fulbak_$ (date +%f)
[Email protected] fullbak_2017-01-01]# myloader-u root-p root-t 8-o-d/data/db_backup/fulbak_$ (date +%f)
[Email protected] fullbak_2017-01-01]# Mydumper--help
[Email protected] fullbak_2017-01-01]# Myloader--help
The concrete usage, everybody looks to help the--help, may oneself to test the research. We recommend that you use the latest version to do the backup.
This article is from the "ROIDBA" blog, make sure to keep this source http://roidba.blog.51cto.com/12318731/1888007
Mydumper the latest version of 0.9.1, backup the prerequisite tool.