MySQL source file is quiet

I have some really large files with many inserts (18.7 million in the largest). In the invitation mysql>, if I do source file.sqlor ./file.sqleverything works well, everything falls, but for each operator performance has conclusion 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 calmly, without output?

+3
source share
2 answers

You can direct them directly to the mysql client:

mysql -u... -p my_database < file.sql
+3
source

I run on the command line:

>mysql -p <Database> < file.sql

I do not get output this way.

+2
source

Source: https://habr.com/ru/post/1719556/


All Articles