共计 8963 个字符，预计需要花费 23 分钟才能阅读完成。
丸趣 TV 小编给大家分享一下 mydumper 怎么用，相信大部分人都还不怎么了解，因此分享这篇文章给大家参考一下，希望大家阅读完这篇文章后大有收获，下面让我们一起去了解一下吧！
下载：
https://launchpad.net/mydumper/0.9/0.9.1/+download/mydumper-0.9.1.tar.gz预备安装：
yum install cmake*
yum install glib2-devel zlib-devel pcre-devel openssl-devel安装：
[root@iZ252affh68Z ~]# tar -zxvf mydumper-0.9.1.tar.gz
mydumper-0.9.1/CMakeLists.txt
mydumper-0.9.1/README
mydumper-0.9.1/binlog.c
mydumper-0.9.1/binlog.h
mydumper-0.9.1/cmake/
mydumper-0.9.1/common.h
mydumper-0.9.1/config.h.in
mydumper-0.9.1/docs/
mydumper-0.9.1/g_unix_signal.c
mydumper-0.9.1/g_unix_signal.h
mydumper-0.9.1/mydumper.c
mydumper-0.9.1/mydumper.h
mydumper-0.9.1/myloader.c
mydumper-0.9.1/myloader.h
mydumper-0.9.1/server_detect.c
mydumper-0.9.1/server_detect.h
mydumper-0.9.1/cmake/modules/
mydumper-0.9.1/cmake/modules/CppcheckTargets.cmake
mydumper-0.9.1/cmake/modules/FindGLIB2.cmake
mydumper-0.9.1/cmake/modules/FindMySQL.cmake
mydumper-0.9.1/cmake/modules/FindPCRE.cmake
mydumper-0.9.1/cmake/modules/FindSphinx.cmake
mydumper-0.9.1/cmake/modules/Findcppcheck.cmake
mydumper-0.9.1/cmake/modules/Findcppcheck.cpp
mydumper-0.9.1/docs/CMakeLists.txt
mydumper-0.9.1/docs/_build/
mydumper-0.9.1/docs/_static/
mydumper-0.9.1/docs/authors.rst
mydumper-0.9.1/docs/compiling.rst
mydumper-0.9.1/docs/examples.rst
mydumper-0.9.1/docs/files.rst
mydumper-0.9.1/docs/index.rst
mydumper-0.9.1/docs/mydumper_usage.rst
mydumper-0.9.1/docs/myloader_usage.rst
mydumper-0.9.1/docs/_build/conf.py.in
mydumper-0.9.1/docs/_build/sources.cmake.in
[root@iZ252affh68Z ~]# cd mydumper-0.9.1
[root@iZ252affh68Z mydumper-0.9.1]# cmake .
-- The C compiler identification is GNU 4.4.7
-- The CXX compiler identification is GNU 4.4.7
-- Check for working C compiler: /usr/bin/cc
-- Check for working C compiler: /usr/bin/cc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working CXX compiler: /usr/bin/c++
-- Check for working CXX compiler: /usr/bin/c++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Using mysql-config: /mnt/software/mysql/bin/mysql_config
-- Found MySQL: /mnt/software/mysql/include, /mnt/software/mysql/lib/libmysqlclient.so;/usr/lib64/libpthread.so;/usr/lib64/libm.so;/usr/lib64/librt.so;/usr/lib64/libdl.so
-- Found ZLIB: /usr/lib64/libz.so (found version 1.2.3)
-- Found PkgConfig: /usr/bin/pkg-config (found version 0.23)
-- checking for one of the modules glib-2.0
-- checking for one of the modules gthread-2.0
-- checking for module libpcre
-- found libpcre, version 7.8
-- Found PCRE: /usr/include
CMake Warning at docs/CMakeLists.txt:9 (message):
Unable to find Sphinx documentation generator
-- ------------------------------------------------
-- MYSQL_CONFIG = /mnt/software/mysql/bin/mysql_config
-- CMAKE_INSTALL_PREFIX = /usr/local
-- BUILD_DOCS = ON
-- WITH_BINLOG = OFF
-- RUN_CPPCHECK = OFF
-- Change a values with: cmake -D Variable = Value
-- ------------------------------------------------
--
-- Configuring done
-- Generating done
-- Build files have been written to: /root/mydumper-0.9.1
[root@iZ252affh68Z mydumper-0.9.1]# make
Scanning dependencies of target mydumper
[ 25%] Building C object CMakeFiles/mydumper.dir/mydumper.c.o
[ 50%] Building C object CMakeFiles/mydumper.dir/server_detect.c.o
[ 75%] Building C object CMakeFiles/mydumper.dir/g_unix_signal.c.o
Linking C executable mydumper
[ 75%] Built target mydumper
Scanning dependencies of target myloader
[100%] Building C object CMakeFiles/myloader.dir/myloader.c.o
Linking C executable myloader
[100%] Built target myloader
[root@iZ252affh68Z mydumper-0.9.1]# make install
[ 75%] Built target mydumper
[100%] Built target myloader
Install the project...
-- Install configuration:
-- Installing: /usr/local/bin/mydumper
-- Removed runtime path from /usr/local/bin/mydumper
-- Installing: /usr/local/bin/myloader
-- Removed runtime path from /usr/local/bin/myloader确认是否安装成功：缺少 libmysqlclient.so.20
[root@iZ252affh68Z mydumper-0.9.1]# whereis mydumper
mydumper: /usr/local/bin/mydumper
[root@iZ252affh68Z mydumper-0.9.1]#
[root@iZ252affh68Z mydumper-0.9.1]# ldd /usr/local/bin/mydumper
linux-vdso.so.1 = (0x00007fffe131a000)
libmysqlclient.so.20 = not found
libpthread.so.0 = /lib64/libpthread.so.0 (0x0000003541e00000)
libm.so.6 = /lib64/libm.so.6 (0x0000003542600000)
librt.so.1 = /lib64/librt.so.1 (0x0000003542a00000)
libdl.so.2 = /lib64/libdl.so.2 (0x0000003542200000)
libglib-2.0.so.0 = /lib64/libglib-2.0.so.0 (0x00007f1a283ad000)
libgthread-2.0.so.0 = /lib64/libgthread-2.0.so.0 (0x00007f1a281a9000)
libpcre.so.0 = /lib64/libpcre.so.0 (0x00007f1a27f7b000)
libz.so.1 = /lib64/libz.so.1 (0x0000003542e00000)
libc.so.6 = /lib64/libc.so.6 (0x0000003541a00000)
/lib64/ld-linux-x86-64.so.2 (0x0000003541600000)解决办法：
[root@iZ252affh68Z mydumper-0.9.1]# locate libmysqlclient.so.20
/mnt/software/mysql/lib/libmysqlclient.so.20
/mnt/software/mysql/lib/libmysqlclient.so.20.2.1
[root@iZ252affh68Z mydumper-0.9.1]# cp /mnt/software/mysql/lib/libmysqlclient.so.20 /usr/lib64
[root@iZ252affh68Z mydumper-0.9.1]#
[root@iZ252affh68Z mydumper-0.9.1]# mydumper
** (mydumper:25013): CRITICAL **: Error connecting to database: Access denied for user root @ localhost (using password: NO)查看版本号，已经安装成功了
[root@iZ252affh68Z mydumper-0.9.1]# mydumper -V
mydumper 0.9.1, built against MySQL 5.7.12查看帮助：
[root@iZ252affh68Z mydumper-0.9.1]# mydumper --help
Usage:
mydumper [OPTION...] multi-threaded MySQL dumping
Help Options:
-?, --help Show help options
Application Options:
-B, --database Database to dump
-T, --tables-list Comma delimited table list to dump (does not exclude regex option)
-o, --outputdir Directory to output files to
-s, --statement-size Attempted size of INSERT statement in bytes, default 1000000
-r, --rows Try to split tables into chunks of this many rows. This option turns off --chunk-filesize
-F, --chunk-filesize Split tables into chunks of this output file size. This value is in MB
-c, --compress Compress output files
-e, --build-empty-files Build dump files even if no data available from table
-x, --regex Regular expression for db.table matching
-i, --ignore-engines Comma delimited list of storage engines to ignore
-m, --no-schemas Do not dump table schemas with the data
-d, --no-data Do not dump table data
-G, --triggers Dump triggers
-E, --events Dump events
-R, --routines Dump stored procedures and functions
-k, --no-locks Do not execute the temporary shared read lock. WARNING: This will cause inconsistent backups
--less-locking Minimize locking time on InnoDB tables.
-l, --long-query-guard Set long query timer in seconds, default 60
-K, --kill-long-queries Kill long running queries (instead of aborting)
-D, --daemon Enable daemon mode
-I, --snapshot-interval Interval between each dump snapshot (in minutes), requires --daemon, default 60
-L, --logfile Log file name to use, by default stdout is used
--tz-utc SET TIME_ZONE= +00:00 at top of dump to allow dumping of TIMESTAMP data when a server has data in different time zones or data is being moved between servers with different time zones, defaults to on use --skip-tz-utc to disable.
--skip-tz-utc
--use-savepoints Use savepoints to reduce metadata locking issues, needs SUPER privilege
--success-on-1146 Not increment error count and Warning instead of Critical in case of table doesn t exist
--lock-all-tables Use LOCK TABLE for all, instead of FTWRL
-U, --updated-since Use Update_time to dump only tables updated in the last U days
--trx-consistency-only Transactional consistency only
-h, --host The host to connect to
-u, --user Username with privileges to run the dump
-p, --password User password
-P, --port TCP/IP port to connect to
-S, --socket UNIX domain socket file to use for connection
-t, --threads Number of threads to use, default 4
-C, --compress-protocol Use compression on the MySQL connection
-V, --version Show the program version and exit
-v, --verbose Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2备份全库：
mydumper -u root -p xxxxxDB2015!@# -o /mnt/backup/备份 mysqlhqdb 数据库：
mydumper -u root -p xxxxxDB2015!@# -B mysqlhqdb -o /mnt/backup/备份多张表 (tableA,tableB)：
mydumper -u root -p xxxxxDB2015!@# -B mysqlhqdb -T tableA,tableB -o /mnt/backup/备份 tableA 表的数据，不备份表结构
mydumper -u root -p xxxxxDB2015!@# -B mysqlhqdb -T tableA -m -o /mnt/backup/备份 tableA 表的数据，并进行压缩
mydumper -u root -p xxxxxDB2015!@# -B mysqlhqdb -T tableA -c -o /mnt/backup/还原 mysqlhqdb 库：
myloader -u root -p xxxxxDB2015!@# -B mysqlhqdb -d /mnt/backup/还原 tableA 表
myloader -u root -p xxxxxDB2015!@# -B mysqlhqdb -o tableA -d /mnt/backup/mysqldump 和 mydumper 的速度对比
首先用 mydumper 进行全库备份，耗时为 12 分钟
[root@iZ252affh68Z mnt]# time mydumper -u root -p xxxxxDB2015!@# -o /mnt/backup/
real12m19.526s
user3m29.925s
sys0m36.017s
再用 mysqldump 全库备份，耗时为 18 分钟
[root@iZ252affh68Z mnt]# time mysqldump -uroot -p xxxxxDB2015!@# --single-transaction --all-databases /mnt/backup/all.sql
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
real18m0.563s
user5m53.119s
sys0m48.295s以上是“mydumper 怎么用”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注丸趣 TV 行业资讯频道！
正文完
