> -----Original Message----- > From: Jerry Swanson > Sent: Thursday, February 10, 2005 08:33 > To: Daniel Kasak > Cc: mysql@lists.mysql.com > Subject: Re: Daily Incremental Backups on Mysql > > Does binary logs are avaialbe in Mysql 4 or only in Mysql 5? > Thanks >
Binary logs are available in version 4. There are differences in format between the versions. See the following for detail. http://dev.mysql.com/doc/mysql/en/binary-log.html > > > On Thu, 10 Feb 2005 10:28:56 +1100, Daniel Kasak > <[EMAIL PROTECTED]> wrote: > > Jerry Swanson wrote: > > > > >Is it possible to do "daily incremental backups" on mysql? > > > > > > > > >Thanks > > > > > > > > > > > Yes. > > mysqldump will give you a starting point, and the binary transaction > > logs give you your incremental backups - copy these > somewhere each day - > > onto a backup tape or something. Read the documentation for > mysqldump > > and for processing the binary transaction logs. > > > > -- > > Daniel Kasak > > IT Developer > > NUS Consulting Group > > Level 5, 77 Pacific Highway > > North Sydney, NSW, Australia 2060 > > T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 > > email: [EMAIL PROTECTED] > > website: http://www.nusconsulting.com.au > > --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
