| Welcome to WebmasterWorld Guest from 22.214.171.124 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Become a Pro Member|
|Move Data from a MYSQL database to another MYSQL database|
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?
The mySQL has a utility for this. I think mySQLDUMP will work also. Check out the docs to see how it works.
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved