Bug #19796 mysqldump output error
Submitted: 13 May 2006 20:13 Modified: 14 Jun 2006 14:20
Reporter: Alexandr Ciornii Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:4.1.18 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[13 May 2006 20:13] Alexandr Ciornii
mysqldump -u login -p --default-character-set=cp1251 --extended-insert -r out.sql dbname
outputs SQL that contains unescaped single qoutes within single quotes (that surround field value). Thus, resulting SQL produces an error when executing it at another computer.
Double quotes are escaped properly.
As I see in changes, this error is not yet corrected.

How to repeat:
Dump database with BLOB with value containing single quotes.

Suggested fix:
escape them
[14 May 2006 14:20] Valeriy Kravchuk
Thank you for a problem report. Please, sent the exact CREATE TABLE statement to use and simplest data (INSERT statements) to demonstrate the problem you described.
[14 Jun 2006 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".