Use MySQL and PostgreSQL in the same PHP script

Question

I'm trying to do some migrations from an old site to a new site. The old site uses MySQL and the new site uses PostgreSQL. My problem is I wrote a migration script in PHP that queries info from the old DB so that I can insert them into the new DB within that same script. The reason I need the script is I have to call other functions that do things and manipulate the data since the table columns aren't a one for one match so I can't just do a backup and restore type situation. I have a class for both DB's that I use.

The mysql queries work but postgres' don't. They get error messages saying pg_query(): 19 is not a valid PostgreSQL link resource in xxx

So is it possible to run them both in the same script? If I call the two scripts separately it works ok but I can't get the data from the old server to the new one. I've looked everywhere and don't see many questions needing to use both DB's in one file. Any help would be cool.

My guess is that you are using the same variable for both resources. Post your code that establishes the connections. — user20232359723568423357842364, Commented Jun 13, 2013 at 0:08
I don't get the username thing?? Anyway, yeah I think you were right @user20232359723568423357842364. I had two classes one for PG and other for MySQL. Well they both have the same functions but different PHP api's so I didn't think it made a difference. Since I won't be using MySQL anymore, I manually wrote the queries instead of using the class and it seems to work. Should have made it an answer. :) — Panama Jack, Commented Jun 13, 2013 at 1:01

user20232359723568423357842364 · Accepted Answer · 2013-06-13 01:14:43Z

0

You are using the same variable for both resources and passing the mysql resource to the postgresql function

answered Jun 13, 2013 at 1:14

user20232359723568423357842364

4,6341 gold badge20 silver badges28 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Use MySQL and PostgreSQL in the same PHP script

1 Answer 1

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related