How do I recover mysql from IBData?
Hello I need help regarding recovering data of mysql.
My server suddenly got kernel error like this
---[ end Kernel panic - not syncing: No working init found. Try passing init= option to kernel. See Linux Documentation/admin-guide/init.rst for guidance. ]---
I tried all solution from e2fsck, boot into another config but unable so I tried to save my mysql from server using finnix.
I have followed this guide from this and I am able to retrieve my databases. But the problem is when I tried to replace the data on another server it always show error
table may from another system and must be zerofilled or repair
Unknown/Unsupported engine InnoDB
1 Reply
CassandraD
Linode Staff
I wasn't able to find the exact error you mentioned about the table needing repair, but based on the closest match I found, it sounds like the solution to this is trying to repair the tables. This should work if you were successfully able to get the backup to a new server, and MySQL is working, but you can't access the data in the tables:
Next, I found the error Unknown/Unsupported engine InnoDB mentioned in a few forums. This ServerFault discussion is old, but it was last updated 3 months ago, so people are still talking about the issue there. It's the most comprehensive discussion I've found and offers a few solutions that others have confirmed worked for them.
If those solutions don't work, you can try to get more specific errors or files to look at from the logs from the server you moved the backup to.
If you can get more specific errors, you can likely focus your troubleshooting there.
If you can't get the backup you have working, you may want to look into other ways of Backing up MySQL. It sounds like you may have been limited to Rescue Mode, so I'm not sure if other methods will work, but I wanted to share that.