Uwe Brauer wrote:
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".
Well I run strings and grep over these files but the only files with useful information are searchindex.MYD and searchindey.MYI
Your tables will be in InnoDB, with the table files just holding pointers to ibdata1 file. searchindex table is in MyIsam and thus the content is really on those files.
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;"
Well here I have a problem. Say the password is password then the command mysql -u wikiuser -p=password maqwiki gives me ERROR 1045 (28000): Access denied for user 'wikiuser'@'localhost' (using password: YES)
The command should be mysql -u wikiuser -ppassword maqwiki (ie. no = sign)
I did not do the recover process correctly. Is there any "hardcore" mysql command I could use to check the database?
Try to mysqldump it and look for errors in mysql log file.