Shulou(Shulou.com)06/01 Report--

1. Download address

Https://launchpad.net/mydumper/+download

two。 Installation

The new version supports GTID 0.9.1 because the databases I maintain are 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

Compiler error report

Collect2: ld returns 1

Make [2]: * * [mydumper] error 1

Make [1]: * * [CMakeFiles/mydumper.dir/all] error 2

Make: * * [all] error 2

To report this error, just delete and reinstall it.

3. Simple full library backup

[root@mysql92 fullbak_2017-01-01] # mydumper-u root-p root-t 8-o / data/db_backup/fulbak_$ (date +% F)

[root@mysql92 fullbak_2017-01-01] # myloader-u root-p root-t 8-o-d / data/db_backup/fulbak_$ (date +% F)

[root@mysql92 fullbak_2017-01-01] # mydumper-- help

[root@mysql92 fullbak_2017-01-01] # myloader-- help

Specific usage, we can see the help-help, you can go to test and study. It is recommended that you use the latest version for backup.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.