MySQL Bugs: #78140: Add --truncate option to mysqlimport

Bug #78140	Add --truncate option to mysqlimport
Submitted:	19 Aug 2015 16:53	Modified:	19 Nov 2015 15:13
Reporter:	Eric BELLO	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S4 (Feature request)
Version:	5.5	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	mysqlimport

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The option --delete is quite lengthy with big tables.
A nice feature would be an option --truncate.
Goes way faster...

How to repeat:
1. Load a big table (millions rows) using mysqlimport.
2. Load it again with mysqlimport --delete > takes much time.
3. Truncate table then load again with mysqlimport > takes less time overall.

Suggested fix:
Add option --truncate option to mysqlimport, that truncates table before loading it instead of running a delete.

thank you for the reasonable feature request.