Bug #2895 mysqldump --fields-escaped-by cannot take an argument
Submitted: 19 Feb 2004 13:09 Modified: 21 Feb 2004 5:25
Reporter: Todd Keup Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S3 (Non-critical)
Version:4.1.1a alpha OS:Windows (Windows XP Pro)
Assigned to: Sergei Golubchik CPU Architecture:Any

[19 Feb 2004 13:09] Todd Keup
Description:
Executing the mysqldump command with the --fields-escaped-by option is generating an error in the mysql client for Windows.  The following command(s) work fine (single-quoted arguments do not work, they simply return a Usage syntax listing displaying the mysqldump command syntax):

mysqldump -u root -p --opt -T .\tables_dir --fields-terminated-by=, --fields-enclosed-by=\" database_name table_name
OR
mysqldump -u root -p --opt -T .\tables_dir --fields-terminated-by="," --fields-enclosed-by="\"" database_name table_name

However, when attempting to add the --fields-escaped-by=... option:

mysqldump -u root -p --opt -T .\tables_dir --fields-terminated-by=, --fields-enclosed-by=\"  --fields-escaped-by=@ database_name table_name

...returns the error message:

mysqldump: option '--fields-escaped-by' cannot take an argument

How to repeat:
Enter the command again.  I've tried a number of different escape characters and single-quoted as well as double-quoted argument syntax to no avail.  I expected the text file to be created with a different escape character or possibly no escape character.

Suggested fix:
Allow the --fields-escaped-by option to be executed successfully in the Windows mysql client.  Thank you.
[20 Feb 2004 13:04] Dean Ellis
Verified against 4.1.2/Linux.  Thank you.
[21 Feb 2004 5:25] Sergei Golubchik
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

fixed in 4.1.2
thanks!