Bug #59054 mysqladmin dump options to toggle DROP TABLE and CREATE TABLE

• Submitted: 20 Dec 2010 10:12
• Modified: 20 Dec 2010 10:46
• Reporter: Tarek Adam
• Status: Verified
• Category: MySQL Workbench: Administration
• Severity: S4 (Feature request)
• Version: 5.2.31
• OS: MacOS
• CPU Architecture: Any
• Tags: Backup, dump, restore

[20 Dec 2010 10:12] Tarek Adam

Description:
WORKBENCH > SERVER ADMINISTRATION > DATA DUMP > ADVANCED EXPORT OPTIONS

There is no option to turn on/off DROP TABLE IF EXISTS

The option to turn on/off no-create-info results in a dump project folder that can not be used to restore.

The result of the combination of these two limitations is that, I am unable to dump and restore just data from one db to an identical db.  It always drops and creates tables.

How to repeat:
Create a dump project (multi-file).  It will always drop the tables.

Suggested fix:
- offer a check toggle to include or exclude table drops
- offer a check toggle to switch between CREATE TABLE and CREATE TABLE IF NOT EXISTS

[20 Dec 2010 10:46] Valeriy Kravchuk

Thank you for the feature request.