MySQL Forums
Forum List  »  Merge Storage Engine

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

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.