It went from 1.10 (I believe) on the original install under Gutsy,
updated to 1.11 with the Hardy version upgrade. Over the duration of
this thread I've been trying to restore to a different machine (a VM of
Hardy). I'm normally pretty good with backing up - especially prior to
an OS change - but totally overlooked mediawiki. I did have an sql
dump but not an xml dump. I wasn't 100% sure of my backup method since
it had not been tested via a restore, I had just stumbled across the
mysql administrator package with it's backup tool. Nor had I come
across these pages below. Which are very informative and useful, thank
you.
So it would seem a schema upgrade was/is necessary, and actually it may
be possible on the original machine as I believe the original database
is still there. If I have the time next week I might look in to that.
Main problem is the usual busyness as many of us experience, and I have
already spent way more time on this than I can justify.
I fully intend to get a wiki functioning again in some form, so maybe
this thread isn't dead yet . . .
Nick Rout wrote:
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:
