Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How do I forward engineer in MySQL Workbench without losing objects?

Tags:

database

mysql

mysql-workbench

database-design

How do I forward engineer my MySQL Model in the MySQL Workbench without losing the database's table rows?

I basically have a remote database with a users table with tuns of users in it. I also have a MySQL Model with the model of that remote database. In the model however, I have added 1 extra column to the users table. How do I add that column to the remote database without losing all users?

I have set a default value for the new column if that is a problem.

like image 920
Jeroen Avatar asked Oct 21 '13 15:10

Jeroen

People also ask

What is forward and reverse engineering in MySQL Workbench?

9.4.1 Forward Engineering 9.4.2 Reverse Engineering. MySQL Workbench provides capabilities to forward engineering physical database designs. A visual data model can be transformed into a physical database on a target MySQL Server by executing the forward engineering wizard.

What is reverse engineering in MySQL Workbench?

With MySQL Workbench, you can reverse-engineer a database using a MySQL create script or you can connect to a live MySQL server and import a single database or a number of databases.

1 Answers

Click on Database -> Synchronize Model or simply press Shift + Control + Z. A synchronization pop-up dialogue will appear and guide you through the process.

like image 141
Jeroen Avatar answered Oct 05 '22 23:10

Jeroen
Sign in to Comment

Related questions

Select Data from two tables where ID on both tables are same
mySQL max() not returning max result
Where is the mysqli prepared statement query error? [duplicate]
Renaming an image during the uploading PHP Mysql
converting true false string to boolean while using "load infile data"
SQL: Get Products from a category but also must be in another set of categories
tinyint(size), varchar(size): "size" explaination
Doctrine2.3 and OneToOne cascade persist doesn't seem to work
Deduping mySQL table
Finished Java project, now creating jar or .exe file (with Database)
Can someone clearly explain why mysqli_prepare()/bind_param() is better than real_escape_string()? [duplicate]
Protect column, disallow update, only allow insert if NULL in MySQL
Auto Increment reset to 0, but cannot insert value with id=0. Does not happen for values >0
what is the difference between 'alter table rename' and 'rename table'?
Using mysqldb and sqlite3 in the same Python 2.7 script: Should I throw in the towel?
MySQL, should I stay connected or connect when needed?
No data was received to import
Log when a row is deleted from a given table in MySQL
What is the best way to match over 10000 different elements in database?
Efficient lookup in a range table

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!