24 Mar
2012
24 Mar
'12
9:23 a.m.
On 24.3.2012 08:43, Jussi Hirvi wrote:
For MySQL backups, I think nobody mentioned doing nightly backups with mysqldump and then backing them up with rsync or other tools. That is what I do. No need to stop any services even for a second.
With MyISAM tables, to keep integrity, you might want to read lock the tables. Depending on the amount of data a full dump can take a long time. If you have to write while dumping, you cant, and this is a kind of a stopped service ;-)
--
Kind Regards, Markus Falb