ENXF NET
Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
- Joined
- Nov 13, 2018
- Messages
- 23,639
- Points
- 823
Having moved servers today, we learned that our MySQL backups were subtly corrupted by an insidious issue that can be difficult to spot until it's too late.
All emoji and high-ascii characters in our database dumps were invalid.
This is due to a behaviour in mysqldump, which defaults the client character set to UTF8 instead of using UTF8MB4 when necessary.
To check if you are affected, review your MySQL dump SQL files and look for lines that look like this:
Read more
Continue reading...
All emoji and high-ascii characters in our database dumps were invalid.
This is due to a behaviour in mysqldump, which defaults the client character set to UTF8 instead of using UTF8MB4 when necessary.
To check if you are affected, review your MySQL dump SQL files and look for lines that look like this:
/*!40101 SET...Read more
Continue reading...