Database Reverse Engineering
- Download and install DBDesigner 4 : http://www.fabforce.net/dbdesigner4/. It is a tool licensed as GPL.
- Because this client was released before Mysql5 you have to :
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE Host='some_host' AND User='some_user'; mysql> FLUSH PRIVILEGES;
- Choose Database > Reverse Engineering
- Make a new connection (if not existing) and drag desired database into the right frame
- Remember to supply the password again on the bottom of the right frame and click connect
- Select tables to show in diagram and click execute
