-
Notifications
You must be signed in to change notification settings - Fork 11
Open
Description
While following this: https://umami.is/docs/guides/migrate-mysql-postgresql#running-migration I've encountered:
Password for user xxxxxxx:
INSERT 0 13
invalid command \'insertBefore
invalid command \'
invalid command \'
invalid command \'
invalid command \'
invalid command \'insertBefore
invalid command \'s
invalid command \'s
invalid command \'s
invalid command \'s
invalid command \'s
invalid command \'s
invalid command \'s-johnny',NULL,'/artists',NULL,'','Ritmo
invalid command \'s
invalid command \'s
invalid command \'s
invalid command \'s
invalid command \'s-johnny',NULL,'',NULL,1,NULL,'dcfa56c6-feaf-5c24-badb-4033f9f7a6f4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ritmoepoesia.pt'),('9ec4eac9-ec3a-4e7e-86a7-c1a741decd28','c788e969-c0f2-4163-b9fd-94bb6483af46','b3af3d31-95de-5096-b1bc-0ab41ad628a0','2025-09-14
invalid command \'s
invalid command \'s
invalid command \'s
invalid command \'s
invalid command \'s
invalid command \'s
invalid command \'s
invalid command \'s
ERROR: syntax error at or near "um"
LINE 1: ...-4275-bee3-909c5e98c53f','audioTitle','Levaste c\'um pau?',N...
I fixed this by applying an extra transformation with sed:
sed -i "s/\\\\'/\'\'/g" mydbdump.sql
Not sure if this is correct but it seems to have worked.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels