Jump to content


Photo

insert data from different database


  • Please log in to reply
2 replies to this topic

#1 baiju

baiju
  • Members
  • PipPip
  • Member
  • 28 posts

Posted 18 October 2006 - 06:47 AM


hi
I have different database. Both having same tables.
I want to insert all datas from first database to second database.




#2 jvrothjr

jvrothjr
  • Members
  • PipPipPip
  • Advanced Member
  • 300 posts
  • LocationOhio

Posted 18 October 2006 - 12:20 PM

one was would be to create a sql file the load the data into the other using that file

second way could be loading the data into an array from the first DB and dumping into the second DB using that array.


If you understand everything you know nothing!

http://rcchjr.awardspace.com/

#3 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 19 October 2006 - 04:18 PM

And a third way would be to copy it over directly, if you can manage to login to both with the same credentials and the DBs are on the same box.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users