Import a mysql database using mysql command line

Question

I was wondering if it's possible to import a mysql database using the mysql command line.

Most solutions give mysql -u root -p nameofdatabase < mysqlfile.sql

I was wondering if it's possible to do this inside the mysql commmand line, instead of passing arguments to the executable.

If I just do

 mysql> mydatabase < mysqlfile.sql;

That just doesn't work. Thank you.

gabor.harsanyi · Accepted Answer · 2015-04-22 17:31:47Z

1

Did you mean something like this?

mysql> use nameofdatabase;
mysql> SET autocommit=0 ; source the_sql_file.sql ; COMMIT ;

The important part, what you were looking for, is the source command. I usually switch off autocommit because of the execution time.

answered Apr 22, 2015 at 17:31

gabor.harsanyi

5992 silver badges14 bronze badges

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

1 Comment

Is the source command doing the same thing (importing) as < in command like this, mysql -u root -t < employees.sql ?