run script file in mysql command line code example
Example 1: execute mysql file
mysql -u yourusername -p yourpassword yourdatabase < text_file
Example 2: running external script mysql command
Copied shell> mysql db_name < text_file
mysql -u yourusername -p yourpassword yourdatabase < text_file
Copied shell> mysql db_name < text_file