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

• Submitted: 13 Dec 2005 21:36
• Modified: 14 Dec 2005 0:35
• Reporter: Bob McGuire
• Status: Verified
• Category: MySQL Server: mysqldump Command-line Client
• Severity: S4 (Feature request)
• Version: 4.1 >
• OS: Linux (linux (or all))
• CPU Architecture: Any

[13 Dec 2005 21:36] Bob McGuire

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

[14 Dec 2005 0:34] Timothy Smith

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.