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>