[Mediawiki-l] Troubles transfering a DB from windows to unix system

[Saar Machtinger]

Hi,

I am a bit lost here. I have a mediawiki on our IIS. I am now trying to move
this to a hosted unix server, but I find it frustrating.

I get too many errors, and I am lost.

I will try to brief:

created a dump of the current db
copied all php files and directories (except images for now - too large) to
the new server
Installed a mysql 4.1 on the server
extracted the dump
updated localsetting to have the new server, db,username and password.

*I renamed the DB from pmwikidb to optitexpmwiki - however, I don't think
that this is the problem, please please , if anyone can help me.

but I get errors trying to run index.php now

please find quoted:
QUOTE
MediaWiki internal error.

Original exception: exception 'DBQueryError' with message 'A database error
has occurred
Query: SELECT value,exptime FROM `mw_objectcache` WHERE
keyname='OptiTexPmWiki-mw_:messages'
Function: MediaWikiBagOStuff::_doquery
Error: 1146 Table 'OptiTexPmWiki.mw_objectcache' doesn't exist (
p41mysql161.secureserver.net)
' in /home/content/o/p/t/optitexftp/html/PmWiki/includes/Database.php:844
Stack trace:
#0 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Database.php(799):
Database->reportQueryError('Table 'OptiTexP...', 1146, 'SELECT value,ex...',
'MediaWikiBagOSt...', false)
#1 /home/content/o/p/t/optitexftp/html/PmWiki/includes/BagOStuff.php(427):
Database->query('SELECT value,ex...', 'MediaWikiBagOSt...')
#2 /home/content/o/p/t/optitexftp/html/PmWiki/includes/BagOStuff.php(322):
MediaWikiBagOStuff->_doquery('SELECT value,ex...')
#3 /home/content/o/p/t/optitexftp/html/PmWiki/includes/BagOStuff.php(243):
SqlBagOStuff->_query('SELECT value,ex...', 'OptiTexPmWiki-m...')
#4
/home/content/o/p/t/optitexftp/html/PmWiki/includes/MessageCache.php(214):
SqlBagOStuff->get('OptiTexPmWiki-m...')
#5
/home/content/o/p/t/optitexftp/html/PmWiki/includes/MessageCache.php(434):
MessageCache->load()
#6 [internal function]: MessageCache->get('mainpage', true, true)
#7 /home/content/o/p/t/optitexftp/html/PmWiki/includes/StubObject.php(32):
call_user_func_array(Array, Array)
#8 /home/content/o/p/t/optitexftp/html/PmWiki/includes/StubObject.php(40):
StubObject->_call('get', Array)
#9 [internal function]: StubObject->__call('get', Array)
#10
/home/content/o/p/t/optitexftp/html/PmWiki/includes/GlobalFunctions.php(427):
StubObject->get('mainpage', true, true)
#11
/home/content/o/p/t/optitexftp/html/PmWiki/includes/GlobalFunctions.php(396):
wfMsgGetKey('mainpage', true, true, true)
#12
/home/content/o/p/t/optitexftp/html/PmWiki/includes/GlobalFunctions.php(344):
wfMsgReal('mainpage', Array, true, true)
#13 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Title.php(271):
wfMsgForContent('mainpage')
#14 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Wiki.php(84):
Title::newMainPage()
#15 /home/content/o/p/t/optitexftp/html/PmWiki/index.php(59):
MediaWiki->checkInitialQueries(NULL, 'view', Object(StubObject),
Object(WebRequest), Object(StubContLang))
#16 {main}

Exception caught inside exception handler: exception 'DBUnexpectedError'
with message 'Error in fetchObject(): Table 'OptiTexPmWiki.mw_page' doesn't
exist (p41mysql161.secureserver.net)' in
/home/content/o/p/t/optitexftp/html/PmWiki/includes/Database.php:973
Stack trace:
#0
/home/content/o/p/t/optitexftp/html/PmWiki/includes/MessageCache.php(307):
Database->fetchObject(false)
#1
/home/content/o/p/t/optitexftp/html/PmWiki/includes/MessageCache.php(244):
MessageCache->loadFromDB()
#2
/home/content/o/p/t/optitexftp/html/PmWiki/includes/MessageCache.php(434):
MessageCache->load()
#3
/home/content/o/p/t/optitexftp/html/PmWiki/includes/GlobalFunctions.php(427):
MessageCache->get('databaseerror', true, false)
#4
/home/content/o/p/t/optitexftp/html/PmWiki/includes/GlobalFunctions.php(396):
wfMsgGetKey('databaseerror', true, false, true)
#5 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Exception.php(43):
wfMsgReal('databaseerror', Array)
#6 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Database.php(292):
MWException->msg('databaseerror', 'Database error')
#7 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Exception.php(148):
DBQueryError->getPageTitle()
#8 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Exception.php(116):
MWException->htmlHeader()
#9 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Exception.php(134):
MWException->reportHTML()
#10 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Exception.php(213):
MWException->report()
#11 /home/content/o/p/t/optitexftp/html/PmWiki/includes/Exception.php(247):
wfReportException(Object(DBQueryError))
#12 [internal function]: wfExceptionHandler(Object(DBQueryError))
#13 {main}



Thank you,

Saar


--------------------------------
Saar Machtinger - CIO

OptiTex Ltd. | www.optitex.com | saar.machtinger at optitex.com
Tel: +972-3-904 9979 | Fax: +972-3-904 2710

* Think green before you print