MYSQL DATABASE!!!

5 pts.
Tags:
Microsoft Windows 7
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following