Magento set local dev database

Open app/etc and set local.xml file with your database name, password and host.

Import MySQL database from command line on Windows with Wamp

Open your command line , get into the directory where is extracted file with .sql file

Type mysql -u root -p password  This will connect you to the mysql

Then write use database_name This will choose database

And for impor the file, just write source database_file 


* root, password, database_name and database_file are just examples.