Two Methods for importing. SQL files from mysql

Method 1: Note: First, you need to put the mysql installation Path in the Path of the environment variable, for example, C: ProgramFilesMySQLMySQLServer5.5bin; 1 Start program input cmd command enter dos window 2 input mysql-uroot-p3 input password 4 input source file path and file name (extension plus) Method 2: Open cmd first and then

Method 1: Note: First, you need to put the mysql installation Path in the Path of the environment variable, for example, C: \ Program Files \ MySQL Server 5.5 \ bin; 1. Enter the cmd command in the program to enter the dos window 2. Enter mysql-u root-p 3. Enter the password 4. Enter the source file path and the file name (add Extension). Method 2: Open cmd first and then

Method 1:
Note: First, you need to put the mysql installation Path in the Path of the environment variable, for example, C: \ Program Files \ MySQL Server 5.5 \ bin;
1. Start the program and enter the "cmd" command to enter the dos window.
2. Enter "mysql-u root-p"
3. Enter the password.
4. Enter "source file path and file name (extension plus )"

Method 2:
Open cmd first and then enter the mysql bin directory:
Cd D: \ soft \ wamp \ bin \ mysql \ mysql5.0.51b \ bin press ENTER
Mysql-u username-p password press ENTER
Use the database to be imported;
Source d: \ abc. SQL (pointing to your own directory) Press ENTER