Re: slave hotbackup question

2004-03-08 Thread Heikki Tuuri
Mark, - Alkuperäinen viesti - Lähettäjä: "Mark Steele" <[EMAIL PROTECTED]> Vastaanottaja: "'Heikki Tuuri'" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Monday, March 08, 2004 6:25 PM Aihe: RE: slave hotbackup question >

RE: slave hotbackup question

2004-03-08 Thread Mark Steele
eikki Tuuri [mailto:[EMAIL PROTECTED] Sent: March 5, 2004 1:28 PM To: [EMAIL PROTECTED] Subject: Re: slave hotbackup question Mark, http://www.innodb.com/manual.php#advanced.slave describes how to set up a new slave from a hot backup of a master. If you take a hot backup of a slave, and want to use

Re: slave hotbackup question

2004-03-05 Thread Heikki Tuuri
3pm Subject: slave hotbackup question Hi folks, I have a question regarding backups taken from a running slave. I have a slave replicating to a master server, and do a hot backup using the following script: ... My question is, suppose I would like to use one of these backups to create a new slave s

slave hotbackup question

2004-03-03 Thread Mark Steele
Hi folks, I have a question regarding backups taken from a running slave. I have a slave replicating to a master server, and do a hot backup using the following script: #!/usr/bin/perl use strict; use DBI; use File::Copy; use POSIX ":sys_wait_h"; my $dbh = DBI->connect("DBI:mysql:dbname=mysql;m

Re: HOTBACKUP

2004-02-13 Thread Heikki Tuuri
y 13, 2004 8:34 PM Subject: HOTBACKUP > --=_NextPart_000_0041_01C3F235.BEE2A9E0 > Content-Type: text/plain; > charset="us-ascii" > Content-Transfer-Encoding: 7bit > > I was reading the manual for Hot Backup for InnoDB and i was missing one > fundamental thing in the

HOTBACKUP

2004-02-13 Thread Arnoldus Th.J. Koeleman
I was reading the manual for Hot Backup for InnoDB and i was missing one fundamental thing in the doc and that is setting the log-bin The document only speaks about The my.cnf files must contain the following parameter values: innodb_data_home_dir=... innodb_data_file_path=... innodb_log_group

HOTBACKUP

2004-02-13 Thread akoeleman
I was reading the manual for Hot Backup for InnoDB and i was missing one fundamental thing in the doc and that is setting the log-bin The document only speaks about The my.cnf files must contain the following parameter values: innodb_data_home_dir=... innodb_data_file_path=... innodb_log_group

HOTBACKUP INNODB

2004-02-13 Thread Arnoldus Th.J. Koeleman
Title: Message I was reading the manual for Hot Backup for InnoDB and i was missing one fundamental thing in the doc and that is setting the log-bin   The document only speaks about The my.cnf files must contain the following parameter values:innodb_data_home_dir=... innodb_data_file_path=.

Re: HOTBACKUP

2004-02-12 Thread Ware Adams
, you also need this for the InnoDB table definitions. Good luck, Ware Arnoldus Th.J. Koeleman wrote: >I am implementing Hotbackup for innodb . > >My question is when the tables in the database directory so *.frm are >deleted by mistake will they be recovered by the hotbackup script?

HOTBACKUP

2004-02-12 Thread Arnoldus Th.J. Koeleman
I am implementing Hotbackup for innodb . My question is when the tables in the database directory so *.frm are deleted by mistake will they be recovered by the hotbackup script?

Making hotbackup

2003-12-12 Thread Arnoldus Th.J. Koeleman
I am running a mysql database and want to perform a hotbackup on linux. How will this be done since the ibbackup tool is not delivered in the standard package

Re: Recover mysql database from hotbackup. This is Urgent!!!

2003-01-27 Thread Heikki Tuuri
Anne, - Original Message - From: "Anne" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, January 27, 2003 7:35 PM Subject: Recover mysql database from hotbackup. This is Urgent!!! > Hi, > > We are performing daily hotbackup of the mysql da