| Welcome to WebmasterWorld Guest from 220.127.116.11 |
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
|Subscribe and Support WebmasterWorld|
|Move Data from a MYSQL database to another MYSQL database|
| 12:37 pm on Mar 12, 2007 (gmt 0)|
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?
| 3:40 am on Mar 14, 2007 (gmt 0)|
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.
© Webmaster World 1996-2014 all rights reserved