What version of mediawiki was the original database in? What version of mediawiki are you trying to restore the database to?
If you are upgrading between versions have you read these instructions: http://www.mediawiki.org/wiki/Manual:Upgrading Did you back up not just the database but the config files too? Theres a lot of stuff in that upgrade guide. Even if there is no change in versions, there is a backup guide here that may provide more gotchas. http://www.mediawiki.org/wiki/Backup On Fri, Jun 6, 2008 at 2:04 PM, Roger Searle <[EMAIL PROTECTED]> wrote: > re 3: "desc page" shows that "page_restrictions" is a field in the page > table. > The best sense I could make of the situation was that it looked as though > "page" was being appended to the table name - not from LocalSettings.php but > somewhere else. Anyway would fit your suggestion that the database has > changed shape. It looks like I am best to recover the text from the dump > file and recreate some pages in a new installation. There are only a small > number of pages, I'll be able to recreate it in a shorter time than I've > spent on trying to restore it so far! > > I really appreciate all the assistance that you have offered, bit of a shame > I've been beaten by this one, good learning none the less. And more to look > out for when I get this going again. > Cheers, > Roger > > > Steve Holdoway wrote: >> >> OK, there're a few possible issues here. >> 1. The original error message below shows that you're prefixing your >> tables with 'Wiki' >> 2. Is wikimedia accessing the database as roger? I thought it was using >> the user 'wiki', which is why I was asking you to access the database as >> that user, to ensure that the user had proper access to the database. >> >> But... >> 3. When you set the prefix to '', then it *does* find the page table, but >> then falls over by not finding the table 'page_restrictions', which sure >> enough doesn't exist. >> I'd say that you're restoring to a different version of wikimedia than the >> original... as the database has changed shape ): >> >> Steve. >> >> On Fri, 06 Jun 2008 13:01:31 +1200 >> Roger Searle <[EMAIL PROTECTED]> wrote: >> >> >>> >>> (as -u roger, not -u wiki) >>> >>> mysql> show tables; >>> +-----------------+ >>> | Tables_in_wiki | >>> +-----------------+ >>> | archive | >>> | categorylinks | >>> | externallinks | >>> | filearchive | >>> | hitcounter | >>> | image | >>> | imagelinks | >>> | interwiki | >>> | ipblocks | >>> | job | >>> | langlinks | >>> | logging | >>> | math | >>> | objectcache | >>> | oldimage | >>> | page | >>> | pagelinks | >>> | querycache | >>> | querycache_info | >>> | querycachetwo | >>> | recentchanges | >>> | redirect | >>> | revision | >>> | searchindex | >>> | site_stats | >>> | templatelinks | >>> | text | >>> | trackbacks | >>> | transcache | >>> | user | >>> | user_groups | >>> | user_newtalk | >>> | watchlist | >>> +-----------------+ >>> 33 rows in set (0.00 sec) >>> >>> Steve Holdoway wrote: >>> >>>> >>>> at the command prompt, type >>>> >>>> mysql -u wiki -p wiki >>>> ( enter password when prompted ) >>>> mysql> show tables; >>>> >>>> This will list all the tables in your database. >>>> >>>> On Fri, 06 Jun 2008 12:41:03 +1200 >>>> Roger Searle <[EMAIL PROTECTED]> wrote: >>>> >>>> >>>>> >>>>> I can log in to mysql and see that the wiki database contains the table >>>>> "page" which has the fields stated in the select query below. >>>>> LocalSettings.php has the line $wgDBprefix="wiki" and gives this error: >>>>> >>>>> Table 'wiki.Wikipage' doesn't exist (localhost) >>>>> >>>>> So if I change the line $wgDBprefix to "test" I get: >>>>> Table 'wiki.testpage' doesn't exist (localhost) >>>>> >>>>> Shouldn't it be looking for the table "wiki.page"? So if I comment out >>>>> the $wgDBprefix line or make it if I make the line $wgDBprefix="" I get: >>>>> Table 'wiki.page_restrictions' doesn't exist (localhost) >>>>> (page_restrictions is a field in the table "page") >>>>> >>>>> Somewhat confused at this point, I'm sure I'm overlooking something >>>>> minor... The table names are NOT all prefixed by a string. >>>>> >>>>> >>>>> >>>>> >>>>> Steve Holdoway wrote: >>>>> >>>>>> >>>>>> Isn't there a prefix string in this file as well?? Can't remember, and >>>>>> haven't got the code to hand. Look at the names of the tables that are >>>>>> created, and it they're all prefixed by a string, then update >>>>>> accordingly. >>>>>> >>>>>> Steve >>>>>> >>>>>> On Fri, 06 Jun 2008 11:15:06 +1200 >>>>>> Roger Searle <[EMAIL PROTECTED]> wrote: >>>>>> >>>>>> >>>>>>> >>>>>>> MediaWiki internal error. >>>>>>> >>>>>>> Original exception: exception 'DBQueryError' with message 'A database >>>>>>> error has occurred >>>>>>> Query: SELECT >>>>>>> page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len >>>>>>> FROM `Wikipage` WHERE page_namespace = '0' AND page_title = 'Main_Page' >>>>>>> LIMIT 1 >>>>>>> >> >> >>>>>>> >>>>>>> Function: Article::pageData >>>>>>> Error: 1146 Table 'wiki.Wikipage' doesn't exist (localhost) >>>>>>> ' in /usr/share/mediawiki/includes/Database.php:840 >>>>>>> Stack trace: >>>>>>> >
