[Mediawiki-l] how to copy Special:Allmessages to another wiki

[G.Bierens at fontys.nl]

I've tried Jama's solution, but it doesn't work for me. I ended up
reinstalling MediaWiki from scratch. Anybody knows another way to do
this?

--Gerard

-----Oorspronkelijk bericht-----
Van: mediawiki-l-bounces at Wikimedia.org
[mailto:mediawiki-l-bounces at Wikimedia.org] Namens Jama Poulsen
Verzonden: maandag 28 november 2005 0:57
Aan: MediaWiki announcements and site admin list
Onderwerp: Re: [Mediawiki-l] how to copy Special:Allmessages to another
wiki

On Sun, Nov 27, 2005 at 10:06:32PM +0100, G.Bierens at fontys.nl wrote:
> I've been finetuning the systemmessages in one wiki, now I want to use
them in another wiki which is on a different server. I tried using
PHPmyAdmin to copy the table 'text' from one wiki to the other, but that
does not seem to work. The 'text'-table is 4.2 Mb big, to big maybe or
is this not the right way at all?
> 
> Anybody knows how to solve this?

[I don't claim this will work, but its a start]

The system messages (in MW 1.5+) are stored in the "xx_page" table, and
cached as one blob in "xx_objectcache" (keyname:
"yourwikiname:messages").

You'll need to extract all the rows for the Mediawiki namespace:

  SELECT *
  FROM `xx_text` 
  WHERE `page_namespace` =8

Then you'll need to delete the pages in that namespace from the other
DB,
and insert the exported pages (without having ID clashes).

Now you'll also need to remove the cached object and re-edit your
"Special:Allmessages" page, so the objectcache blob is restored.

And ofcourse before you start, make tested backups.

Jama Poulsen
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l at Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l


----------------------------------------------------------------
Op deze e-mail zijn de volgende voorwaarden van toepassing:

http://www.fontys.nl/disclaimer

The above disclaimer applies to this e-mail message.
----------------------------------------------------------------