>>>> On Tue, 14 Sep 2010 00:38:17 +0200,
Platonides
>>>> <Platonides(a)gmail.com> wrote:
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.
To be honstest I don't understand completely what you ay,
since I don't know exactly what InnoDB is although I have
heard the word.
I just found a mysql dump file from another wiki.
I could succesfully use that dump and later conncect
wikimedia to that db. There is however a difference this db
has more .MYD and MYI files for example
wp_users.MYD
wp_users.MYI
Etc.
Does this mean that the database from the crashed hard disk
is may be corrupt, since it has only 1 MYD and 1 MYI
file????
Is there any way to extract the ASCII text (anything more
sophisticated than "strings") from
searchindex.MYD and searchindey.MYI
> > 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;"
sorry my ignorance
You mean
mysql -p wikidb
mysql > show tables
Well it does not return anything also mediawiki connects
correctly to that database.
I am puzzled