Here is a link http://www.innodb.com/doc/hot_backup...p.uncompressed

I personally backup first then compress. Saves on overhead. And the risk of no backup at all is lowered.
Lock Down Reviewed by Lock Down on . mysql hotcopy scripst any one know any good mysql hotcopy scripts which can run by cron , i have large databses around 20 gb dumping them takes really long time killing all sites on server :( Rating: 5