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
