Reputation: 1229

mysql: SOURCE error 2?

When I tried to source for a particular .sql file, namely 'metropolises.sql' that I created and saved previously from a database, the following error is displayed:

Failed to open file 'metropolises.sql', error: 2

Any idea what went wrong?

Upvotes: 92

Answers (27)

Tanya sharma

Reputation: 1

write this command in terminal in VScode

& "C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe" -u root -p

Then enter your password that you used while setting up MySql WorkBench

if you want to execute .sql file make sure you have created the file for example schema.sql then in terminal write

SOURCE schema.sql

Upvotes: 0

Tusar Ahmed

Reputation: 23

I've got the same error on Windows. I solved it running the code on MySQL command line

source c:\Users\xx\Downloads\data_file.sql

Upvotes: 0

craft9861

Reputation: 214

I was having this issue and it turns out if you are using wamp server to run mysql, you have to use the file path within the wamp64 folder. So when the absolute path is: C:/wamp64/www/foldername/filename.sql The path you have to use is: www/foldername/filename.sql

Upvotes: 1

Gazzella

Reputation: 1

Passing the full path does not error, but if the folders have MySQL spaces it does not recognize the .sql file. I have MySQL 8.0.21 on OS UNIX.

Upvotes: 0

Hadi Mir

Reputation: 5133

IF YOU ARE USING MYSQL INSIDE DOCKER

Note that if you are running MySQL inside docker then you must first copy the dump into your MySQL docker environment. To do that follow the steps below

First, check and copy the container ID for your MySQL docker by:

sudo docker ps
Copy the SQL dump file into your container using:

sudo docker cp /path/to/sql/file.sql MysqlDockerID:/

This will copy the dump file into the docker root folder if you want to copy the file inside any other directory/path inside docker replace the '/' after 'MysqlDockerID:' with the path you want appropriate one.
Now to interact with MySQL inside a running container run the following command:

sudo docker exec -it MysqlDockerID bin/bash
Now connect to the MySQL using the terminal by:

mysql -u yourUserName -p

This will now ask you for the password. Enter the correct password to proceed.
List the databases available by:

show Databases;

This will list out the available databases
Assuming your database name where you want to import dump to is 'MyDatabase'. Switch to that using:

use MyDatabase
Now you can import the file by typing:

source file.sql

Remember the above command works if you have copied your file into your root folder (using step 2). If you have copied it to any other path make sure you use that same path instead

Upvotes: 30

Prince Billy Graham

Reputation: 3578

I get into this problem in my Xubuntu desktop. I fixed it by renaming all my files and folders so there is no space in the file path.

Upvotes: 0

Anand Chaudhary

Reputation: 13

solution - 1) Make sure you're in the root folder of your app. eg app/db/schema.sql.

solution - 2) open/reveal the folder on your window and drag&&drop in the command line next to keywork source (space) filesource. eg source User/myMAC/app/db/schema.sql

Upvotes: 0

Rob

Reputation: 19

I had a problem on my Mac because one of the folder (directory) names in the path had a space in the name. BTW, the space was escaped by a \, but that was not understood by mySQL

Upvotes: 0

Andrew Rhyne

Reputation: 13

On my Mac, this is the only solution worked for me.

https://stackoverflow.com/a/45530305/5414448


1 - Download the .sql file and remember it's location.

2 - Open your mysql from command prompt or terminal.

3 - Create a database with the same name as that of the database present in the .sql file (create database your_database_name)

4 - Now exit out from the mysql command line client

5 - Now try and execute this command =>

mysql -u your_username -p your_database_name < your_sql_file_with_complete_location

example -  mysql -u root -p trial < /home/abc/Desktop/trial.sql

here my .sql file is named trial and is present in the desktop, the database is also name trial

6 - You should now have your sql file imported to the corresponding mysql database.

Upvotes: 1

Ricardo Gonçalves

Reputation: 5074

The solution for me was file permissions in Windows. Just give full control in the file to all users and it will work. After the import, get the permissions back to what it was before.

Upvotes: 0

subhendu das

Reputation: 1

I also got the same message when I try from the MySQL console. However, when I open the command prompt and do the same steps it works.

C:\Users\SubhenduD>cd ../
C:\Users>cd ../
C:\>cd \xampp\mysql\bin

C:\xampp\mysql\bin>mysql -u -root

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 68
Server version: 5.6.16 MySQL Community Server (GPL)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. 
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> use balticktravels;

mysql> source balticktravels.sql;

Upvotes: -1

Nadun Kulatunge

Reputation: 1731

For Mac users, you can give the path as,

source /Users/YOUR_USER_NAME/Desktop/metropolises.sql;

*I have assumed that the file you need to source is in your desktop and the file name is metropolises.sql

If you type,

source metropolises.sql

then the file will be look in the default location,

/Users/YOUR_USER_NAME/metropolises.sql;

Upvotes: 0

maithri poojary

Reputation: 1

I got the same error when i used the command source and gave the sql file path by drag n dropping it.

Then I just had to remove those single quotes which appeared by default with drag and drop, a space before file extension and it worked.

soln:

source /home/xyz/file .sql ;(path and a space before file extension)

Upvotes: 0

Camilo

Reputation: 469

For me it was because the file was located on a shared drive and it could not access, for some reason, to that path. I cut the file and put it on my local drive in a path without spaces and it got resolved.

Upvotes: 0

Ibrahim Isa

Reputation: 609

If you are using vagrant ensure that the file is on the server and then use the path to the file. e.g if the file is stored in the public folder you will have

sql> source /var/www/public/xxx.sql

Where xxx is the name of the file

Upvotes: 3

rocketTheCat

Reputation: 141

It's probably the file path to your file. If you don't know the exact location of the file you want to use, try to find your file in Finder, then drag the file into Terminal window

mysql> SOURCE dragfilePathHere

Upvotes: 14

Devy

Reputation: 10189

If you are running dockerized MySQL container such as ones from this official Docker Image registry: https://hub.docker.com/_/mysql/ You may encounter this issue as well.

Upvotes: 0

T. Webster

Reputation: 10109

If you're on Debian 8 (Jessie) Linux, try to cd into the directory of the 'metropolises.sql'. Run mysql and execute SOURCE ./metropolises.sql;

Basically, try the relative path. I tried this and it works.

Upvotes: 0

LivePwndz

Reputation: 616

On my windows 8.1, and mysql 5.7.9 MySQL Community Server (GPL), I had to remove the ; after the file path.

This failed: source E:/jokoni/db/Banking/createTables.sql;

This Worked: source E:/jokoni/db/Banking/createTables.sql (without termination, and forward slashes instead of windows' backslashes in path)

Upvotes: 3

Lpgfmk

Reputation: 391

I got this error in mysql command line using this query:

source `db.sql`;

I changed the above to the following to make it work:

source db.sql;

Upvotes: 1

Loganathan

Reputation: 1777

Remove spaces in the folder names of the path, It worked for my mac path.

(Eg: change the folder name MySQL Server 5.1 to MySQLServer5.1)

Upvotes: -1

Alex Aleluia

Reputation: 61

I've had the same error on Windows. I solved it with (after on cmd: mysql -u root):

mysql> SOURCE C:/users/xxx/xxxx/metropolises.sql;

Be sure you type the right file path

Upvotes: 4

chad

Reputation: 1297

Just use the absolute path of the file and then, instead of using backslashes, use forward slashes.

Example:

with backslashes : source C:\folder1\metropolises.sql
with forward slashes : source C:/folder1/metropolises.sql

Upvotes: 43

user3030395

Reputation: 59

I first reach to the file

c:\windows>cd c:\akura\Db Scripts

c:\akura\Db Scripts>mysql -u root -p root

mysql>\. EXECUTER_NEW_USER.sql

here EXECUTER_NEW_USER.sql my file name

Upvotes: 5

user1906580

Reputation: 249

Related issue I had getting error 2 running source command: filename must not be in quotes even if it contains spaces in name or path to file.

Upvotes: 15

Fathah Rehman P

Reputation: 8741

May be the file name or path you are used may be incorrect

In my system i created file abcd.sql at c:\

and used command mysql> source c:\abcd.sql Then i got result

Upvotes: 0

Lightness Races in Orbit

Reputation: 385144

Assuming you mean that you are trying to use the source command in order to execute SQL statements from a text file, the error number given appears to be passed through from the POSIX layer.

Therefore, using this resource, we can deduce that the error value of 2 means "no such file or directory".

In short, you got the path wrong.

Try providing an absolute path, as it's not clear what the current working directory will be in the context of your MySQL server. You may be assuming that it's the working directory of your shell, but it's not obvious that we should expect this to be true.

Upvotes: 112

mysql: SOURCE error 2?

Answers (27)

IF YOU ARE USING MYSQL INSIDE DOCKER

Related Questions