这篇文章主要为大家展示了“mysql中mysqldumper怎么用”，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让小编带领大家一起研究并学习一下“mysql中mysqldumper怎么用”这篇文章吧。
 
并行处理：
 
    使用mydumper命令的局限在与他是一个单线程进程。但开源的mydumper是一个很好的替代。
 
    mydumper（http://www.mysqldumper.org/）是一个在GNU GPLv3许可下发布的高性能MySQL备份和恢复工具集。mydumper是多线程的，他创建一个mysql备份就比随mysql发布的mysqldump工具要快得多。mydumper也有从源端服务器恢复二进制日志的能力。
 
    mydumper的优点：
 
    多线程，可以是转存数据快很多。
 
    mydumper的输出已于管理和分析，因为他的表和元数据是分开的单独文件。
 
    所有线程都维护有一直的快照，这边提供了精准的主从位置。
 
    Mydumper支持Perl正则表达式，这样就既可以包括是数据库名和报名的模式匹配，也可以配置这种匹配。
 
    通过名为myloader的多线程工具，mydumper工具集也可以从mydumper备份中恢复数据。
 
    mydumper必须在源代码上进行编辑。这就需要带有C++编辑器的系统。另外还需要如下组件：
 
    Cmake、带有开发包的Glib2、带有开发包的PCRE、mysql的客户端库和开发工具。
 
 
简单用法：
 
    mkdir /mysql/bakcup/mydumper
 
    cd /mysql/backup/mydumper
 
    time mydumper
 
[root@d4jtarmsvurd01 mydumper_bak]# pwd
 
/mysql/mydumper_bak
 
[root@d4jtarmsvurd01 mydumper_bak]# ls ex*
 
metadata                           mysql.proc-schema.sql
 
mysql-schema-create.sql            mysql.procs_priv-schema.sql
 
mysql.columns_priv-schema.sql      mysql.servers-schema.sql
 
mysql.db-schema.sql                mysql.tables_priv-schema.sql
 
mysql.db.sql                       mysql.time_zone-schema.sql
 
mysql.event-schema.sql             mysql.time_zone_leap_second-schema.sql
 
mysql.func-schema.sql              mysql.time_zone_name-schema.sql
 
mysql.help_category-schema.sql     mysql.time_zone_transition-schema.sql
 
mysql.help_category.sql            mysql.time_zone_transition_type-schema.sql
 
………………..
 
当在冗长模式中运行时，会产生额外的输出，单所提供的信息中并不包括完整的输出目录：
 
    [root@d4jtarmsvurd01 mydumper_bak]# mydumper -v 3
 
** Message: Connected to a MySQL server
 
** Message: Started dump at: 2016-07-05 15:16:56
 
** Message: Written master status
 
** Message: Thread 1 connected using MySQL connection ID 1367
 
** Message: Thread 2 connected using MySQL connection ID 1368
 
** Message: Thread 3 connected using MySQL connection ID 1369
 
** Message: Thread 4 connected using MySQL connection ID 1370
 
** Message: Thread 2 dumping data for `mysql`.`db`
 
** Message: Thread 1 dumping data for `mysql`.`columns_priv`
 
** Message: Thread 3 dumping data for `mysql`.`event`
 
** Message: Empty table mysql.event
 
** Message: Empty table mysql.columns_priv
 
** Message: Thread 2 dumping data for `mysql`.`func`
 
** Message: Thread 1 dumping data for `mysql`.`help_category`
 
** Message: Thread 3 dumping data for `mysql`.`help_keyword`
 
** Message: Thread 1 dumping data for `mysql`.`help_relation`
 
** Message: Empty table mysql.func
 
** Message: Thread 2 dumping data for `mysql`.`help_topic`
 
** Message: Thread 3 dumping data for `mysql`.`host`
 
** Message: Thread 1 dumping data for `mysql`.`ndb_binlog_index`
 
** Message: Empty table mysql.ndb_binlog_index
 
** Message: Thread 1 dumping data for `mysql`.`plugin`
 
** Message: Empty table mysql.plugin
 
** Message: Thread 1 dumping data for `mysql`.`proc`
 
** Message: Empty table mysql.proc
 
** Message: Thread 1 dumping data for `mysql`.`procs_priv`
 
** Message: Empty table mysql.host
 
** Message: Thread 3 dumping data for `mysql`.`servers`
 
** Message: Empty table mysql.servers
 
** Message: Thread 3 dumping data for `mysql`.`tables_priv`
 
** Message: Empty table mysql.procs_priv
 
** Message: Thread 1 dumping data for `mysql`.`time_zone`
 
** Message: Empty table mysql.time_zone
 
** Message: Thread 1 dumping data for `mysql`.`time_zone_leap_second`
 
** Message: Empty table mysql.time_zone_leap_second
 
** Message: Thread 1 dumping data for `mysql`.`time_zone_name`
 
** Message: Empty table mysql.time_zone_name
 
** Message: Thread 1 dumping data for `mysql`.`time_zone_transition`
 
** Message: Empty table mysql.tables_priv
 
** Message: Thread 3 dumping data for `mysql`.`time_zone_transition_type`
 
** Message: Empty table mysql.time_zone_transition
 
** Message: Thread 1 dumping data for `mysql`.`user`
 
** Message: Thread 1 dumping data for `sanxing`.`sanxing`
 
** Message: Empty table mysql.time_zone_transition_type
 
** Message: Thread 3 dumping data for `test`.`guijian`
 
** Message: Thread 3 dumping schema for `mysql`.`columns_priv`
 
** Message: Thread 1 dumping schema for `mysql`.`db`
 
** Message: Thread 1 dumping schema for `mysql`.`event`
 
** Message: Thread 1 dumping schema for `mysql`.`func`
 
** Message: Thread 1 dumping schema for `mysql`.`help_category`
 
** Message: Thread 1 dumping schema for `mysql`.`help_keyword`
 
** Message: Thread 3 dumping schema for `mysql`.`help_relation`
 
** Message: Thread 1 dumping schema for `mysql`.`help_topic`
 
** Message: Thread 3 dumping schema for `mysql`.`host`
 
** Message: Thread 1 dumping schema for `mysql`.`ndb_binlog_index`
 
** Message: Thread 1 dumping schema for `mysql`.`plugin`
 
** Message: Thread 3 dumping schema for `mysql`.`proc`
 
** Message: Thread 1 dumping schema for `mysql`.`procs_priv`
 
** Message: Thread 1 dumping schema for `mysql`.`servers`
 
** Message: Thread 1 dumping schema for `mysql`.`tables_priv`
 
** Message: Thread 3 dumping schema for `mysql`.`time_zone`
 
** Message: Thread 1 dumping schema for `mysql`.`time_zone_leap_second`
 
** Message: Thread 3 dumping schema for `mysql`.`time_zone_name`
 
** Message: Thread 1 dumping schema for `mysql`.`time_zone_transition`
 
** Message: Thread 3 dumping schema for `mysql`.`time_zone_transition_type`
 
** Message: Thread 3 dumping schema for `mysql`.`user`
 
** Message: Thread 3 dumping schema for `sanxing`.`sanxing`
 
** Message: Thread 3 dumping schema for `test`.`guijian`
 
** Message: Non-InnoDB dump complete, unlocking tables
 
** Message: Thread 3 shutting down
 
** Message: Thread 1 shutting down
 
** Message: Thread 4 shutting down
 
** Message: Thread 2 shutting down
 
** Message: Finished dump at: 2016-07-05 15:16:56
 
[root@d4jtarmsvurd01 mydumper_bak]# ls
 
export-20160705-151255  export-20160705-151656
 
[root@d4jtarmsvurd01 mydumper_bak]#