MySQL to Postgres migration guide is not correct
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 45/100
- Issue type
- Documentation
- Clarity
- Mostly clear
- Activity status
- Stale
- Tech stack
- mysql, postgresql
- Domain
- databases, documentation
Research direction
Start with the linked MySQL-to-Postgres migration guide and reproduce the reported command output using the example dump and sed transformation. Determine which migration step produces the invalid commands, then update the guide so the documented process handles the shown dump without an unexplained manual workaround.
Written by the indexing model from the issue text.
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.
- Dominant language
- MDX
- Stars
- 5
- Forks
- 25
- PR merge metrics
- No merged PRs in 30d
Getting set up
This project ships no dev container, Dockerfile or contributing guide, so setting up is up to you: start from its README, and see our first-contribution guide for the general steps.
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from umami-software/docs
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
umami-software/docs#33 · 2 comments ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
umami-software/docs#31 ·
-
Difficulty 1/5 Under an hour Newbie friendliness 82/100
umami-software/docs#15 ·
-
Difficulty 3/5 1-2 days Newbie friendliness 35/100
umami-software/docs#21 ·
-
Difficulty 1/5 Under an hour Newbie friendliness 55/100
umami-software/docs#9 · 2 reactions ·
All issues in umami-software/docs
Similar issues
-
Edit: RTE News LogoOpencheck:failed logos:edit
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
iptv-org/database#36354 · 1 comment ·
Maintainers usually reply within 4 days
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
Maintainers usually reply within 2 days
-
📘 Docs supabase/cli
Difficulty 1/5 Under an hour Newbie friendliness 88/100
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
apache/streampark#4521 ·