On Mon, Sep 13, 2010 at 10:49 AM, Uwe Brauer oub@mat.ucm.es wrote:
Hello
This is a real nightmare. A Mac crashed, the hard disk could be saved. Right now it can't be booted. That hard disk contained the wiki of our department.
I don't know precisely the version of the OS (most likely Mac X 10.4), nor the version of mysql (most likely 5.3.x) and to make things worse I did not generate a dump of the mysql data base. I have however "access" to the database in the sense that I have a copy of the files /var/lib/mysql/maqwiki (maqwiki is the name of the database)
I followed the advice offered in the mysql mailing list namely
[+] > service mysql stop > cd /var/lib/mysql > rm -rf * > tar zxvf maqwiki.tar > rm -rf ib_logfile* > chown -R mysql.mysql > service mysql start
However after having installed the mediawiki software (I stick for the moment to 1.9.3) and trying to connect to the database I only see empty pages.
- Could it be that the database was damaged when the hard disk crashed? As a matter of fact when I have a look into the /var/lib/mysql/maqwiki directory most of the files are very small in size with the exception of searchindex.MYD and searchindex.MYI. I have no idea whether this is "normal".
- I did not do the recover process correctly. Is there any "hardcore" mysql command I could use to check the database?
- the connection between the mediawiki conf and the data base is broken. How can I check?
Any help is very much appreciated.
Uwe Brauer
Yes, but ideally you should find someone who already knows SQL and MySQL a bit to help with this...
The files being small is not necessarily disaster. If you Wiki was small the table files will be small.
Look at the Mediawiki logfiles, see if they're indicating any database problems. If they are...
Log in to the database with the mysql command line command and run the command "show tables;"
Compare that list with the tables in the Mediawiki software documentation page. See if anything is missing.
Then you can review the table contents with "select * from {tablename};"