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 move tables from one computer to another? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "move tables from one computer to another?" Watch "move tables from one computer to another?" New topic
Author

move tables from one computer to another?

Elahe Shafie
Ranch Hand

Joined: Dec 12, 2001
Posts: 291
Hi friends,
how can I move tables from one computer to another computer?(database is mysql)
Thanks
Elahe


Thanks,
Elahe
Manoranjan Mishra
Greenhorn

Joined: Jan 30, 2002
Posts: 8
You can take the backup and copy the backup file and restore it in any computer which has mysql.. For details regarding backup and restore goto:
http://www.mysql.com/doc/B/a/Backup.html


Manoranjan Mishra
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
Here is the fast and easy way - and probably dangerous too.
go to the data directory under mySQL and open the file with the name of the database you are working with, there are three files for each table in the database.
Copy the three files from the database folder of one mySQL install to the same place on the new machine. You'll have to stop and restart mySQL but after that it should be ok.
Dave


Dave
Elahe Shafie
Ranch Hand

Joined: Dec 12, 2001
Posts: 291
Many thanks Dave...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: move tables from one computer to another?