An IO error occurred while parsing MySQL XML document. (Invalid byte 2 of 3-byte UTF-9 sequence.)
UPDATE: Recent versions of the CDP Server and agent should not see this error. Everything is now converted to UTF-8 before being read.
Lets gather data.
This command will get all dbs using perl expression a-zA-Z0-9_ then store the results to file:\\
Now lets gather all the records and store to a different file.
Not lets diff the files and see what is different between them.
Login to mysql:
Results shows a bunch of tables but lets focus on the ones that are simliar to the diff above and I show 2 tables that could possibly match:
Then check the actual disk to see which one is missing or wrong:
Hmm there are 2 but not the foir one.
Looks like vente_foir is missing but on disk it has special character so lets change the name and remove ée:
Login back to mysql.
Run a check on that table mysql> check table vente_foir
Re-Ran backup and it completes just fine now.
|Page: An IO Error Occurred While Parsing MySQL XML Document (Archived Knowledge Base 2.0) Labels: mysql, xml|