MySQL: how to import data from an SQL file to a database using the command line

Question

I want to import data from a large SQL file to the MySQL database using the command line. What command should I use?

Answer 1

You can run the following command on the terminal to import the data to the MySQL database.

mysql -u user_name -p database_name < filename.sql