MySQL BackUp

[Ed Greshko]

Kaushal Shriyan wrote:
> Hi ALL
> 
> I would like to know the following
> 
> 1) if i would like to take mysql incremental backup weekly
> 
> cp /var/lib/mysql/ /backup/mysqlbak/
> 
> how can i do it by above command as i would like to run cron weekly
> for take mysql backup.
> 
> i would like to take backup using cp command only as we have more then
> 1000 databases on one server.
> 
> IS THERE ANY BETTER WAY TO DO THIS

I would consult

http://dev.mysql.com/doc/refman/5.1/en/disaster-prevention.html

for starters.


-- 
Who's on first?