I had similar issue recently and found this little optimization helps with parsing large sql files:

[BhargavCnp]

          I had similar issue recently and found this little optimization helps with parsing large sql files:

https://github.com/Pamblam/mysql-import/pull/14/files

In my use case I had a 5MB mysqldump file that took 10 minutes to parse/process. Now it only takes a few seconds.

Originally posted by @WooDzu in https://github.com/Pamblam/mysql-import/issues/10#issuecomment-514181959

[BhargavCnp]

I had similar issue recently and found this little optimization helps with parsing large sql files: can you provide anyone proper solution myDB.zip