mysqlimport - importing mysql dump method to find which line did it caused to fail -

there times when importing mysql dump, break due syntax, etc. working on large database, running:

mysql -u root -p database < import.sql

will verbose

error 1064 (42000) @ line 116238: have error in sql syntax; check manual corresponds mariadb server version right syntax use near '' @ line 389

looking @ line 389

won't since not actual line sql executing (it ignores comments, etc.)

so, in general, best way debug? how know actual line causing issue?

hope can thanks!

test