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
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
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
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
> -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
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
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
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]
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
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]
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
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
12 matches
Mail list logo