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