executing a .sql file in command line

Question

Doing

mysql -uroot -p -e source F:\code\mysql\mysql-data\myHfs\test.sql

gives : ERROR 1049 (42000): Unknown database 'f:\code\mysql\mysql-data\myhfs\test.sql'

But if i go inside the mysql command promt with just the mysql -uroot -p and then type in source F:\code\mysql\mysql-data\myHfs\test.sql , i get the proper output.

the content of the above file being :

use gregs_list;
show tables;
select * from clown_info;

Edit : doing mysql -uroot -p < "F:\code\mysql\mysql-data\myHfs\test.sql" -t seems to solve the problem.

xiankai · Accepted Answer · 2013-10-03 06:08:05Z

1

http://dev.mysql.com/doc/refman/5.0/en/mysql-batch-commands.html

mysql -uroot -p < "F:\code\mysql\mysql-data\myHfs\test.sql"

edited Oct 3, 2013 at 6:08

answered Oct 3, 2013 at 6:02

xiankai

2,7713 gold badges28 silver badges31 bronze badges

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

5 Comments

Somjit Over a year ago

i get mysql: option '-e' requires an argument

xiankai Over a year ago

Sorry, try again without that argument.

Somjit Over a year ago

this works : mysql -uroot -p < "F:\code\mysql\mysql-data\myHfs\test.sql" -t

xiankai Over a year ago

The -t option seems strictly only for display, you could do without it if you didn't need the output.

Somjit Over a year ago

true. But I'm trying this to build my sql query from inside sublimetext 2 , and this argument will be passed to the command line.

Collectives™ on Stack Overflow

executing a .sql file in command line

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related