Total members 11889 |It is currently Fri Mar 29, 2024 8:02 am Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





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.




Author:
Newbie
User avatar Posts: 1
Have thanks: 0 time

You can export the tables from one database and import them into the other one :)

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada


Author:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time

hey this is somewhere similar like SQL server.....
You can do it in SQL also....two different database :) nice concept


Author:
Newbie
User avatar Posts: 27
Have thanks: 1 time

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`


Author:
Post new topic Reply to topic  [ 4 posts ] 

  Related Posts  to : 2 different database
 Selecting a Database in php     -  
 database connection     -  
 information about database     -  
 List all database in php     -  
 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     -  
 Creating a Database in MySQL     -  



cron





Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
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