Merging databases!?

marSoul · #1 Oct 2nd, 2007, 13:02

I have created a new database for a website, and now I get the old database from the client and they want to merge it with new one.
The problem is the old one has different names and tables. But they need it to be merged as soon as possible,
What can I do ?
This is very urgent ...

karinne · #2 Oct 2nd, 2007, 13:19

Please choose a better topic next time!

c010depunkk · #3 Oct 2nd, 2007, 13:42

What kind of databases are we talkin' about? SQL? mySQL? Access?

marSoul · #4 Oct 2nd, 2007, 13:45

both are mysql but they are different in structures.
the old one has a table of users with many fields but new one has some of them
so i need to merge the old one with new one

c010depunkk · #5 Oct 2nd, 2007, 13:52

I would just SELECT everything from both old tables and write the result into a new table with the correct format. Any fields in the new table that don't exist in the old ones would just be filled with a default value.

marSoul · #6 Oct 2nd, 2007, 13:58

can u please give me the query command, coz i'm not very professional in mysql

c010depunkk · #7 Oct 2nd, 2007, 14:25

Here's some (untested) code for starters. See if you can get it to work for you:

PHP: Select all


$query=mysql_query("SELECT * FROM old_table_name");
while($row=mysql_fetch_object($query)) {
  mysql_query("INSERT INTO new_table_name (field1,field2) VALUES ('".$row->old_value1."','".$row->old_value2."')");
}

You'll have to adjust the table and field names, but if you run that over both of your old tables you should be able to write them into the new one.

(Remember to make some backups!!!)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Databases?	Apocalyptic Poet	Classic ASP	1	Apr 23rd, 2008 12:24
[SOLVED] Concerning speed: SSI, PHP, or pre-upload merging?	MikeHopley	Web Page Design	14	Oct 23rd, 2007 17:00
Local Business Listing Merging	Morledge	Search Engine Optimization (SEO)	2	Oct 20th, 2007 12:25
Merging images... maybe	da_stimulator	Web Page Design	1	Jan 22nd, 2005 01:32
Access databases.... anyone know much?	benbacardi	Databases	8	Jul 2nd, 2004 18:14

		Webforumz.com > Main Forums > Program Your Website > Databases
Merging databases!?