MySQL 备份工具 mydumper
fmms
13年前
<p>mydumper 是取代 mysqldump 的工具,主要的差异在于 mydumper 会同时对多个table备份,效率比 mysqldump 好。</p> <p>可以用 <code>--help</code> 看用法,常用的示例指令如:</p> <blockquote> <p><code>mydumper -h [hostname] -u [username] -p [password] -x ‘^tracdb\.’</code></p> </blockquote> <p>备份的文件被放在同一个目录里 (export-*)。</p> <h4>Mydumper 功能特性:</h4> <ul> <li>Lightweight C source</li> <li>Up to 10x faster dumps compared to mysqldump</li> <li>Consistent snapshots for transactional and non-transactional tables (in 0.2.2 onwards)</li> <li>File compression on-the-fly</li> <li>Binary log dumps</li> <li>Multi-threaded restore utility (in 0.2.1 onwards)</li> <li>Daemon mode for timed snapshots and continuous binary logs (in 0.5.0 onwards)</li> <li>Open Source! (GNU GPLv3)<br /> </li> </ul> <p><strong>项目主页:</strong><a href="http://www.open-open.com/lib/view/home/1326289393515" target="_blank">http://www.open-open.com/lib/view/home/1326289393515</a></p>