MySQL Bugs: #55803: overrite local db with db on server

Bug #55803	overrite local db with db on server
Submitted:	6 Aug 2010 13:57	Modified:	10 Sep 2010 8:09
Reporter:	John Bercik	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
i have a dev server and a localhost server and i do my editing on dev so i keep records users have changed.  I would love a feature in Server Administration that says  "bring dev db to local and overwrite"

i currently do this:

read -s -p 'Enter the MySQL Password: ' PASS1
mysql -u username -p$PASS1 -e "drop database mydb1; create database mydb1; drop database mydb2; create database mydb2;"
#read -n 1 -p "Press any key to continue"
mysqldump -h myserver -u username -p$PASS1 mydb1 | mysql -h  localhost -uusername -p$PASS1 mydb1
#read -n 1 -p "Press any key to continue"
mysqldump -h myserver -u username -p$PASS1 mydb2 | mysql -h  localhost -uusername -p$PASS1 mydb2

How to repeat:
feature request

Suggested fix:
add feature

Hello John,

this sounds interesting but I am not 100% able to follow you.

Do you want kind of replication feature ... sync dev db to local db?
By having boths servers same version.

Or do you want more a migration feature ... migrate db from dev to local server. By having older version for dev db then for local?

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".