Re: [MediaWiki-l] Database errors after crash

2017-11-01 Thread Jon Theil Nielsen
Well, I am far from an expert, if that's what you mean. But I will stop both the apache and the MySQL server. I guess I can only make the recommended dumps when the server is running. But after that, I can stop the servers. Right? Best regards, Jon Theil Nielsen ons. 1. nov. 2017 kl. 21.41 skrev

Re: [MediaWiki-l] Database errors after crash

2017-11-01 Thread Jan Steinman
> From: "Greg Rundlett (freephile)" > > Go ahead and stop Apache, and if you haven't already, make a disk copy of > your mysql data directory for backups. Minor point, but I don’t know how much the OP knows about MySQL: be sure to stop mysql, too! Otherwise, a disk copy of the database may not

Re: [MediaWiki-l] Database errors after crash

2017-11-01 Thread Jon Theil Nielsen
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

Re: [MediaWiki-l] Database errors after crash

2017-11-01 Thread Greg Rundlett (freephile)
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 o

Re: [MediaWiki-l] Database errors after crash

2017-11-01 Thread Jon Theil Nielsen
Sorry to a silly question. But which file should i look for. And do i just import it into MySQL plain and simple? Best regards, Jon Theil Nielsen ons. 1. nov. 2017 kl. 17.55 skrev John : > If that is the only issue you can re-create the table (the exact command > should be in an .sql file) that

Re: [MediaWiki-l] Database errors after crash

2017-11-01 Thread Jon Theil Nielsen
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 : > Did you stop Apache, and start MySQL alone? How much free m

Re: [MediaWiki-l] Database errors after crash

2017-11-01 Thread G Rundlett
Did you stop Apache, and start MySQL alone? How much free memory is reported? On Nov 1, 2017 12:51 PM, "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

Re: [MediaWiki-l] Database errors after crash

2017-11-01 Thread John
If that is the only issue you can re-create the table (the exact command should be in an .sql file) that table doesn't contain critical info On Wed, Nov 1, 2017 at 12:51 PM Jon Theil Nielsen wrote: > Dear List Users, > > I have mediawiki 1.29-Release running on FreeBSD-11.1-Release and have had

[MediaWiki-l] Database errors after crash

2017-11-01 Thread Jon Theil Nielsen
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. Bu