Invalid character '\\n' in string escape code

[batuocmu]

I have a problem:
after move data from sqlite3 to mysql I encountered error “invalid character ‘\n’ in string escape code”

logger=ngalert t=2024-09-21T14:41:10.118473436+07:00 level=error msg="Invalid rule found in DB store, ignoring it" func=GetAlertRulesForScheduling error="invalid character '\\n' in string escape code"
logger=ngalert t=2024-09-21T14:41:20.076147939+07:00 level=error msg="Invalid rule found in DB store, ignoring it" func=GetAlertRulesForScheduling error="invalid character '\\n' in string escape code"
logger=ngalert t=2024-09-21T14:41:30.070180271+07:00 level=error msg="Invalid rule found in DB store, ignoring it" func=GetAlertRulesForScheduling error="invalid character '\\n' in string escape code"
logger=ngalert t=2024-09-21T14:41:40.067510085+07:00 level=error msg="Invalid rule found in DB store, ignoring it" func=GetAlertRulesForScheduling error="invalid character '\\n' in string escape code"
logger=ngalert t=2024-09-21T14:41:50.070621569+07:00 level=error msg="Invalid rule found in DB store, ignoring it" func=GetAlertRulesForScheduling error="invalid character '\\n' in string escape code"
logger=ngalert t=2024-09-21T14:42:00.079319231+07:00 level=error msg="Invalid rule found in DB store, ignoring it" func=GetAlertRulesForScheduling error="invalid character '\\n' in string escape code"

I hope everyone can help me. Thanks very much.

Enviroment:
Grafana v9.5.3
MySql: v8.0

[solitcon]

what method did you use to migrate?

[batuocmu]

I followed these steps:

• export file dump from sqlite with tool GitHub - grafana/database-migrator: Code to export grafana.db (sqlite) to MySQL-compatible SQL file, to assist in migration of Grafana data to MySQL-compatible DB.
• import file grafana.sql into mysql. During the import process, error ERROR 1062 (23000) at line 4989: Duplicate entry ‘SomeKeyName’ for key ‘UQE_tag_key_value’ occurred. I removed these error lines and continued the import until it was successful. After that, I started Grafana and discovered the above errors.