MySQL source file quietly

Question

I have a number of really large files with many insert statements (18.7 million in the largest one). At the mysql> prompt if I do a source file.sql or a ./file.sql everything works good, things get inserted, but there is output for every run statement which ways: Query OK, 1 row affected (0.00 sec).

When run this way these inserts can take a very long time. Is there a way to run sql queries quietly, with no output?

Answer 1

You can direct them straight into the mysql client:

mysql -u... -p my_database < file.sql

Answer 2

If you're doing it in a Unix shell, you could just send the output to /dev/null, using the -o option.

Answer 3

I run on the command line:

>mysql -p <Database> < file.sql

I dont get output that way.