Moving Database from Server to Home Computer

[Aes]

I have the contents of a database in a .dump file. I have PHPMyAdmin installed (although I prefer the command prompt, I do not know how to use it from a Windows XP machine with PHPDev4). How do I load the database into MySQL so that I may use it to develop at home instead of on the server all of the time? Thanks.

-Colin

[DR_LaRRY_PEpPeR]

the mysql client (mysql.exe) isn't installed with PHPDev4??? if it is, you can use the command line. if mysql is in your path, just run

mysql -uuser -ppass database < path\to\file.dump

if it's not in your path, just replace `mysql' with the full path. or you can just run mysql.exe by double-clicking it (assuming the default user/pass will work) and run

mysql> source path\to\file.dump

make sure your database is selected first (`USE database').


does that help? i thought you already knew how to import with mysql. if PHPDev4 doesn't come with mysql, it really sucks.