Connect Two MySQL Databases I have two servers.

Eg. server A and server B.

I want to select data from server A and insert into server B using MySQL.

How to make it?  I can access server A's database remotely from server B but I can't do select and insert query. Because they are in different usernames.

Any ideas?
mysqldump from the database on the source server.

Then still on the source server mysql -h[dest server hostname/IP] -u[user] -p[pass] &lt; [location of the file you just made].