Welcome to WebmasterWorld Guest from 54.234.45.10

Forum Moderators: open

Message Too Old, No Replies

Move Data from a MYSQL database to another MYSQL database

database

     
12:37 pm on Mar 12, 2007 (gmt 0)

Junior Member

10+ Year Member

joined:May 11, 2004
posts:133
votes: 0


Dear sir/madam,

Database 1 have 1 GB
Database 2 have 10 MB

Database 1 = Database 2 are the same, tables are the same.

I want to transfer new data from Database 2 to Database 1 because DB1 is too large to use my perl script to add new content and to avoid CPU usage.

How can I do to move all data from DB2 to DB1?

Kind regards,
Dan

3:40 am on Mar 14, 2007 (gmt 0)

Senior Member

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Sept 1, 2001
posts:4392
votes: 0


The mySQL has a utility for this. I think mySQLDUMP will work also. Check out the docs to see how it works.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members