Importing sql into mysql error

seamore · 04-28-2022, 11:17 AM

I am importing a large text file with sql with the command:

mysql -u username -p database_name < file.sql

Processing stops at a particular line and says there is an error at line 461.

How can I have mysql print the line it could not process?

dugan · 04-28-2022, 11:31 AM

Why wouldn't you just open file.sql in a text editor (preferably one that will show you syntax errors in MySQL files) and jump to line 461?

bathory · 04-28-2022, 11:58 AM

Quote:

Originally Posted by seamore

I am importing a large text file with sql with the command:

mysql -u username -p database_name < file.sql

Processing stops at a particular line and says there is an error at line 461.

How can I have mysql print the line it could not process?

You can use:

Code:

sed -n 461p file.sql

NevemTeve · 04-28-2022, 12:53 PM

or `cat -n file.sql | less -S` then type /461<Enter>

astrogeek · 04-28-2022, 03:13 PM

While I agree with others that acting on the error message and simply looking into the query source file is the most useful way to do that under most circumstances, you can have MySQL/MariaDB log all queries using MariaDB Audit Plugin and then grep the log file for failed queries which will include a distinct return code identifying those with errors.