DBdesigner is a tool to design models and database graphically with a nice feature that can draw the database schema from an existing database (reverse engineering.
There is no deb and the install may be a bit tricky due to depndencies to old libs and missing links.
Here we go.
First, we need the software package from fabforge
Now, we untar this in /opt :
cd /opt && sudo tar xzvf /path/where/is/DBDesigner184.108.40.206.tar.gz
Now download libborqt_6.9.0-3_i386.deb (that I’ve made with alien from a RPM since this package doesn’t exist for ubuntu.), and then install it with this command :
sudo dpkg -i /path/where/is/libborqt_6.9.0-3_i386.deb
Eventually, run this command :
Now you’re ready to laaunch DBdesigner with the following command (you also can put it in a shortcut in your panel or on your desktop) :
Issues and workarounds :
If you get the error message “Unable to load libsqlmy.so” when trying to connect to a mysql database, make a link like this :
sudo ln -sf /opt/DBDesigner4/Linuxlib/libsqlmy.so /usr/lib/
Retry to connect to your mysql database, you may get this error : “unable to load libmysqlclient.so”, download this libmysqlclient10.zip (I’ve extracted it from the rpm package MySQL-shared-compat-4.1.9-0.i386.rpm), extract it and made a link :
cd /usr/lib sudo unzip /path/where/is/libmysqlclient10.zip sudo ln -sf /usr/lib/libmysqlclient.so.10.0.0 /usr/lib/libmysqlclient.so
Now, if you try again to connect to your mysql database and DBdesigner complains about wrong username/password, do :
mysql -u your_mysql_username -p
And at mysql prompt type in :
mysql>SET PASSWORD FOR 'your_mysql_username'@'localhost' = OLD_PASSWORD('your_mysql_password');
Now DBdesigner should run and connect to your mysql database.
Have fun !