Switch to full style
Tutorials, source code, tips and tricks related to mysql
Post a reply

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

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`

Post a reply
  Related Posts  to : 2 different database
 Selecting a Database in php     -  
 database connection     -  
 information about database     -  
 List all database in php     -  
 Bespoke Database Programmers     -  
 Login using jsp,Servlets and Database following MVC     -  
 creating database in netbeans     -  
 Close database connections in php     -  
 POPULATING DROPDOWN IN MY DATABASE USING PHP     -  
 How to connect database with Applets     -