"He" (me, "the OP") did that following some - maybe bad - advice found in another place. But I haven't used mediawiki for a while – so I do have backups from 2017-08-31 that should be okay. So what are your suggestions from here? Just copy (not move) it back an try if i works? Or there might be more clever approaches?
Best regards, Jon Theil Nielsen tor. 2. nov. 2017 kl. 11.35 skrev Tim Starling <[email protected]>: > 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 > > > _______________________________________________ > MediaWiki-l mailing list > To unsubscribe, go to: > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > -- Jon Theil Nielsen _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
