View Single Post
Old 11-19-2008, 02:06 AM  
Owen Pierce
Registered User
 
Owen Pierce's Avatar
 
Join Date: Dec 2007
Posts: 95
Heh yeah, anything can corrupt. backups are crucial.
one backup option would be to setup a master/slave setup on mysql. then you get instant backups to any slave(s) you have setup. And of course if those are on different machines, you can take advantage of that whole situation for speed.
but yeah, multiple computer backups are the bare minimum.

Or have mysql do an UpdateLog and setup a cron to process those queries into a backup database (prolly should be myisam if it's on the same computer, so that its not in the innodb file). and clear the log. Cuz that baby will get HUGE
__________________
Models/Agency search: http://strongthread.com
Owen Pierce is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote