Bug #51168 mysqldump, mysqlimport missing --lines-starting-by option
Submitted: 13 Feb 2010 20:43 Modified: 14 Feb 2010 11:02
Reporter: Paul DuBois Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request)
Version:5.0+ OS:Any
Assigned to: CPU Architecture:Any

[13 Feb 2010 20:43] Paul DuBois 
Description:
mysqldump has --fields-terminated-by, --fields-enclosed-by, --fields-optionally-enclosed-by, --fields-escaped-by=name, and --lines-terminated-by options, corresponding to the SELECT ... INTO OUTFILE data-formatting clauses FIELDS TERMINATED BY, FIELDS [OPTIONALLY] ENCLOSED BY, FIELDS ESCAPED BY, and LINES TERMINATED BY.

Similarly, mysqlimport supports similar options for the corresponding clauses of LOAD DATA INFILE.

However, SELECT ... INTO OUTFILE and LOAD DATA INFILE have a LINE STARTING BY clause. mysqldump and mysqlimport have no --lines-starting-by option corresponding to this clause.

How to repeat:
mysqldump --help
mysqlimport --help

Suggested fix:
Add a --lines-starting-by option for mysqldump and mysqlimport.

This is a feature request, for better completeness in supporting SELECT ... INTO OUTFILE/LOAD DATA INFILE clauses. It's probably low priority, given that no one has asked for it before.
[14 Feb 2010 11:02] Valeriy Kravchuk 
Thank you for the feature request.