How to make mysql skip errors on import?

Question

MySQL

The bottom line is that when importing from a .sql dump, an error occurs in the syntax inside the file and the upload to the database stops. So, how to make it so that when uploading the dump to the database, errors are simply ignored and problem areas are skipped, and the import goes on?

Answer 1

Use the --force, -f flag

--force, -f
Ignore all errors; continue even if an SQL error occurs during a table dump.
One use for this option is to cause mysqldump to continue executing even when it encounters a view that has become invalid because the definition refers to a table that has been dropped. Without --force, mysqldump exits with an error message. With --force, mysqldump prints the error message, but it also writes an SQL comment containing the view definition to the dump output and continues executing.
If the --ignore-error option is also given to ignore specific errors, --force takes precedence.

https://dev.mysql.com/doc/refman/8.0/en/mysqldump....