can't load .sql file into mysql mac

Question

I have mysql running, I've switched to my database using:

use myDb;

now I'm trying to run a sql script located on my desktop using the following:

source /Users/abdul/Desktop/mySql.sql;

but I keep getting this error:

Failed to open file '/Users/abdul/Desktop/mySql.sql;', error: 2

not sure what I'm doing wrong, I've been researching and everything says to do it the way I did it.

Error 2 is "No such file or directory." Check your spelling, capitalization, and then verify that the account running mysqld has access to the file in question. Try putting the file in your Public or Shared folder, for example. — Bacon Bits
– Bacon Bits, Commented Jul 6, 2015 at 20:22

Sandeep Neupane · Accepted Answer · 2015-07-06 20:28:41Z

1

Error 2 stands for "No such file or directory". Try checking for any spelling errors in the file. Also make sure MySQL has access to the file in that location.

answered Jul 6, 2015 at 20:28

Sandeep Neupane

1581 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

can't load .sql file into mysql mac

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related