Hi,

Can someone suggest the easiest method for importing data from a database on another server. I have two databases on two different servers whose structure is identical. But one has a about 1000 entries in a user table and the other only 5 entries. I'd like to import the 1000 entries using a command like: insert into users select * from users@remoteserver.

I'm just not sure of what syntax I should use for "users@remoteserver" or if it's even possible to do such a thing. If not would it be better to write results from the remote server to a file and the load it?

Thanks for pointing me in right direction.

Ken