MySQL Bugs: #6945: [mysqldump] One .sql.gz file per table

Bug #6945	[mysqldump] One .sql.gz file per table
Submitted:	2 Dec 2004 14:11	Modified:	8 Feb 2009 17:14
Reporter:	Olaf van der Spek (Basic Quality Contributor)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: mysqldump Command-line Client	Severity:	S4 (Feature request)
Version:	*	OS:	Any (*)
Assigned to:		CPU Architecture:	Any
Tags:	qc

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Could an option be added so that mysqldump output one .sql.gz file per table?
If multiple tables are backed up, all table files should be put in one .tar file per database
and if multiple databases are backed up, all database files should be put in one .tar (again).

This would make it much easier to restore a single table, especially if the entire database is very large.

How to repeat:
-

Thank you for a reasonable feature request.

Bug #35075 is a duplicate with a patch