Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Database Cloning
This is a discussion on Database Cloning within the MY SQL forums, part of the Databases category; I need help how to copy the mysql database in one system to another using java...
|
|||||||
Database Cloning
08-03-2009
|
|||
|
|||
|
Re: Database Cloning
Create dump file $ mysqldump -u user -p db-name > db-name.out copy dump file to your remote server $ scp db-name.out user@remote.server.com:/dump restore to your remote server $ mysql -u user -p db-name < db-name.out using ssh or mysql client direct access to remote mysql server: $ mysqldump db-name | mysql -h remote.server.com db-name without direct access to remote mysql server): $ mysqldump db-name | ssh user@remote.server.com mysql db-name copying just table to remote database: $ mysqldump db-name foo | ssh user@remote.server.com mysql bar create dump file $ mysqldump -u user -p db-name > db-name.out copy dump file to your remote server $ scp db-name.out user@remote.server.com:/dump restore to your remote server $ mysql -u user -p db-name < db-name.out using ssh or mysql client direct access to remote mysql server: $ mysqldump db-name | mysql -h remote.server.com db-name without having direct access to remote mysql server): $ mysqldump db-name | ssh user@remote.server.com mysql db-name copying just table to remote database: $ mysqldump db-name foo | ssh user@remote.server.com mysql bar
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Project database size and schema in database | Geek_Guest | Data Warehousing | 2 | 12-21-2008 06:45 PM |
| Cloning in Java | verma018 | Java | 0 | 01-29-2008 05:03 PM |
| Relationship between SQL server, database and database applications | Geek_Guest | SQL | 1 | 07-10-2007 03:21 AM |
| Keriver Image is a cloning or imaging utility to protect yourself from important data | JobHelper | Geeks Lounge | 0 | 06-06-2007 06:30 AM |
| Database Error: Failed to connect to database | srivenu | Data Warehousing | 0 | 04-01-2007 05:08 AM |
All times are GMT -4. The time now is 07:06 AM.
