Hi,
I have two mysql databases with tables. what i want to do is copy data from a table of one database to table of another database.

I used SELECT data from first table and then INSERT INTO another table but don't work anymore.

So, how should I do this?