MySQL Bugs: #53720: Improve mysqlimport to allow the filename to be different from the table name

Bug #53720	Improve mysqlimport to allow the filename to be different from the table name
Submitted:	17 May 2010 21:07	Modified:	19 Jun 2010 8:43
Reporter:	Mike Quilleash	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S4 (Feature request)
Version:	5.1.44	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	filename, mysqlimport, tablename

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Currently mysqlimport requires the filename to have the same name as the table name.  This seems very restrictive, especially as "load data infile" doesn't have this restriction.

This is a real problem on windows platforms as you can't do any clever with symlinks, and when working on high volume systems which need to load data in parallel, even the symlink trick doesn't work (or rather it does, but causes mayhem).

How to repeat:
Run mysqlimport, if filename != tablename, load will fail.

Suggested fix:
Add --tablename option to mysqlimport.

Thank you for the feature request.