Re: Innodb assertion failure after binary backup-restore

[Harald Fuchs]

In article <20040727181200.1432569267.spraja@stripped>,
"Sp.Raja" <spraja@stripped> 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 rely on that.

> We actually started with mysqldump for backup, but that was slow
> when we had huge amount of data, so we decided to switch in to
> binary mode.

There are two solutions:
1. Setup a small replication server used solely for backup purposes
2. Use the non-free InnoDB hot backup tool