Skip navigation links

MySQL Forums :: Merge Storage Engine :: how to merge 2 tables from 2 different database?


Advanced Search

how to merge 2 tables from 2 different database?
Posted by: irmtfan ()
Date: May 19, 2006 02:06PM

i have a running db and a backup. recetly i lost some of my data in my running site and want to back them from my backup.

in all 2 databes i have the same table. eg:
bb_posts ----> have these fields:
post_id pid topic_id forum_id post_time uid poster_name poster_ip subject dohtml dosmiley doxcode dobr doimage icon attachsig approved post_karma attachment require_reply

so i want 2 merge these 2 table in another new table ( or the same in my running site)
is this possible?

Options: ReplyQuote


Subject Views Written By Posted
how to merge 2 tables from 2 different database? 20304 irmtfan 05/19/2006 02:06PM
Re: how to merge 2 tables from 2 different database? 11291 Ingo Strüwing 05/22/2006 03:56AM
Re: how to merge 2 tables from 2 different database? 9614 Vinayak Javaly 06/01/2006 11:16AM
Re: how to merge 2 tables from 2 different database? 9437 Ingo Strüwing 06/02/2006 09:32AM
Re: how to merge 2 tables from 2 different database? 8692 Vinayak Javaly 06/02/2006 10:10AM
Re: how to merge 2 tables from 2 different database? 8090 Ingo Strüwing 06/06/2006 10:54AM
Re: how to merge 2 tables from 2 different database? 11578 Lionel Farr 08/28/2006 04:10PM
Re: how to merge 2 tables from 2 different database? 7869 Lionel Farr 08/30/2006 10:11AM
Re: how to merge 2 tables from 2 different database? 11206 Ingo Strüwing 09/05/2006 01:35AM
Re: how to merge 2 tables from 2 different database? 6669 David Andersen 06/10/2007 10:05AM
Re: how to merge 2 tables from 2 different database? 6948 Shlomo Priymak 06/21/2007 01:54AM
1000$ if implemented 6379 David Andersen 06/27/2007 06:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.