MySql GUI Either the server service or the configuration file could not be found. (ZT)

Either the server service or the configuration file could not be found. Startup variables and service section are therefore disabled.
If you get this message when you are connecting to your MySql Database using the MySql GUI tools, exactly as happened to me the do the following.

Start the Admin tool and skip the login.

Skip the log in step by pressing & holding the ctrl key and clicking "Skip". (appears where the cancel key is pressed)

Under Service Control (left side) and Configure Service Tab you will see Path to binary mine was set to hmail server's directory and needs to be set to
D:\wamp\bin\mysql\mysql5.0.51b inmysqld-nt (or your server install path)

from: http://www.wissamidrissi.com/2008/11/mysql-gui-either-server-service-or.html

发现一款不错的sqlite管理工具

网上浏览的时候发现有人推荐一款基于Firefox插件的sqlite管理工具,sqlite manager, 试用了一下,很是不错. 下载地址 https://addons.mozilla.org/en-US/firefox/addon/5817

在Ubuntu上面安装DBDesigner4

在windows上面用了DBDesigner4了以后，感觉很好用，于是今晚费了一些时间给我的Ubuntu也安装了一份，Ubuntu上面安装比较麻烦，根据不同的电脑，具体步骤可能不一样，这里把我做的步骤列下来供以后参考（我的机子上面已经安装了mysql server和mysql client）

第一部当然是让DBDesigner能够跑起来：

1. Go to http://www.fabforce.net/downloads.php to download file DBDesigner4.0.5.4.tar.gz, unpack it.
2. run ./stardb, then view log file at ~/.DBDesigner4/DBD4.log to check what are the library missing (libXft.so.1, libstdc++-libc6.2-2.so.3, libqt.so.2)
3. libXft.so.1 : ln -s /usr/lib/libXft.so.2.1.2 /usr/lib/libXft.so.1
4. libsdc++-libc6.2-2.so.3 : Go to http://packages.ubuntu.com/zh-cn/gutsy/libstdc++2.10-glibc2.2 to download the library  file and install
5. libqt.so.2: Go to http://prdownloads.sourceforge.net/kylixlibs/kylixlibs3-borqt-3.0-2.tar.gz?download to download the package, then unpack, then
   
   
   
   • sudo cp kylixlibs3-borqt/libborqt-6.9.0-qt2.3.so /usr/lib/libborqt-6.9-qt2.3.so
   
   
   • cd DBDesigner4/Linuxlib
   
   
   • sudo rm libqt.so.2
   
   
   • ln -s /usr/lib/usr/lib/kylix3/libborqt-6.9.0-qt2.3.so libqt.so.2

第二步就是让DBDesigner能够顺利连接MySQL

1. Go to http://www.devart.com/dbx/download.html to download dbExpress MySQL driver for linux, unpack,  sudo cp libsqlmda.so.4.40 /usr/lib/
2. Under folder DBDesigner4/Linuxlib, do
   
   
   
   • sudo rm libmysqlclient.soln -s /usr/lib/libmysqlclient.so.15 libmysqlclient.so
     
   
   
   • rm libsqlmy.so
   
   
   • ln -s /usr/lib/libsqlmda.so.4.40 libsqlmy.so
3. Run ./startdb,
   ”Database”->”Connect to Database”->"New Database Connection"->"Advance"
    Set GetDriverFunc： getSQLDriverMySQL

接下来就是修改stardb.desktop,把里面的路径改一下，然后把startdb.desktop放到桌面就可以了

使用DBDesigner4进行mysql5建模

这两天需要构建一个MySQL的数据库,想要留下比较正规的文档,就考虑用MySQL建模软件,这样数据库结构比较清晰.

下载了MySQL Workbench最新版本,建模搞定后导出的SQL竟然运行错误,有两个table怎么也创建不了.于是在google上找到了DBDesigner.又用它把数据库重建了一次,然后直接和MySQL server synchronize,很顺利的创建了整个数据库. 以后考虑就是用这个了.

下面是网上找到的DBDesigner的安装方法:

URL: http://www.phpd.cn/show-51-1.html

=============================

DBDesigner4.0.5.6_Setup.exe下载地址：

http://www.fabforce.net/downloadfile.php

官方网站下载的DBDesinger 4中是不能连接MySQL 5的,那是驱动的原因,可以到http://crlab.com/dbx/download.html 下载最新版的驱动,安装好后,复制安装目录中的dbexpmda.dll到DBDesigner的目录当中,还需要下载最新版本的libmysql.dll,同样复制到DBDesigner的目录当中.

驱动准备好了,打开DBDesigner,新建一个MySQL连接,在 Advanced修改GetDriverFunc为getSQLDriverMySQL,这是因为新版驱动对函数名称做了修改的缘故,还要修改 LibraryName为dbexpmda.dll,现在应该能连上MySQL 5了.