I'm using MySQL workbench to import a Joomla sample_data.sql file into my local database. I want it to continue importing, even if an error occurs, by skipping the line that caused the error.
Is there something I can prefix the SQL with to prevent the query from halting at any errors?
try
mysql --force < sample_data.sql
Mysql help section says
-f, --force Continue even if we get an sql error.