When I studied in official import MySQL database employees, have Failed to open file 'load_departments. Dump',
I use the source command to import the database
Here is a screenshot:

Below is the error screenshot:

I have found that employees database all suffix for the dump file in folder prompt unable to open, want to know what's going on, how to solve?

CodePudding user response:

Employees. What is the content of the SQL file, points,

CodePudding user response:

Seek the solution, I also met!!!!!!!!!!!!!!!

CodePudding user response:

Just download the wrong file, website has 2 files, one only have table structure, and the other one is data
https://launchpadlibrarian.net/24493586/employees_db-full-1.0.6.tar.bz2

CodePudding user response:

reference happywjh666 reply: 3/f

just download the wrong file, website has 2 files, one only have table structure, and the other one is data
https://launchpadlibrarian.net/24493586/employees_db-full-1.0.6.tar.bz2

If this is the leading into the table structure, after importing the data

CodePudding user response:

I also encountered this problem, how do you solve, give advice or comments please

CodePudding user response:

Occasionally see this post, tell me about the problem of the building Lord, by the way, first above:

It's employees. The import data of SQL, SQL problem out behind the source file path
If the source command followed by the data file of the absolute path to solve the problem of the original poster (pro)


Take not xie

CodePudding user response:

In the CMD window, enter the decompression of employees database folder, such as in D: \ develop \ test_db - master directory, type D: first enter CD again D: \ develop \ test_db - master import command again can root @ test: employees_db # mysql - uroot - p - t & lt; SQL
employees.- the root as the user name, your user name is to write what you
Enter password: after - Enter a password, see the following information is import was successful