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}