Extra characters added to large BLOB after mysqldump and mysql import in Red Hat Enterprise Linux 5

Solution Verified - Updated -

Issue

  • What is the possibility of backporting the following bug which was noted as fixed in MySQL 5.0.80: http://bugs.mysql.com/bug.php?id=41486
  • mysqldump/import of big BLOB's brings new characters
  • Restoring from a dump adds "\n" randomly in queries longer than 32Mb
  • When importing large blobs (larger than the value of the mysql client's max_allowed_packet), extra invalid characters will be added to the data.

Environment

Red Hat Enterprise Linux 5 / mysql-5.0.77

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.