On 02/11/17 03:51, Jon Theil Nielsen wrote:
Dear List Users,
I have mediawiki 1.29-Release running on FreeBSD-11.1-Release and have had a crash of my MySQL database. At first, I couldn't start it at all. But after deleting ib_logfile* and ibdata*, it came back alive. In the sense that I can start the server and use many of the databases. But not the one holding my mediawiki installation.
The error log says "[Warning] InnoDB: InnoDB: Cannot open table mediawiki_something_dk/user from the internal data dictionary of InnoDB though the .frm file for the table exists.." The debug log is quite full but has the message "Error: 1146 Table 'mediawiki_something_dk.l10n_cache' doesn't exist (localhost)"
Does anyone know how to solve this? Or maybe have somehere, I can look for a solution.
I'm not sure what sort of solution you're looking for. You deleted the InnoDB data file (ibdata*), and now it unsurprisingly says the InnoDB data file is gone. That file had your wiki in it, now it's gone.
If you have backups, we can talk about how to recover from them. Otherwise, DROP DATABASE mediawiki_something_dk; might possibly wipe those .frm files and put the database back into a consistent (empty) state. Not sure, I've never heard of anyone deleting ibdata file before. If it does work, then you can make a new empty wiki, if that is a useful thing for you.
Greg Rundlett wrote:
Go ahead and stop Apache, and if you haven't already, make a disk copy of your mysql data directory for backups.
It's a bit late for that, he's literally deleted his entire wiki.
-- Tim Starling