Mailing List Archive

On Sep 18, 2004, at 3:56 AM, Moonlight Embrace wrote:
> I have to move my database to another server, yes, it's corrupt, but
> there seems to be no way to move only the current pages, so, how do I
> backup and move my database?
>
> I've tried exporting from phpmyadmin but I only get the first four
> tables. How do i get the entire thing?

The current revisions are in the 'cur' table.

Make sure you've tried running REPAIR TABLES on the tables you're
experiencing errors with. Also look up the error codes for more
information (normally I'd say use the 'perror' command, but you may
have to look it up online or something if you don't have shell access
on a machine with mysql).

-- brion vibber (brion @ pobox.com)

On Sep 18, 2004, at 4:19 AM, Moonlight Embrace wrote:
>> The current revisions are in the 'cur' table.
>
> Can I just upload the cur table in a fresh install? Is it linked to
> anything? Does it require information from other tables?

The cur_user references should match the user_id values in the user
table.

You probably want to rebuild the search index and link tables
afterwards; this can be done with the rebuildall.php script in
maintenance/ (must be run from the command line; you should create an
AdminSettings.php based on AdminSettings.sample prior to running it.)

Also if you've customized the MediaWiki: messages you may need to clear
the objectcache table after loading in the updated cur.

-- brion vibber (brion @ pobox.com)

>The current revisions are in the 'cur' table.

Can I just upload the cur table in a fresh install? Is it linked to
anything? Does it require information from other tables?

----- Original Message -----
From: Brion Vibber <brion@ikso.net>
To: MediaWiki announcements and site admin list <mediawiki-l@Wikimedia.org>
Sent: Saturday, September 18, 2004 2:09 AM
Subject: Re: [Mediawiki-l] backing up database


> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l@Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>