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