I've just written a couple of simple ruby classes to help dump a mysql database without locking tables for extended periods.
In particular, some of my tables contain lots of date-based data which is not changed after the day it was created. The classes can be told to dump such data one day at a time, and won't dump a day that has already been dumped.
Check it out on github;
http://github.com/digitalronin/DbDumper
I hope people find it useful.
David
2009/12/21
Incremental dump of a mysql database
Posted by Anonymous at 3:59 pm
Subscribe to:
Comment Feed (RSS)
|