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}