mysql> source homeuserDesktoptest.sql;

mysql -u yourusername -p yourpassword yourdatabase < text_file

mysql -u yourusername -p yourpassword yourdatabase

mysql>CREATE DATABASE a_new_database_name

mysql -u yourusername -p yourpassword a_new_database_name < text_file

mysql -u yourusername -p yourpassword yourdatabase < query_file > results_file

mysql --user="username" --database="databasename" --password="yourpassword" < "filepath"

mysql --user="username" --database="databasename" -p < "filepath"

mysql> source C:UsersadminDesktopfn_Split.sql

mysql> source C:fn_Split.sql

source c:/dump/SQL/file_name.sql;

mysql -u user --host host --port 9999 database_name < /scripts/script.sql -p
Enter password:

mysql -uusername -ppassword database-name < file.sql

homesivakumarDesktoptest.sql

/home/sivakumar/Desktop/test.sql

source /home/sivakumar/Desktop/test.sql

source \home\user\Desktop\test.sql;

mysql --host=localhost --user=your_username --password=your_password your_database_name < pathTofilename.sql