This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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...
 
Don't get me started about those stupid light bulbs.
 
subject: move tables from one computer to another?
 
Similar Threads
how does the HttpSession move from one JVM to another?
How to move files in struts
Improving performance of Hibernate based batch program
moving files
to copy Oracle database from one PC to another