MySQL Forums
Forum List  »  InnoDB

Re: innodb log sequence error
Posted by: Victor Herrera
Date: January 21, 2009 02:04PM

Hello there!
I've got the same error but just noticed about it. Reviewing the server.err I got the date when it started 12/30/2008. It was a silent error, since I don´t shutdown the DB frecuently.

I have a mysql 5.0 Db with InnoDB tables (and some ISAM tables too).

I wonder if I make a full dump with mysqldump now (data looks fine), replace the DATA folder (which contains all ib_logfile*, ibdata*, *.ibd, and *.frm of all InnoDB tables) with and old cold copy without LSN error and finally restore data from this dump I will overcome this issue.

Thanks in advance
Victor

Options: ReplyQuote


Subject
Views
Written By
Posted
31225
December 07, 2006 11:59AM
15301
December 07, 2006 01:31PM
13978
December 12, 2006 12:34PM
15197
December 15, 2006 01:40AM
17562
December 20, 2006 05:45AM
18894
December 15, 2006 09:16AM
Re: innodb log sequence error
10569
January 21, 2009 02:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.