Importing MySQL data from non-MySQL backup file

Archived Topics
1

I have a backup of SQL data from another database in the form of hundreds of thousands of lines of INSERT queries. How can I feed these into MySQL?

INSERT INTO graph_chiller (graph_chiller_ndx, c1_inlet_temp, c1_juice_pressure, c1_outlet_temp, c2_inlet_temp, c2_juice_pressure, c2_outlet_temp, vessel_pressure, t_stamp, liq_line_sv_output, suction_2_sv_output, suction_5_sv_output) VALUES (1, 40.250591, 72.177429, 28.086, 36.3214, 74.102463, 26.51829, 29.753571, '2006-07-20 17:22:51.264', 1, 1, 1);
2

You can feed those SQL queries into MySQL with the following command in MS DOS:

mysql --host=localhost --port=3306 --user=root --password TestDB < "C:\import.sql"

Note:

Make sure you change directory to MySQL’s bin directory before you run this command. The bin directory is usually located at “C:\Program Files\MySQL\MySQL Server 5.0\bin”. Also, ‘TestDB’ above is the database you want to run the queries against.