[support] move from mysql to postgresql database

Gordon Heydon gordon at heydon.com.au
Sun Oct 18 11:42:25 UTC 2009


Hi,

This may be a bit a pain, as some indexes may not get created, but you  
can create compatible export with PHPMyAdmin in which I think you  
should be able to use ANSI and you will be able to get out all your  
data.

Gordon.

On 18/10/2009, at 9:51 PM, Vasiliy G Tolstov wrote:

> Hello.
>
> I need to move exiting site from MySQL to Postgresql database.
>
> If i create new site with postgresql databases, dump exiting site in
> mysql (only data without schema, with ansi sql compatibility) and  
> import
> into postgresql database, can new site work's properly?
>
> Or may be best choise - install some export module from old site, do
> export data, install some import module and inport data?
>
> Can You provide some link to succeseful converting mysql to  
> postgresql?
>
> Thank You.
>
> -- 
> Vasiliy G Tolstov <v.tolstov at selfip.ru>
> Selfip.Ru
>
> -- 
> [ Drupal support list | http://lists.drupal.org/ ]



More information about the support mailing list