UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> MySQL Innodb Corruption Recovery    
 
   
qusayamari
post Apr 24 2015, 08:49 AM
Post#1



Posts: 1
Joined: 24-April 15



Hi,

I have a MySQL database, just containing Innodb tables, that seems to have corrupted itself.

It replicates to another server and it has corrupted that one too!

The symprom is that I can restart the server but as soon as I try to connect to it, it crashes.

The log file talks about a possible index page corruption to a specific table and that fits in terms of the table being accessed when the problem occurred.

Following the Innodb recovery guidelines in the MySQL manual, I have set the innodb_force_recovery option to 6 which lets me restart the database and dump the tables.

Anything less than 6 and it will not stay up.

My questions are:
How do I know the extent of the innodb corruption?
Is the only safe option to recreate the innodb files from scratch (I assume via a re-install) or is there a smarter way to do this
Can I trust the table dumps or should I go back to the most recent backup (also a table dump) and accept the data loss
If it is an index page corruption, can I rebuild the primary index of the affected table and then restart the DB without the innodb_force_recovery option

Thanks
Go to the top of the page
 
 
Start new topic
Replies
PhilS
post Jan 29 2020, 03:29 AM
Post#2



Posts: 691
Joined: 26-May 15
From: The middle of Germany


QUOTE
I have a MySQL database, just containing Innodb tables, that seems to have corrupted itself.

I used to work quite a lot with MySQL including InnoDb tables. The only case of corruption I encountered in many years was caused by a faulty hard disk. So, keep in mind to check for this.

--------------------
A professional Access developer tool: Find and Replace for Access and VBA
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    9th April 2020 - 05:59 AM