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?
Best Answer
mysqldump
from the database on the source server.Then still on the source server
mysql -h[dest server hostname/IP] -u[user] -p[pass] < [location of the file you just made]
.