How to import an SQL file using the command line in MySQL?

Question

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line.

I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and I tried this command

database_name < file.sql

It is not working I get syntax errors.

• How can I import this file without a problem?
• Do I need to create a database first?

Answer 1

Try this command line in MYSQL:

MySQL -u username -p database_name < file1.sql

Are you interested in learning SQL from scratch! Have a look at this interesting video on SQL provided by Intellipaat:

Note:

•        It’s most recommended to use the full path of the SQL file file1.sql

• I      If an empty database doesn’t exist and exported SQL don’t contain CREATE DATABASE(-n option or exported with - -no—create- -db ) then you may have to create one empty database before you import it.

•        <!--[endif]-->You can use - -triggers and -R to keep the triggers of the original database. They will not be copied by default.