Hi all,
we were forces to reinstall one of our webservers which contained
a mediawiki 1.5.0 installation using mysql for storage.
The Database was saved using mysqlhotcopy every day with a cronjob.
After reinstalling all services,i copied back to wikidb to the mysql
data dir...surfing to the webpage of our wiki gave me a "cannot find
wikidb.pages" error.
i realized that the installation missed 4 files:
(well,only the .frm files where in the directory,.MYD and .MYI were gone..)
page
pagelinks
revision
user_groups
all other tables are correct.
As i understand the structure of wiki,the text of the pages is stored in
the "text" table and page and pagelinks.
Is there a way to recover our wiki using the text table (and other
tables if necessary) ?
I really don't have a clue why mysqlhotcopy missed the .MYD and .MYI files.
any ideas ?
thanks for help,
gw