[Mediawiki-l] How to recover a database

Christiaan Briggs christiaan at yurkycross.co.uk
Tue Sep 13 13:06:13 UTC 2005


I'm running MediaWiki on our intranet at work. I recently upgraded  
our server from Mac OS X 10.3 to 10.4. In the process the MySQL  
default database location appears to have been moved, so MediaWiki  
couldn't see its database. I've also subsequently reinstalled  
MediaWiki (but to a more recent version than before the system  
upgrade), giving it a new database.

My question is, having found the old database in a directory call  
wiki (but with no .sql suffix), consisting of the files as pasted  
below, how do I recover it for the latest version of MediaWiki I have  
installed?:

I've tried simply moving the database to the new location and  
attempting to open it with phpMyAdmin but it said "No tables found in  
database," and:

> Warning: mysql_query(): Unable to save result set in /Library/ 
> WebServer/>Documents/phpMyAdmin/libraries/mysql_wrappers.lib.php on  
> line 104 Error SQL-query :  SHOW TABLE STATUS FROM `wiki-two` MySQL  
> said: #12 - Can't read dir of './wiki-two/' (Errcode: 13)

You can read more about my situation here:
http://discussions.info.apple.com/webx?13@711.nKKQa2uWSAL.4@.68b8e7c3

Thanks,
Christiaan

Files I found, which I assume are my database:

archive.MYD links.MYD querycache.MYI
archive.MYI links.MYI querycache.frm
archive.frm links.frm recentchanges.MYD
brokenlinks.MYD links_backup.MYD recentchanges.MYI
brokenlinks.MYI links_backup.MYI recentchanges.frm
brokenlinks.frm links_backup.frm searchindex.MYD
categorylinks.MYD linkscc.MYD searchindex.MYI
categorylinks.MYI linkscc.MYI searchindex.frm
categorylinks.frm linkscc.frm site_stats.MYD
cur.MYD logging.MYD site_stats.MYI
cur.MYI logging.MYI site_stats.frm
cur.frm logging.frm user.MYD
hitcounter.frm math.MYD user.MYI
image.MYD math.MYI user.frm
image.MYI math.frm user_newtalk.MYD
image.frm objectcache.MYD user_newtalk.MYI
imagelinks.MYD objectcache.MYI user_newtalk.frm
imagelinks.MYI objectcache.frm user_rights.MYD
imagelinks.frm old.MYD user_rights.MYI
interwiki.MYD old.MYI user_rights.frm
interwiki.MYI old.frm watchlist.MYD
interwiki.frm oldimage.MYD watchlist.MYI
ipblocks.MYD oldimage.MYI watchlist.frm
ipblocks.MYI oldimage.frm
ipblocks.frm querycache.MYD



More information about the MediaWiki-l mailing list