Hi!
- Original Message -
From: ""Sp.Raja"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, July 27, 2004 5:52 PM
Subject: Re: Innodb assertion failure after binary backup-restore
> Thanks for your replies.
>
> Now I have three w
: Innodb assertion failure after binary backup-restore
Thanks for your replies.
Now I have three ways to go
1. replication
2. innodb hot backup tool
3. Make sure that no one is writing in to the database and start
backup when modified db pages in "BUFFER POOL AND MEMORY" be
Sp.Raja
> Original Message
> From: "Heikki Tuuri" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Date: Tue, Jul-27-2004 6:24 PM
> Subject: Re: Innodb assertion failure after binary backup-restore
>
> Hi!
>
> sync will not help.
>
&
In article <[EMAIL PROTECTED]>,
"Sp.Raja" <[EMAIL PROTECTED]> writes:
> Hi,
> I was able to solve this by calling sync command, as my previous mail say.
> Do you mean to say this will not work regardless of the whether we
> sync or not??
If it happens to work, then only by incident. I wouldn't r
uesday, July 27, 2004 3:42 PM
Aihe: Re: Innodb assertion failure after binary backup-restore
Hi,
I was able to solve this by calling sync command, as my previous mail say.
Do you mean to say this will not work regardless of the whether we sync or
not?? which implies binary backup/restore for inno
age
> From: "Heikki Tuuri" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Date: Tue, Jul-27-2004 1:05 PM
> Subject: Re: Innodb assertion failure after binary backup-restore
>
> Hi!
>
> That method will not work. InnoDB must be quiet long enoug
Subject: Innodb assertion failure after binary backup-restore
> Hi List,
>
> We are using 4.0.15a MySQL. We need to backup database at times and we
empl=
> oy the following method
>
> FLUSH TABLES WITH READ LOCK
> tar -zcf backup.tar.gz ibdata1 ib_logfile0 ib_logfile1
> U
21:02:24 mysqld ended
>
> Thanks,
> Sp.Raja
>
> > Original Message
> > From: "Sp.Raja" <[EMAIL PROTECTED]>
> > To: "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]>
> > Date: Fri, Jul-23-2004 7:13
Message
> From: "Sp.Raja" <[EMAIL PROTECTED]>
> To: "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]>
> Date: Fri, Jul-23-2004 7:13 PM
> Subject: Innodb assertion failure after binary backup-restore
>
> Hi List,
>
> We are using 4.0.15a
Hi List,
We are using 4.0.15a MySQL. We need to backup database at times and we employ the
following method
FLUSH TABLES WITH READ LOCK
tar -zcf backup.tar.gz ibdata1 ib_logfile0 ib_logfile1
UNLOCK TABLES
and restore is reverse. We cannot overwrite all databases, some of them needs to be
uncha
10 matches
Mail list logo
