> -----Original Message----- > From: Chris [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 18, 2006 2:43 AM > To: Dan Trainor > Cc: Kaushal Shriyan; mysql@lists.mysql.com > Subject: Re: Incremental Backup > > Dan Trainor wrote: > > Kaushal Shriyan wrote: > >> Hi ALL > >> > >> I would like to know following 2 things. > >> > >> 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 > >> > >> Thanks and Regards > >> > >> Kaushal > >> > > > > Hi - > > > > The following, has been my experience: > > > > A) That will not work. > > B) Depending on the OS, this may never complete, as files may constantly > > still be written to > > C) Depending on the OS, cp may not be able to take all of those > > directories for those 1000's of databases as arguments > > D) If you were doing that, you'd use 'cp -r' > > The other thing of course is that to copy the files through the > filesystem, you have to stop mysql from running so you don't corrupt > anything which means your whole database system can't be used. >
For MyISAM files, mysqlhotcopy of the slave is a workable solution. It's fast, it locks the tables only while copying, and you end up with the same set of files as a cp-based option. Tim > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
