MySQL To PostgreSQL

Hello,

I have an existing PHP project that have got MySQL as a database. Now I wish to transfer the data of MySQL to PostgreSQL. The user is going to interact with the MySQL. But the data of MySQL will be tranferred to PostgreSQL automatically by some internal tool or code. Please help me.

Thanks a lot in advance.

you weren't very specific, so what exactly do you need help with? take a look at PHP's PostgreSQL functions.

as far as transferring goes, I would assume you're using phpMyAdmin, and so you can take a look at installing phpPgAdmin. you can make a dump file of your MySQL database and should maybe be able to place it into a PostgreSQL database without too many changes.

if you don't know PostgreSQL, then you may want to look at the documentation.