Total members 9950 | Gratitudes |It is currently Sat Feb 11, 2012 2:49 am Login / Join Codemiles


All times are UTC [ DST ]




Post new topic Reply to topic  Quick reply  [ 4 posts ] 
Author Question
 Question subject: 2 different database
PostPosted: Tue Dec 23, 2008 3:59 pm 
Offline
Newbie
User avatar

Joined: Tue Dec 23, 2008 3:50 pm
Posts: 1
Has thanked: 0 time
Have thanks: 0 time

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.


TOP
 Profile Send private message  
Reply with quote  
 Question subject: Re: 2 different database
PostPosted: Tue Dec 23, 2008 4:57 pm 
Offline
Mastermind
User avatar

Joined: Tue Mar 27, 2007 10:55 pm
Posts: 2103
Location: Earth
Has thanked: 39 time
Have thanks: 56 time
You can export the tables from one database and import them into the other one :)

_________________
Currenlty programming with : java , html , php , and javascript . (OCJP-6 certified )


TOP
 Profile Send private message  
Reply with quote  
 Question subject: Re: 2 different database
PostPosted: Thu Sep 23, 2010 6:48 am 
Offline
Newbie
User avatar

Joined: Tue Sep 07, 2010 9:18 am
Posts: 30
Has thanked: 0 time
Have thanks: 1 time
hey this is somewhere similar like SQL server.....
You can do it in SQL also....two different database :) nice concept

_________________
Robinetterie industrielle


TOP
 Profile Send private message  
Reply with quote  
 Question subject: Re: 2 different database
PostPosted: 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

http://www.everymanhosting.com/forum/viewtopic.php?p=42

INSERT IGNORE INTO `username_linksdb1a.gz`.`dbs_links`
SELECT *
FROM `username_linksdb1.gz`.`dbs_links`


web development company


TOP
  
Reply with quote  
Post new topic Reply to topic Quick reply  [ 4 posts ] 
Quick reply


  


 Similar topics
 Topic title   Forum   Author   Comments 
 database contents display in table format in swing  GUI  subho07  4
 database connection  Java  katanor  1
 array in oracle database  Java  aparnaverma  1
 information about database  Servlets / JSP  rinasharma  0
 Restoring SQL Database from the .BAK File Problem  SQL Server  saics  3

All times are UTC [ DST ]


Users browsing similar posts

Users browsing this forum: No registered users and 1 guest



Jump to:  
Previous Question | Next Question 




Home
General Talks
Finished Projects
Code Library
Games
Tutorials

Java
C/C++
C-sharp
php
Script
JSP/Servlets
Ajax
ASP/ASP.net
Google SEO
Database
Communications
Phpbb3 styles
Photoshop tutorials
Flash tutorials
Find a job






Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team