-
Notifications
You must be signed in to change notification settings - Fork 8
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.
Metadata
Metadata
Assignees
Labels
No labels