# PT- Archiver Error for mysql5.6

**URL:** <https://forums.percona.com/t/pt-archiver-error-for-mysql5-6/35164>\
**Category:** MySQL & MariaDB\
**Tags:** mysql\
**Created:** [November 21, 2024, 8:44am UTC](https://forums.percona.com/t/pt-archiver-error-for-mysql5-6/35164 "2024-11-21T08:44:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![runsshark](https://avatars.discourse-cdn.com/v4/letter/r/b4bc9f/32.png) [@runsshark](https://forums.percona.com/u/runsshark)\
**Post date:** [November 21, 2024, 8:44am UTC](https://forums.percona.com/t/pt-archiver-error-for-mysql5-6/35164/1 "2024-11-21T08:44:48Z")

</div>

Hi,  
Getting below error from PT-Archiver…

Unicode surrogate U+D83D is illegal in UTF-8 at /usr/bin/pt-archiver line 6924.

My MySQL version is 5.6, and the character set of the table is UTF8, which stores special characters such as “���”, causing pt-archiver errors. However, I do not have this problem in MySQL version 5.7.

Here are my pt archiver commands:

pt-archiver --no-version-check --source h=xxx,u=root,p=xxx,P=3306,D=zuoning2\_v2,t=his\_sales\_trade\_log\_ext,A=utf8 --where ‘created \< DATE\_SUB(NOW(), INTERVAL 1095 DAY)’ --charset utf8 --statistics --limit 100000 --txn-size 100000 --file ./his\_sales\_trade\_log\_ext.txt --skip-foreign-key-checks --no-delete

---

<div class="post-metadata">

**Author:** ![Agustin\_G](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/agustin_g/32/14111_2.png) [@Agustin\_G](https://forums.percona.com/u/Agustin_G)\
**Post date:** [November 21, 2024, 10:31pm UTC](https://forums.percona.com/t/pt-archiver-error-for-mysql5-6/35164/2 "2024-11-21T22:31:28Z")

</div>

Hi @runsshark,

You should check how to enable utf8mb4 in your MySQL 5.6 instance to see if it helps.

---

<div class="post-metadata">

**Author:** ![runsshark](https://avatars.discourse-cdn.com/v4/letter/r/b4bc9f/32.png) [@runsshark](https://forums.percona.com/u/runsshark)\
**Post date:** [November 22, 2024, 1:57am UTC](https://forums.percona.com/t/pt-archiver-error-for-mysql5-6/35164/3 "2024-11-22T01:57:06Z")

</div>

Thank you for your reply. I have thousands of MySQL 5.6 instances all in UTF-8, which store customer data and cannot modify the character set. I can only find a solution to the above problem