“UbuntuHelp:MySqlWorkBench”的版本间的差异
来自Ubuntu中文
小 （新页面: {{From|https://help.ubuntu.com/community/MySqlWorkBench}} {{Languages|UbuntuHelp:MySqlWorkBench}} My notes on installing MySqlWorkBench. As far as I can tell, no one has started working ...） |
小 |
||
| 第2行： | 第2行： | ||
{{Languages|UbuntuHelp:MySqlWorkBench}} | {{Languages|UbuntuHelp:MySqlWorkBench}} | ||
My notes on installing MySqlWorkBench. | My notes on installing MySqlWorkBench. | ||
| − | |||
As far as I can tell, no one has started working on packaging it. | As far as I can tell, no one has started working on packaging it. | ||
| − | |||
<pre><nowiki> | <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 | 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/ | 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 | tar xzvf mysql-gui-tools-5.0r5.tar.gz | ||
| − | |||
cd mysql-gui-tools-5.0r5/mysql-gui-common | cd mysql-gui-tools-5.0r5/mysql-gui-common | ||
./configure --enable-grt --enable-canvas | ./configure --enable-grt --enable-canvas | ||
make | make | ||
make install | make install | ||
| − | |||
cd ../mysql-workbench | cd ../mysql-workbench | ||
./configure | ./configure | ||
make | make | ||
make install | make install | ||
| − | |||
mysql-workbench | mysql-workbench | ||
</nowiki></pre> | </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: | 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> | <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 | 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 | sudo apt-get install mysql-server-5.0 | ||
mysql -u root < all_databases.sql | mysql -u root < all_databases.sql | ||
| − | |||
</nowiki></pre> | </nowiki></pre> | ||
---- | ---- | ||
from the mail list: | 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: | 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 | http://forge.mysql.com/wiki/Building_MySQL_GUI_Tools_on_Linux | ||
| − | |||
I then came across this post which depressed me at first: | I then came across this post which depressed me at first: | ||
http://www.monkeyhelper.com/2006/07/mysql_workbench_and_ubuntu_dap.html | 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 | 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: | 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> | <pre><nowiki> | ||
sudo apt-get install subversion autoconf automake1.9 libtool | sudo apt-get install subversion autoconf automake1.9 libtool | ||
| − | |||
svn co http://svn.mysql.com/svnpublic/mysql-gui-common/trunk mysql-gui-common | svn co http://svn.mysql.com/svnpublic/mysql-gui-common/trunk mysql-gui-common | ||
cd mysql-gui-common | cd mysql-gui-common | ||
| 第56行： | 第39行： | ||
sudo make install | sudo make install | ||
cd .. | cd .. | ||
| − | |||
svn co http://svn.mysql.com/svnpublic/mysql-administrator/trunk mysql-administrator | svn co http://svn.mysql.com/svnpublic/mysql-administrator/trunk mysql-administrator | ||
cd mysql-administrator | cd mysql-administrator | ||
| 第63行： | 第45行： | ||
sudo make install | sudo make install | ||
cd .. | cd .. | ||
| − | |||
sudo apt-get install libgtkhtml3.8-dev | sudo apt-get install libgtkhtml3.8-dev | ||
| − | |||
# Determine which revision of libgtkhtml ... | # Determine which revision of libgtkhtml ... | ||
$ ls /usr/lib/pkgconfig/libgtk* | $ ls /usr/lib/pkgconfig/libgtk* | ||
# Then include that revision in the --with-gtkthml clause below. | # Then include that revision in the --with-gtkthml clause below. | ||
| − | |||
$ svn co http://svn.mysql.com/svnpublic/mysql-query-browser/trunk mysql-query-browser | $ svn co http://svn.mysql.com/svnpublic/mysql-query-browser/trunk mysql-query-browser | ||
$ cd mysql-query-browser | $ cd mysql-query-browser | ||
| 第76行： | 第55行： | ||
$ sudo make install | $ sudo make install | ||
$ cd .. | $ cd .. | ||
| − | |||
svn co http://svn.mysql.com/svnpublic/mysql-workbench/trunk mysql-workbench | svn co http://svn.mysql.com/svnpublic/mysql-workbench/trunk mysql-workbench | ||
cd mysql-workbench | cd mysql-workbench | ||
| 第83行： | 第61行： | ||
sudo make install | sudo make install | ||
cd .. | cd .. | ||
| − | |||
svn co http://svn.mysql.com/svnpublic/mysql-migration-tool/trunk/ mysql-migration-tool | svn co http://svn.mysql.com/svnpublic/mysql-migration-tool/trunk/ mysql-migration-tool | ||
cd mysql-migration-tool | cd mysql-migration-tool | ||
| − | |||
# um.. what next doc? there is no ./autogen.sh or INSTALL.txt... | # um.. what next doc? there is no ./autogen.sh or INSTALL.txt... | ||
| − | |||
</nowiki></pre> | </nowiki></pre> | ||
| − | |||
I'll clean this up as I go. | I'll clean this up as I go. | ||
[[category:UbuntuHelp]] | [[category:UbuntuHelp]] | ||
2007年11月30日 (五) 20:24的版本
 |
点击翻译: |
English |
请不要直接编辑翻译本页，本页将定期与来源同步。 |
My notes on installing MySqlWorkBench. As far as I can tell, no one has started working on packaging it.
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
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:
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
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:
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...
I'll clean this up as I go.
