个人工具
119.28.94.63
该IP地址的讨论
登录
查看“UbuntuHelp:MySqlWorkBench”的源代码 - Ubuntu中文
UbuntuHelp
讨论
查看源代码
历史
搜索
导航
首页
最近更改
随机页面
页面分类
帮助
编辑
编辑指南
沙盒
新闻动态
字词处理
工具
链入页面
相关更改
特殊页面
页面信息
查看“UbuntuHelp:MySqlWorkBench”的源代码
来自Ubuntu中文
←
UbuntuHelp:MySqlWorkBench
跳转至:
导航
,
搜索
因为以下原因,你没有权限编辑本页:
您所请求的操作仅限于该用户组的用户使用:
用户
您可以查看与复制此页面的源代码。
{{From|https://help.ubuntu.com/community/MySqlWorkBench}} {{Languages|UbuntuHelp:MySqlWorkBench}} As of this writing (November 2009), MySQL Workbench can be easily installed on Ubuntu/Gnome. Just [http://dev.mysql.com/downloads/workbench/ download the binary .deb file from the MySQL web site for workbench] (currently named mysql-workbench-oss-5.1.18-1ubu904-i386.deb), save it to your home directory. Then run: <pre><nowiki> sudo apt-get install liblua5.1-0 libzip1 libmysqlclient15off python-pexpect sudo dpkg -i mysql-workbench-oss-5.1.18-1ubu904-i386.deb (adapt the name accordingly) </nowiki></pre> Then, you have MySQL Workbench listed under "Applications > Programming". /* I think this could be removed. If you get this error when trying to connect to your local MySQL database: <pre><nowiki> Couldn't load library libmysqlclient_r.so: libmysqlclient_ro.so: cannot open shared object file: No such file or directory" </nowiki></pre> Create a symbolic link like so: <pre><nowiki> sudo ln -sf /usr/lib/libmysqlclient_r.so.16.0.0 /usr/lib/libmysqlclient_r.so </nowiki></pre> [http://bugs.mysql.com/bug.php?id=47152 Bug #47152]. ------------------------------------------------------ These are the previous notes left for history purpose: My notes on installing MySqlWorkBench. As far as I can tell, no one has started working on packaging it. <pre><nowiki> sudo apt-get install build-essential liblualib50-dev libglade2-dev libxml++2.6-dev libgtkmm-2.4-dev libpcre3-dev libmysqlclient15-dev uuid-dev libglut3-dev wget http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-gui-tools-5.0r5.tar.gz/from/http://mysql.mirrors.hoobly.com/ tar xzvf mysql-gui-tools-5.0r5.tar.gz cd mysql-gui-tools-5.0r5/mysql-gui-common ./configure --enable-grt --enable-canvas make make install cd ../mysql-workbench ./configure make make install mysql-workbench </nowiki></pre> It runs. it segfaulted on me in the fist 5 min of playing. so play on backup data. here is a line to dump all databases (except the system one) from one server: <pre><nowiki> mysql -u root -pfoo -Bqse 'SHOW dATABASES' | grep -Ev '^mysql$' | while read db ; do mysqldump -uroot -pfoo --databases $db ; done >all_databases.sql sudo apt-get install mysql-server-5.0 mysql -u root < all_databases.sql </nowiki></pre> ---- from the mail list: The "extra requirements" for mysql-gui-common (when you want support for the Generic Canvas and the GRT) include uuid-dev package and several others, as described here: http://forge.mysql.com/wiki/Building_MySQL_GUI_Tools_on_Linux I then came across this post which depressed me at first: http://www.monkeyhelper.com/2006/07/mysql_workbench_and_ubuntu_dap.html However, I was able to get completed builds on everything using the SVN trunk revisions for my Ubuntu 6.06 LTS (Dapper) (on both my i386 and also on my AMD64/x86_64 host) by doing as follows: <pre><nowiki> sudo apt-get install subversion autoconf automake1.9 libtool svn co http://svn.mysql.com/svnpublic/mysql-gui-common/trunk mysql-gui-common cd mysql-gui-common sh ./autogen.sh --enable-grt --enable-canvas make sudo make install cd .. svn co http://svn.mysql.com/svnpublic/mysql-administrator/trunk mysql-administrator cd mysql-administrator sh ./autogen.sh make sudo make install cd .. sudo apt-get install libgtkhtml3.8-dev # Determine which revision of libgtkhtml ... $ ls /usr/lib/pkgconfig/libgtk* # Then include that revision in the --with-gtkthml clause below. $ svn co http://svn.mysql.com/svnpublic/mysql-query-browser/trunk mysql-query-browser $ cd mysql-query-browser $ sh ./autogen.sh --with-gtkhtml=libgtkhtml-3.8 $ make $ sudo make install $ cd .. svn co http://svn.mysql.com/svnpublic/mysql-workbench/trunk mysql-workbench cd mysql-workbench sh ./autogen.sh make sudo make install cd .. svn co http://svn.mysql.com/svnpublic/mysql-migration-tool/trunk/ mysql-migration-tool cd mysql-migration-tool # um.. what next doc? there is no ./autogen.sh or INSTALL.txt... </nowiki></pre> I'll clean this up as I go. ---- Some more notes (new user) I'm trying this on using the directions up top. While trying to compile the tools I get the following: g++ -DHAVE_CONFIG_H -I. -I. -I../../.. -I/usr/include/mysql -DBIG_JOINS=1 -fPIC -I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include -I/usr/include/libxml2 -I/usr/include/freetype2 -DDLOAD_JVM -I/usr/include/lua50 -I../../../library/base-library/include -I../../../library/utilities/include -I../../../library/utilities/shared_include -I../../../library/generic-runtime/include -I../../../library/generic-canvas/include -I../../../library/generic-canvas/ftgl/include -DENABLE_LUA_MODULES -I../include -MT GraphRenderer.lo -MD -MP -MF .deps/GraphRenderer.Tpo -c GraphRenderer.cpp -fPIC -DPIC -o .libs/GraphRenderer.o GraphRenderer.cpp: In member function 'void GraphRenderer::recalc_outer_rect()': GraphRenderer.cpp:432: error: 'INT_MAX' was not declared in this scope GraphRenderer.cpp:434: error: 'INT_MIN' was not declared in this scope It appears these used to be warnings, but that changed in g++-4.3. Compiling with g++4.2 I get other errors. */ [[category:UbuntuHelp]]
该页面使用的模板:
模板:From
(
查看源代码
)
模板:Languages
(
查看源代码
)(受保护)
模板:Languages/Lang
(
查看源代码
)(受保护)
返回至
UbuntuHelp:MySqlWorkBench
。