Error command: Failed to open file “file_name” error 2/error 22

The SQL script file name contains Chinese characters and Spaces. The SQL script file name contains Chinese characters and Spaces

Import the SQL script of the database table file into mysql

Method 1:1. Open CMD and enter mysql -u username -p password

You can also perform the following steps at the mysql command prompt

2. Enter show databases to view the database list (this step is optional).

3. Enter use dbname to select the database (this step is necessary, otherwise mysql does not know which database to use the SQL file, if the SQL file has already selected the database, or to create a database, do not need to. In general, if mysql reminds you not to select a database, select it.

4. Enter source path/filename.sql

Use ‘/’ instead of ‘\’, because ‘\’ is a command character in SQL, and be careful not to use quotes, full pathnames.

Method 2:

Use Navicat for MySQL graphical interface to import the database, using the graphical interface to import the database is very simple

2, Click select script, select test. SQL script of DISK D, and then set database character format 3, then click Start to run the script on the line, script began to import oh! 4, and then close the database, and then open the database you can see the established database table.