restoring mysql database

[biggulp]

i made a mysql dump of my database from my website, but how do i restore the data into my win xp machine, because i want to test my scripts locally.

i know how to restore to a unix server with ssh but i can't think of anyway where you can restore the backups without using phpmyadmin (always times out).

any suggestions?

[ansa]

you should be able to use the command line "mysql" the same as on unix. is your backup file text or gzipped? if it's gzipped just ungzip it with winzip.
then you should be able to "mysql < mybackup.sql" i think!
however, i normally use mysql front end, which you can get from the mysql.com site in the windows download links. I find it easier that way, less messy, although it does help if your backup file has quotes and stuff escaled otherwise it can balk at your sql file.

Andy.

[biggulp]

thanks for your help, i've got it working:D

[ansa]

no probs and well done! :D