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?