mysql load sql from file
mysql> use db_name; mysql> source file_name.sql;
Source: stackoverflow.com
how to load files in mysql
LOAD DATA INFILE 'c:/tmp/discounts.csv' INTO TABLE discounts FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS; Code language: SQL (Structured Query Language) (sql)
Source: www.mysqltutorial.org