i’m trying to import a dump, but i’m getting syntax errors that kills the import, the problem is, i can fix the errors on the source DB, but i cannot see them all at once, neither ignore the errors with “-f”, is there a way to see all the errors at once? i’ve adjust the charset and collation but errors still occur, the original database is kind of a mess, i get errors like this one:

ERROR 1064 (42000) at line 6613: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ”Sistema vinculou responsavel em 20/06/2023 15:27:13 Sistema vin’ at line 1

I can only dump the DB at night to not slow down the production, and that make the process a lot slower.

I’ve tried changing the names to latin1 on the dump file, (as is on the original DB) but it did not help.

I am using the mysqldump db > db.sql command to create the dump and using mysql db < db.sql to import it.

The original DB is on MySQL 5.6, i’ve tried to import it on a MySQL Server 5.6 and 8.0.

The syntax is broken because of a single quote, but it’s also been broken with /n and a lot of other symbol/syntax problems. the dump file is quite large at 4GB.