Restore MySQL Databases After Memory Crash

Fixed Price
Deliver by - August 22, 2014


I had mysql crash on my server. Most likely due to lack of memory. Now mysqld won't start. Here are the errors I get in a log file:
140820 22:35:08 [ERROR] Plugin 'InnoDB' init function returned error.
140820 22:35:08 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140820 22:35:08 [ERROR] Unknown/unsupported storage engine: InnoDB
140820 22:35:08 [ERROR] Aborting

I've tried deleting ib_logfile0 and ib_logfile1, but it didn't help. Deleting ibdata1 helps, but than than I can't access tables in databases even though I can see them in phpmyadmin. So, I've restored ibdata1 and mysqld won't start again..

I have backup of both original ibdata1 and db directories. So, it's definitely doable. It shouldn't take longer than an hour I assume. And I'd prefer it to be ready in the next 8 hours. It's late here so I'd like to hire someone quickly.

Please, show you knowledge of the problem in a bid.
Skills Required

Client Activity on this Job

Last Viewed: 8 months ago
Applicants: 19
Hired: 1