Source syntax error in SQL query

Question

Trying to use this query in MySQL Workbench. The SOURCE line gets a syntax error, I've been doing research to figure out why with no success. Any ideas?

drop database commonfx;
create database commonfx character set utf8 collate utf8_general_ci;
use commonfx;
SET autocommit = 0;
SOURCE 'C:\Users\MK\Downloads\testdb.sql';
commit;
SET autocommit = 1;

Error:

Syntax error, unexpected SOURCE_SYM

Execute it with the --verbose option, e.g. mysql --verbose < text_file and paste the results, along with the contents of c:\users\mk\downloads\testdb.sql. — hd1
– hd1, Commented Sep 1, 2014 at 8:18
I don't think the contents of the file are relevant, it's complaining that the SOURCE command itself is unexpected. — Barmar
– Barmar, Commented Sep 1, 2014 at 8:22

Mike Lischke · Accepted Answer · 2014-09-01 09:56:39Z

0

MySQL Workbench doesn't support the SOURCE command (yet). Instead paste-in the content of your file instead for now.

answered Sep 1, 2014 at 9:56

Mike Lischke

54.3k18 gold badges142 silver badges209 bronze badges

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

2 Comments

emkay Over a year ago

Unfortunately file is 700mb, so that's not an option

Mike Lischke Over a year ago

700MB? That's certainly a generated file, not something generally useful. Use the restore function in MySQL Workbench Admin then.

Collectives™ on Stack Overflow

Source syntax error in SQL query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related