Bug #51351 Workbench restore to another schema
Submitted: 20 Feb 2010 15:08 Modified: 11 Dec 2013 6:19
Reporter: Oded Dror Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S4 (Feature request)
Version:5.2.15 OS:Windows (XP x32 or Vista x64)
Assigned to: CPU Architecture:Any
Tags: database

[20 Feb 2010 15:08] Oded Dror
Description:
Hi there
I'm using MySql 5.1 Community edition, Workbench 5.2.15 beta on Windows XP Pro SP2 x32 and Vista Business x64

In workbench admin > Data Dump > Export to disk tab you have an option to export to a backup folder (multiple objects - tables and views but not routines or functions why?)

In the Import from disk you don't have an option to select which schema or even to choose another schema (like MySql administrator) and the Load folder content button is inactive

How to repeat:
Everytime you open the workbench you have this problems.

Suggested fix:
1. Export all database objects - Tables, Views, Routines, Function, Schema
2. Make an option to restore all objects from dump folder
3. Make option to choose database schema to restore to or another schema
4. activate the Load content button
[23 Feb 2010 8:26] Susanne Ebrecht
Many thanks for writing a feature request. We will discuss this.
[24 Apr 2010 7:21] Peter Brookes-Smith
Hi 
the feature to restore to another schema is very useful to me. 

Without it, I have to edit some very large dump files by hand which makes the prone to error. 

Any news on where you are with this request?

Btw I love the latest release. Excellent work and thanks very much. 

Peter
[27 Apr 2010 15:06] Tom Melly
Can I just add my support for this feature request? It's pretty much essential in our development environment, where we frequently want to restore a dump to various different databases...
[28 Mar 2011 13:24] Valeriy Kravchuk
See Bug #55057 also. Probably they are duplicates.
[30 Jun 2011 10:06] Jon Stephens
BUG#60672 and BUG#55057 are duplicates of this bug.
[11 Dec 2013 6:19] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.0.9 release, and here's the changelog entry:

The restore operation can restore to a different schema.

Thank you for the bug report.