On Sun, 18 Jan 2004 14:58:21 GMT, "Ville Rontti"
<vi**********@pp.inet.fi> wrote:
Hi
I have two separate databases (A and B). Both databases have one table (A).
How I could transfer the contents of table A from Database A to database B
table A? The tables are same.
Ville
Do the tables have a unique identifier?
If not then you can just use mysqldump to dump table A, make sure that
it doesn't try to recreate the table, use awk, sed, vi, etc to change
each reference of table A to table B, then reload the data.
If it does then you will probably have to write a program that simply
takes all the information form A (minus the unique identifier) and
inserts it into B.