merging/updating databases

Archived from the Xataface Users forum.

compudude86 — Thu Dec 07, 2006 11:43 am

ok, i took everyones advice and created individual apps for each table. now, i need a way to combine all the tables on DIST into BOOK:products, using the dataface interface. how would i go about setting this up?

---

shannah — Thu Dec 07, 2006 1:42 pm

Hi Joe,

Can you elaborate on this? So you have a number of tables in the DIST database that are all identical and you want to copy them into the products table of the BOOK database? Is this correct?

-Steve

---

compudude86 — Thu Dec 07, 2006 4:01 pm

that is correct, yes. i need a sort of “one-click” way to do this. there are about 10 tables in the dist db that need to go into the one products table…

---

shannah — Thu Dec 07, 2006 4:23 pm

There may be tools available to do something like this, but the safest easiest way that I can think of is to do a dump of each table using PHPMyAdmin, put them together in a single text file, then import them into the other table also using PHPMyAdmin.

Hope this is a one-time thing as if it is a recurring process it sounds complicated - which would mean that there’s a better way..

-Steve

---

compudude86 — Tue Dec 12, 2006 10:28 am

ok, thank you. thats what i originally planned on doing, but i was trying to see if there was an easier way.