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
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/ ]
Vasiliy G Tolstov ha scritto:
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?
Remember that some modules neet to be patch to uses with postgresql. I don't rember their name, but for a portal that I need to port from postgresql to mysql I have choise to reinstall all, due to this fact. M. -- Michel 'ZioBudda' Morelli michel@ziobuddalabs.net Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax) Telefono: 0200619074 Telefono Cell: +39-3939890025 -- Fax: +39-0291390660 http://www.ziobudda.net ICQ: 58351764 http://www.ziobuddalabs.it Skype: zio_budda http://www.ziodrupal.net MSN: michel@ziobuddalabs.it JABBER: michel@ziobuddalabs.it
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...
В Втр, 20/10/2009 в 07:00 +0800, Mohd Kamal Bin Mustafa пишет:
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...
Thank You! -- Vasiliy G Tolstov <v.tolstov@selfip.ru> Selfip.Ru
participants (4)
-
Gordon Heydon -
Michel Morelli -
Mohd Kamal Bin Mustafa -
Vasiliy G Tolstov