MySQL Import SQL file with command line

In front of the Navicat tool to import the export database, today to colleagues to import the database, found not to go in, many errors, the feeling of desperation, with the command line imported

1. Open the MySQL service. Cmd-->net start MySQL shutdown service: cmd-->net stop MySQL

2. Find the bin directory under your MySQL installation package

"E:\MySQL\MySQL Server 5.0\bin\"

3. Run CD E:\MySQL\MySQL Server 5.0\bin enter under cmd

4, run the mysql-u username (root) database name (bank) Enter, and then let you enter the MySQL login password

5. Source E:bank.sql (Your SQL file) enter

MySQL Import SQL file with command line