Re: MySQL-Backup incremental Backups in a Master/Slave Environment

2008-08-08 Thread Werner D.
Hi, first thanks for your response Are you using InnoDb or MyISAM? If you are using Inno, I would add --single-transaction to your mysqldump command within the Perl script and flush the logs prior to doing the backup and not backup the new bin-log file until the next. No, there is a mixture b

MySQL-Backup incremental Backups in a Master/Slave Environment

2008-08-04 Thread Werner D.
Hello everybody, i have a Question concering MySQL-Backups in a Master/Slave Replication-Setup (MYISAM and InnoDB Tables) and incremental Backups using the Binary-Logs from the Slave. Well, in case something will go wrong (hopefully not) I'm currently trying to implement a recovery S

RE: Daily Incremental Backups on Mysql

2005-02-10 Thread Dean, Michael L USAATC
The option in my.cnf is log-bin = 'logfilename here' Michael -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 February, 2005 14:58 To: Jerry Swanson; mysql@lists.mysql.com Subject: Re: Daily Incremental Backups on Mysql Jerry Swanson wro

Re: Daily Incremental Backups on Mysql

2005-02-10 Thread Daniel Kasak
Jerry Swanson wrote: Does binary logs are avaialbe in Mysql 4 or only in Mysql 5? Thanks 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 MySQL 4.x

RE: Daily Incremental Backups on Mysql

2005-02-10 Thread Tom Crimmins
> -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 &g

Re: Daily Incremental Backups on Mysql

2005-02-10 Thread Jerry Swanson
Does binary logs are avaialbe in Mysql 4 or only in Mysql 5? Thanks 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? > > > > > >Thank

Re: Daily Incremental Backups on Mysql

2005-02-09 Thread Daniel Kasak
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 doc

Daily Incremental Backups on Mysql

2005-02-09 Thread Jerry Swanson
Is it possible to do "daily incremental backups" on mysql? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Incremental backups in Mysql

2004-10-29 Thread Paul DuBois
At 19:29 +0530 10/29/04, Anil Doppalapudi wrote: Is it possible to take incremental backups in mysql.if yes please provide me links or info on it Your binary logs are your incremental backups. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General

Incremental backups in Mysql

2004-10-29 Thread Anil Doppalapudi
Is it possible to take incremental backups in mysql.if yes please provide me links or info on it Thanks Anil DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: incremental backups?

2001-02-02 Thread Paul DuBois
At 2:54 PM -0500 2/2/01, Hardy Merrill wrote: >Are incremental backups possible in MySQL? I haven't seen any >reference to "incremental" in the mysqldump or anywhere else for >that matter. You can take a full dump, and then treat the contents of the update logs from that

incremental backups?

2001-02-02 Thread Hardy Merrill
Are incremental backups possible in MySQL? I haven't seen any reference to "incremental" in the mysqldump or anywhere else for that matter. TIA. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncr