Error
Error Code:
3867
MySQL Error 3867: Collation Mismatch in Clone
Description
This error occurs during a MySQL clone operation when the recipient server lacks support for one or more collations used by databases or tables on the donor server. It indicates an incompatibility in character set and collation configurations between the source and target MySQL instances, preventing the successful transfer of data.
Error Message
Clone Donor collation: %s is unavailable in Recipient.
Known Causes
4 known causesRecipient Version Incompatibility
The recipient MySQL server version is older than the donor, or a different build, leading to a lack of support for certain collations.
Missing Collation Files
Essential character set or collation definition files required for the donor's collations are absent or damaged on the recipient instance.
Custom Collation Not Present
A bespoke or manually configured collation used on the donor server is not available on the recipient, causing a mismatch during the clone process.
Inconsistent MySQL Builds
Discrepancies in the compilation options or underlying system libraries between the donor and recipient MySQL instances can lead to collation differences.
Solutions
Coming SoonDetailed step-by-step solutions for this error are being prepared. In the meantime, try these general troubleshooting tips:
General Troubleshooting Tips
- Check the error message carefully for specific details
- Review recent changes that might have caused the error
- Search for the exact error code in the official documentation
- Check log files for additional context
- Try restarting the application or service