We had a power hit and when the server came back we had InnoDB corruption. (I can't get out to the internet from the system with the db so can I can't paste the exact text in here). The message was about log sequences numbers being in the future. We were able to dump the affected tables, but when we tried to restore them we were not able to drop the old tables. When we tried the server crashed with:
We did try booting with innodb_force_recovery at all levels from 1 to 6 with the same results.
Anyone have any ideas on what we can do to recover?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Feb 01
Rick James RE: Can't drop table after crash
Feb 01, 2013; 19:17
Rick James
RE: Can't drop table after crash
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!