Quote:
Originally Posted by ruff
I'm going to try that and see if it works. Thx.
|
We do this all the time. That way won't work well for you because the table would have to have fields in the same order.
You should make one user that has access to both databases and then do something like
INSERT INTO `newDb`.`newTable` (col1,col2,col3,col4,col5) SELECT correspondingcol1,correspondingcol2,correspondingc ol3,correspondingcol4,correspondingcol5 FROM `oldDb`.`oldTable`