2 ms·
If you have the option of re-dumping it, use mydumper instead. Crazy fast. https://launchpad.net/mydumper https://launchpad.net/mydumper
by ck2 13y ago
If you have the option of re-dumping it, use mydumper instead. Crazy fast.
https://launchpad.net/mydumper https://launchpad.net/mydumper
- falcolas 13y agoI second this recommendation. At least partially because its complement (myloader) can also load tables in parallel back into a database. Also, since mysqldump insert lines all contain the database name, it's fairly trivial to do this splitting with standard 'nix tools as well.