command line - How to run SQL script in MySQL?

Question

I want to execute a text file containing SQL queries, in MySQL.

I tried to run source /Desktop/test.sql and received the error:

mysql> . homesivakumarDesktopest.sql ERROR: Failed to open file 'homesivakumarDesktopest.sql', error: 2

Any idea on what I am doing wrong?

Answer 1

If you’re at the MySQL command line mysql> you have to declare the SQL file as source.

mysql> source homeuserDesktopest.sql;