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 -- Brian Reichert <[EMAIL PROTECTED]> 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
