Welcome to WebmasterWorld Guest from 188.8.131.52
Forum Moderators: open
joined:Apr 29, 2015
i know the preferred way to do this is via mysqldump but i think that will take forever given the db size. can i just copy the db data files to a new backup directory and tar -czvf that directory?
what are the major risks associated with this quick and dirty approach?
i'm trying to avoid having to get in my car and go down to the hosting center to physically download backups, in order to clear space... :)
thanks in advance for any input!
I'm not sure how good rsync is at diffing binary files
I wouldn't count on this speeding things up.
Between 100 and 400 times faster.
wrote 4394533 bytes read 104210 bytes 101095.35 bytes/sec
total size is 628733048 speedup is 139.76
Finished at Sun Feb 18 07:44:33 GMT 2007
I'm doing a read lock flush, then rsync to a spare server.
Fastest backup system I've ever had for MySQL, and a lot less messy and more reliable than syncronisation which I've also played with (under MySQL 4.* anyway).
[edited by: trillianjedi at 11:49 am (utc) on Feb. 18, 2007]
joined:June 15, 2001
Rsync is possible the only option when you're database is really big. Once had to back up an 80+ gig mysql db and rsync was the only option that seamed to work.
Started process, went to sleep, woke up to backup completed.