2 different database
Tue Dec 23, 2008 3:59 pm
I have a recipe script that I wish to use on a site, and then I have another that I wish to combine the 2 databases into one script, I have searched hi and low as well as explained that I have no clue on rewriting or writing a data base at all, and so far have gotten very technical replies on other forums of course. The one reply I did recieve said to find someone who has etl skills but with no luck have been unable. Can you offer any help on how to combine the databases, they are both MySQL.
Re: 2 different database
Tue Dec 23, 2008 4:57 pm
You can export the tables from one database and import them into the other one 
Re: 2 different database
Thu Sep 23, 2010 6:48 am
hey this is somewhere similar like SQL server.....
You can do it in SQL also....two different database nice concept
You can do it in SQL also....two different database
nice concept Re: 2 different database
Wed Jul 20, 2011 11:11 am
Try this with your existing database to merge the new one,remember before you start you should have your backup database.
also chk this link
INSERT IGNORE INTO `username_linksdb1a.gz`.`dbs_links`
SELECT *
FROM `username_linksdb1.gz`.`dbs_links`
also chk this link
INSERT IGNORE INTO `username_linksdb1a.gz`.`dbs_links`
SELECT *
FROM `username_linksdb1.gz`.`dbs_links`
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com
Powered by phpBB © phpBB Group.