How to split a large dump file for MySQL import?

Question

MySQL

Colleagues, good afternoon!
Faced the following problem:
When importing MySQL large dumps to the server (~5 GB), the import process hangs and does not return any result. After examining the files with a Hex editor, I came to the conclusion that the content is one big INSERT INTO *** VALUES()
Question. How to break a given INSERT programmatically to successfully import a dump.
PS I also tried utilities:
MySQLDumpSplitter.jar - gives an error
https://sqldumpsplitter.net - row limit (134 million)
Thanks in advance!
Best regards,
Nikita

Answer 1

I recommend The MySQL Command-Line Tool , for example:

mysql -u username -p -h localhost DATA-BASE-NAME < data.sql

Answer 2

Well, under Windows (you can run under Vine in Linux) there is a program client
https://www.heidisql.com
When loading huge dumps, it tries to repartition inserts on the fly.