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:
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

[17 May 2010 21:07] Mike Quilleash
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.
[19 Jun 2010 8:43] Valeriy Kravchuk
Thank you for the feature request.