Joining tables from two different databases

the mysql tables are in differnt db and on different servers

[willis1480]

So I have 2 mysql tables running on two different servers. these tables contain some 10,000 rows. Now I want to update the information from 1 table to another table.

The only way I know how to do this is to run each query line by line in a php loop. Query the table 1, get the results, store into a variable and then Update table 2 with the variable value.

This works for small table, but is running into issues when I run it for entier table. Im sure there is a better way, but have not located it yet.

Is creating a temporary table a possibility? If so please point me to some info on this.

Thanks alot.