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) < greg@freephile.com>:
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 jontheil@gmail.com 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 greg.rundlett@gmail.com:
Did you stop Apache, and start MySQL alone? How much free memory is reported?
On Nov 1, 2017 12:51 PM, "Jon Theil Nielsen" jontheil@gmail.com
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