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
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
ERROR 1045 (28000): Access denied for user 'wikiuser'@'localhost' (using
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
Try to mysqldump it and look for errors in mysql log file.