# Thread: Moving Database from Server to Home Computer

1. ## Moving Database from Server to Home Computer

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

2. 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

Code:
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

Code:
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.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•