but i'm on Red Hat enterprise server so i wouldn't be able to use the
Features of FreeBSD and restarting the server is not a solution for me as i need to be able to perform hot backup.
One of my solutions was to bump the database in a text file. this wroks fine for small tables but with lager one this takes too
much time and somtimes freezers the server.
V!nay
Brian Reichert wrote:
On Tue, Jun 15, 2004 at 10:14:54AM +0400, Vinay wrote:
Hi,
I just like to know what is the best way to dump the databases to flat files as some of the tables on my system are up to 1.4G and the whole database size is over 2.5G . I trying to set up a cron job that will back up the table everyday and my main consern is the size of the tables and the time it may take to back up all the data and the fact that even during the back up theire will be other people using the database.
I've seen people play horrible tricks with NetApps (an other heavy journaling filesystems), wherein you could get a snapshot of the whole FS very quickly.
The order of events is then
- shut down DB - snapshot the FS - start the DB - back up the now-static snapshot any way you see fit, such as spinning up a second instance of MySQL to use that snapshot, for a mysqldump.
The FreeBSD 5.x series seems to offer filesystem snapshots (for example), but I've not explored them yet..
V!nay
