[Mediawiki-l] Changing database subsystem

Gary Kirk gary.kirk at gmail.com
Fri Nov 16 23:33:25 UTC 2007


You should upgrade to the latest version and then move, for a start.
I don't know about changing the DB type.

On 16/11/2007, Harald Husemann <harald.husemann at materna.de> wrote:
>
> Hello all,
>
> I'm in the process of moving an already productive Mediawiki with many
> users and articles to another host. (Mediawiki version is 1.10.1, I will
> upgrade to the newest release after the move).
> I've read the article at
> http://www.mediawiki.org/wiki/Manual:Moving_a_wiki, and it seems that
> moving the wiki is quite simple, as long as I use the same version on
> both systems.
> But, there's a little problem: I'd also like to change the database
> backend from mySQL to PostgreSQL (I know that mySQL is as good as
> Postgres, but using it is not an option anymore, since my company's
> policy is to use and support PostgreSQL and only PostgreSQL in the
> future, and no other free RDBMS).
> So, the big question is, how can I move the database content from mySQL
> to Postgres?
> Of course I can simple dump the wiki in XML, and re-import it into the
> new system, but as far as I understand, this would mean that all user
> logins, logging informations, atc. are lost, right?
> Is there a quick and simple way to do it? I've already searched the
> manual, the FAQ and the mailinglist archives, without success...
>
> Any help is greatly appreciated!
>
> Thanks,
>
> and have a nice hackin',
>
> Harald
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at lists.wikimedia.org
> http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>



-- 
Gary Kirk


More information about the MediaWiki-l mailing list