I have a database diagram designed in MySQL Workbench, and I have my database fully exported in a file (.sql), I also have later versions (incremental backup).
In summary I have the following files:
-
database.mwb
-
database.sql
-
updateA.sql
-
updateB.sql
-
updateC.sql
-
updateD.sql
-
updateE.sql
-
updateF.sql
The problem is that the "database.mwb" diagram does not match any of the databases, (Surely someone else has modified it and never exported the changes) I've tried the difference between:
- Enter "database.mwb" and "database.sql"
- Enter "database.mwb" and a file that I created with the contents of all the updated ones (copied and pasted manually by me)
- Enter "database.mwb and export phpMyAdmin (database.sql + updateA + updateB)
In conclusion, I want to have my diagram updated "database.mwb" and I do not know what to do. Perhaps the reverse engineering generates the new diagram, but there are more than 500 tables to organize again.
Is there any way to tell MySQL Workbench to modify the diagram based on the SQL file?