If you want to do it the easy manual way, it's simple. In a cmd window, cd.. to the
folder where you want to dump the database to. Then type this :
mysqldump --routines -u root -ppassword peqdbname > peqbackup.sql
Assuming you have created an empty sql database name on your new box, put the
backup in a folder on there somewhere, then do the following:
In a cmd window, cd.. to where the backup is and login to your sql.
(mysql -u root -ppassword) Then tell your sql to use the new empty database by
typing this : use newpeqname You will see a message "database changed".
Then simply type: source peqbackup.sql Then let it do it's thing, and you're done.
I've always had 0 problems doing it that way, compared to using 3rd party programs.
|