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@selfip.ru Selfip.Ru

-- [ Drupal support list | http://lists.drupal.org/ ]

On Sun, Oct 18, 2009 at 6:51 PM, Vasiliy G Tolstov v.tolstov@selfip.ru wrote:

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?

Doesn't always work. I did some in the past and end up writing custom script to get the best of result. Basically it just a matter of having two db connection to mysql and postgresql to read and pump it into postgresql db. Some of my note on how to programmatically create node:-

http://blog.bytecraft.com.my/blog/kamal/2009/04/13/drupal-programmaticaly-cr...