Re: Switching Database Engines - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Switching Database Engines
Date
Msg-id 14987033-5BD2-4C28-BB60-8C84332A5FD5@solfertje.student.utwente.nl
Whole thread Raw
In response to Switching Database Engines  (Carlos Mennens <carlos.mennens@gmail.com>)
Responses Re: Switching Database Engines
List pgsql-general
On 26 Apr 2011, at 19:24, Carlos Mennens wrote:

> We've been using a Wiki server at the office for years. It was
> originally configured to use MySQL and finally after 8+ years we're
> moving the Wiki to a new platform of hardware. My question is the Wiki
> software (MediaWiki) is the only thing still tied to and using MySQL
> which we want to decommission but we've been using it for years so I'm
> worried we will lose the data. I've done some Google'ing to find out
> how can I change the MySQL database dump and successfully export it
> into my new PostgreSQL database however I don't know how practical or
> recommended this process is. I found sites like the following:


I don't know much about mediawiki (except for how to use it), but it's not unusual for modern web-apps to have some
functionalityto dump their contents in a consistently formatted file (often XML) that it can subsequently import into a
newenvironment. Might be worth looking into. 

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4db72c7511671681815569!



pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Switching Database Engines
Next
From: Carlos Mennens
Date:
Subject: Re: Switching Database Engines