5 pts.
 MYSQL DATABASE!!!
Hello everyone!

please help me about transfering MYSQL DATABASE from one computer to another.....



I am a student and got to show a project on JDBC.



I am using Windows 7 os and Mysql server 5.1..



Thank you.





Software/Hardware used:
mysql
ASKED: Jan 28, 2012  10:09 AM GMT
UPDATED: February 28, 2012  10:55:46 AM GMT
2,250 pts.

Answer Wiki:
The simplest approach would be to use the mysqldump command as follows to make a backup of the database - "mysqldump -u username -p databasename > backup.sql", then transfer the backup.sql file to another machine with MySQL installed and use the following command to restore the database -"mysql -u username -p databasename backup.sql" where database name is the name of your database. If you prefer to use a graphical user interface try Quest Software's easy to use and free TOAD for MySQL which can be downloaded from here - "http://www.quest.com/toad-for-mysql/". You'll need to install TOAD for MySQL on both machines, but it will make backing up and restoring the database between machines much easier and is a great tool for working with MySQL databases and beats PHPMYADMIN hands down as the better GUI admin/development tool.
Last Wiki Answer Submitted:  Jan 28, 2012  12:42 AM (GMT)  by  TechTalker   2,250 pts.
To see other answers submitted to the Answer Wiki View Answer History.
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _