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]
