Database Charset Not Preserved
- Dominant language
- PHP
- Stars
- 53
- Forks
- 88
- PR merge metrics
- No merged PRs in 30d
Description
When running the script the database charset was not preserved. This will stop your emojis, or any special characters, from being transferred correctly. I recommend adding --default-character-set= in my case --default-character-set=utf8mb4 to both the mysqldump and mysql. Also for large databases I recommend removing the -v flag so every insert isn't printed to the console. I would also recommend not using Azure Cloud Shell as the timeout of 20 min is too short to successfully migrate a large database.
Contributor guide
No contributing guide indexed for this repository
Research direction
Locate the migration script and the mysqldump/mysql commands it runs. Verify how the character set and verbose output are passed, then confirm that a migration preserves emojis and special characters; treat the Azure Cloud Shell timeout note as an environment constraint.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, mysql
- Domain
- cloud, databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 28/100