Thanks a lot for the thorough answer. I will follow your suggestions tomorrow. And I will report back under any circumstances. I have full root access, so I guess this could be the way to go.
Thanks again! Best regards, Jon Theil Nielsen ons. 1. nov. 2017 kl. 18.36 skrev Greg Rundlett (freephile) < [email protected]>: > Go ahead and stop Apache, and if you haven't already, make a disk copy of > your mysql data directory for backups. Then start MySQL alone. See if you > get any errors from starting MySQL (find logs at /var/log/mysql/error_log > or similar). Post any errors. If the db server is running, do some checks > on the mediawiki schema like mentioned here [1]. > > # assuming your 'root' system user has a /root/.my.cnf file that allows you > to login to the database server. > sudo su - > mysql -e 'SHOW VARIABLES LIKE "general_log%";' > > mysql > > SET @DB = 'mediawiki'; > > show create table @DB.l10n_cache; > > [1] > https://www.percona.com/blog/2008/07/04/recovering-innodb-table-corruption/ > > > Greg Rundlett > https://eQuality-Tech.com > https://freephile.org > > On Wed, Nov 1, 2017 at 12:59 PM, Jon Theil Nielsen <[email protected]> > wrote: > > > Actually, I don't think i stopped the web server. I don't think it is a > > memory problem. I have 16 GB in total and this very moment about 0.5 GB > > completely free. > > > > Regards, > > Jon Theil Nielsen > > > > ons. 1. nov. 2017 kl. 17.55 skrev G Rundlett <[email protected]>: > > > > > Did you stop Apache, and start MySQL alone? How much free memory is > > > reported? > > > > > > On Nov 1, 2017 12:51 PM, "Jon Theil Nielsen" <[email protected]> > 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. > > > > > > > > Best regards, > > > > Jon Theil Nielsen > > > > -- > > > > Jon Theil Nielsen > > > > _______________________________________________ > > > > MediaWiki-l mailing list > > > > To unsubscribe, go to: > > > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > > > > > > > _______________________________________________ > > > 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 > > > _______________________________________________ > 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
