http://dev.mysql.com/doc/refman/5.0/en/mysqlhotcopy.html
> -----Original Message----- > From: Kaushal Shriyan [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 18, 2006 7:45 AM > To: Tim Lucia > Cc: mysql@lists.mysql.com > Subject: Re: Incremental Backup > > On 7/18/06, Kaushal Shriyan <[EMAIL PROTECTED]> wrote: > > On 7/18/06, Tim Lucia <[EMAIL PROTECTED]> wrote: > > > > > > > > > > -----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] > > > > > > > > Hi Tim > > > > How do i do it with mysqlhotcopy, can you give me examples on how to use > > mysqlhotcopy > > > > Thanks > > Kaushal > > > > Hi > > Can I have a incremental backup instead of Full Backup > > Thanks and Regards > > Kaushal > > -- > 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]