Bug #15720 wanting to restore specific tables from mysqldump generated dump

Description:
Currently I mysqldump the databases several times a week, as a whole backup.
There's ocassions where I'd like to restore selective tables from the dump.
Talking with support, there's no real easy way to accomplish this.

Under Oracle, using the export/import process allows you to do this.

So, i'm requesting that enhamcements be made to mysqldump to allow the following:

* Ability to restore selective tables
* Ability to restore selective databases

If you need me to provide more detail, feel free to contact me.

Thanks,
Bob McGuire

How to repeat:
n/a

Suggested fix:
see above description

Hi, Bob.

I've marked this feature request as Verified, as I do believe it can be useful to get just a single table out of an SQL dump that was made of several tables (or even several databases).

I should mention that using the --tab option of mysqldump will create a backup which allows this kind of fine control.  It dumps, for each table, the SQL needed to create the table, and a text file with the tab-separated data (created with SELECT INTO OUTFILE).  This does have the restriction that it must be created on the database server.

This may be a more effective solution for you at this point.