The Bitnami packages are great for getting started with MediaWiki quickly. Yet when something goes wrong, you have a lot of learning to do, such as learning MySql administration.

I have a backup of the entire C:\Program Files\Bitnami WAMPStack\ containing the mysql bitnami_mediawiki database. Is there a way to import the old \mysql\data\bitnami_mantis\ folder into a new install of the Bitnami MediaWiki 1.16-2 module?

I confess that I messed up and did not make a MySql dump of the bitnami_mediawiki MySql backup. I thought a directory backup would be good enough. I tried copying the bitnami_mediawiki database, restoring the original LocalSettings.ph, and running update.php but I get an exception when trying to create table interwiki as pasted below.

Thanks in advance for any direction,

-Ed

[root@esutton-vm-rh maintenance]# ../../../../php/bin/php update.php MediaWiki 1.16.2 Updater

Going to run database updates for bitnami_mediawiki Depending on the size of your database this may take a while! Abort with control-c in the next five seconds (skip this countdown with --quick) ... 0 ...ipblocks table does not exist, skipping new field patch ...ipblocks table does not exist, skipping new field patch Creating interwiki table: MediaWiki internal error.

Original exception: exception 'DBQueryError' with message 'A database error has occurred Query: CREATE TABLE `interwiki` ( iw_prefix varchar(32) NOT NULL, iw_url blob NOT NULL, iw_local BOOL NOT NULL, UNIQUE KEY iw_prefix (iw_prefix) ) TYPE=InnoDB

Function: DatabaseBase::sourceStream Error: 1050 Table 'interwiki' already exists (localhost) ' in /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/db/Database.php:576 Stack trace: #0 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/db/Database.php(538): DatabaseBase->reportQueryError('Table 'interwik...', 1050, 'CREATE TABLE `i...', 'DatabaseBase::s...', false) #1 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/db/Database.php(2251): DatabaseBase->query('CREATE TABLE `i...', 'DatabaseBase::s...') #2 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/db/Database.php(2174): DatabaseBase->sourceStream(Resource id #44, false, false) #3 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/maintenance/updaters.inc(318): DatabaseBase->sourceFile('/opt/lampstack-...') #4 [internal function]: do_interwiki_update() #5 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/maintenance/updaters.inc(1125): call_user_func_array('do_interwiki_up...', Array) #6 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/maintenance/update.php(44): do_all_updates(false, true) #7 {main}

Exception caught inside exception handler: exception 'DBQueryError' with message 'A database error has occurred Query: SELECT value,exptime FROM `objectcache` WHERE keyname = 'bitnami_mediawiki:messages:en' LIMIT 1 Function: SqlBagOStuff::get Error: 1146 Table 'bitnami_mediawiki.objectcache' doesn't exist (localhost) ' in /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/db/Database.php:576 Stack trace: #0 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/db/Database.php(538): DatabaseBase->reportQueryError('Table 'bitnami_...', 1146, 'SELECT value,e...', 'SqlBagOStuff::g...', false) #1 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/db/Database.php(874): DatabaseBase->query('SELECT value,e...', 'SqlBagOStuff::g...') #2 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/db/Database.php(954): DatabaseBase->select('objectcache', Array, Array, 'SqlBagOStuff::g...', Array, Array) #3 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/BagOStuff.php(247): DatabaseBase->selectRow('objectcache', Array, Array, 'SqlBagOStuff::g...') #4 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/MessageCache.php(241): SqlBagOStuff->get('bitnami_mediawi...') #5 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/MessageCache.php(588): MessageCache->load('en') #6 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/MessageCache.php(527): MessageCache->getMsgFromNamespace('Dberrortextcl', 'en') #7 [internal function]: MessageCache->get('dberrortextcl', true, false) #8 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/StubObject.php(58): call_user_func_array(Array, Array) #9 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/StubObject.php(76): StubObject->_call('get', Array) #10 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/GlobalFunctions.php(742): StubObject->__call('get', Array) #11 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/GlobalFunctions.php(742): StubObject->get('dberrortextcl', true, false) #12 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/GlobalFunctions.php(707): wfMsgGetKey('dberrortextcl', true, false, true) #13 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/GlobalFunctions.php(613): wfMsgReal('dberrortextcl', Array, true) #14 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/db/Database.php(2706): wfMsg('dberrortextcl', 'CREATE TABLE `i...', 'DatabaseBase::s...', 1050, 'Table 'interwik...') #15 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/Exception.php(189): DBQueryError->getText() #16 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/Exception.php(289): MWException->report() #17 /opt/lampstack-1.2-4/apps/mediawiki/htdocs/includes/Exception.php(348): wfReportException(Object(DBQueryError)) #18 [internal function]: wfExceptionHandler(Object(DBQueryError)) #19 {main}