Magento database import is best done with the command line

Especially in the local debugging, often in the phpMyAdmin inside the database can not be successfully imported, no matter how small the database, and sometimes really can not import. Then try to import it using the command line method, which will generally succeed.

1. After installing the phpMyAdmin client, go through WIN's Start menu--MySQL----MySQL SERVER 5.6---MySQL 5.6 COMMAND line Client

2. After entering the password for the connection database, you will see the mysql> prompt

3. After the prompt enter Mysql-u root-p here Enter the password database name < database name to import. SQL, for example:

Mysql-u root-pxxx YYY < Zzz.sql

Is it in? XX)

Magento database import is best done with the command line