File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes How to copy table and data to another computer? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to copy table and data to another computer? " Watch "How to copy table and data to another computer? " New topic
Author

How to copy table and data to another computer?

Elahe Shafie
Ranch Hand

Joined: Dec 12, 2001
Posts: 291
Dear Friends,
it is asked me to transfer tables and data to another computer with replication in Mysql and I have no idea how can I do that I have to finish it by tomorrow could please help me on this, since I am totally lost...
Many thanks,
Elahe


Thanks,
Elahe
Tina Coleman
Ranch Hand

Joined: Dec 12, 2001
Posts: 150
Try using mysqldump (a command-line utility available with mySQL). More info about it and its various options is at http://www.mysql.com/doc/m/y/mysqldump.html, but it will allow you to transfer table structure and data. Essentially, it creates the SQL statements necessary to rebuild the database and data on another server (could be mySQL, could be another database server).
Elahe Shafie
Ranch Hand

Joined: Dec 12, 2001
Posts: 291
Thank you so much Tina.
By the way still I don't know what does replication do in terms of transfer table and data? any idea?
Thanks,
Elahe
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

http://www.mysql.com/doc/R/e/Replication.html
Hope this explains it well enough.
Jamie
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to copy table and data to another computer?