Hi, i'm trying to migrate a dump from a 5.7

Question

Hi, i'm trying to migrate a dump from a 5.7

server to a 8.0, 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 erros 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 ''<div>Sistema vinculou responsavel em 20/06/2023 15:27:13</div> <div>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.

#english #programming #sql

0

29.05.2024

5 ответов

10 просмотров

Rafael Trevisan Автор вопроса

PavelDBA
You can try do migration from replication. Master ...

Would the replication ignore syntax errors? i don't they are caused by the version and just by dog water data

0

27 дней назад

PavelDBA

Rafael Trevisan
Would the replication ignore syntax errors? i don'...

No, it didn't ignore syntax error, but perhaps it helps you founded errors faster and corrected their. For example, foreign key names longer than 64 characters are no longer supported from MySQL 8.0.

0

27 дней назад

Rafael Trevisan Автор вопроса

PavelDBA
No, it didn't ignore syntax error, but perhaps it ...

Got it, most of the errors will come from unsanitized user input, but i will look into that. The I/O on server is already fucked, would be wise to run a replication in it?

0

27 дней назад

PavelDBA

Rafael Trevisan
Got it, most of the errors will come from unsaniti...

Is this server still in use for production right now?

0

27 дней назад

PavelDBA · Accepted Answer

PavelDBA

You can try do migration from replication. Master 5.7 - slave 8.0.

0

27 дней назад

169 похожих чатов

Hi, i'm trying to migrate a dump from a 5.7

5 ответов

Похожие вопросы