How can I run a .sql file from the query tab?

Question

I'm using MySQL Workbench and I have a series of .sql files stored from on my computer. I want to run these files from the query tab, but every time I use this command:

source '/Users/[username]/Documents/company/department.sql';

I get an Error 1064, which says "Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> source '/Users/[username]/Documents/company/department.sql' at line 1 "

Can anyone tell me what I'm doing wrong?

Why don't you open department.sql from MySQL Workbench instead of sourcing? — Franck Dernoncourt
– Franck Dernoncourt, Commented Sep 24, 2013 at 1:19

Community · Accepted Answer · 2017-05-23 11:51:54Z

0

In your MySQL console.

 mysql> use DB_NAME;
 mysql> source 'Users/[username]/Documents/company/department.sql';

Got the above from the answer here. Import SQL file into mysql

Also. From Console.

mysql -u root -p DB_NAME < Users/[username]/Documents/company/department.sql

I am not that familiar with MySQL WorkBench. I prefer using the console but these are the two methods to do what you want assuming that your .sql file contains proper sql.

edited May 23, 2017 at 11:51

CommunityBot

11 silver badge

answered Sep 23, 2013 at 19:37

j0hnstew

7098 silver badges25 bronze badges

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

2 Comments

yiwei Over a year ago

The issue is I'm not in the console I'm in the query tab (unless they're the same thing; I'm a newbie here). Do I type in the "mysql>" part?

j0hnstew Over a year ago

no don't type in "mysql>". have you tried what I said to do above? If you have and it still does not work then are you sure the sql file is properly formatted?

Mike Lischke · Accepted Answer · 2013-09-24 07:29:45Z

0

The source command as well as the variant using the left angle char are solely features of the command line client. They make absolutely no sense in a GUI like MySQL Workbench. If you want to run a script open it in the SQL editor and click the button with the flash in the editor's toolbar to run it.

answered Sep 24, 2013 at 7:29

Mike Lischke

54.3k18 gold badges142 silver badges210 bronze badges

2 Comments

William T. Mallard Over a year ago

It makes perfect sense if you want to run a defined series of sql script files.

user4903 Over a year ago

I agree. In order to automate script execution and history it would be essential to have this functionality.

Collectives™ on Stack Overflow

How can I run a .sql file from the query tab?

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related