macportsで入れたMySQL 5.6の自動起動設定をやってみた

やってみる(Try1)

キリン一番搾り生ビールを呑みながらw

babydaemons:org.macports.mysql56 root# sudo curl -O http://robwilkerson.org/_resources/hotlink/blog/mysql56.wrapper
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100   435  100   435    0     0    432      0  0:00:01  0:00:01 --:--:--   432
babydaemons:org.macports.mysql56 root# sudo curl -O http://robwilkerson.org/_resources/hotlink/blog/org.macports.mysql56.plist
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100   435  100   435    0     0    361      0  0:00:01  0:00:01 --:--:--   361
babydaemons:org.macports.mysql56 root# sudo chown root:wheel /opt/local/etc/LaunchDaemons/org.macports.mysql56/*
babydaemons:org.macports.mysql56 root# sudo chmod 755 /opt/local/etc/LaunchDaemons/org.macports.mysql56/mysql56.wrapper
babydaemons:org.macports.mysql56 root# sudo chmod 644 /opt/local/etc/LaunchDaemons/org.macports.mysql56/org.macports.mysql56.plist
babydaemons:org.macports.mysql56 root# sudo ln -s /opt/local/etc/LaunchDaemons/org.macports.mysql56/org.macports.mysql56.plist /Library/LaunchDaemons/org.macports.mysql56.plist
babydaemons:org.macports.mysql56 root#

だめらしい。

やってみた(Try2)

babydaemons:~ shingo$ sudo /opt/local/share/mysql56/support-files/mysql.server start
Starting MySQL
...... SUCCESS!
babydaemons:~ shingo$ sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql56-server.plist
babydaemons:~ shingo$

よさげな雰囲気。

XAMPPな環境でGeeklog-1.7.2-jp-exteded-1.0をCAPTCHAプラグイン付きでインストールすると落ちる

原因

ログファイルを見るとこうでした↓

$ cat error.log
2011/07/06 4:46:52 - Attempting to install the 'calendarjp' plugin
2011/07/06 4:46:52 - Attempting to create 'Calendarjp Admin' group
2011/07/06 4:46:52 - Attempting to add 'calendarjp' features
2011/07/06 4:46:52 - Adding 'calendarjp.moderate' feature to the 'Calendarjp Admin' group
2011/07/06 4:46:52 - Adding 'calendarjp.edit' feature to the 'Calendarjp Admin' group
2011/07/06 4:46:52 - Adding 'calendarjp.submit' feature to the 'Calendarjp Admin' group
2011/07/06 4:46:52 - Adding 'config.calendarjp.tab_main' feature to the 'Calendarjp Admin' group
2011/07/06 4:46:52 - Adding 'config.calendarjp.tab_permissions' feature to the 'Calendarjp Admin' group
2011/07/06 4:46:52 - Adding 'config.calendarjp.tab_autotag_permissions' feature to the 'Calendarjp Admin' group
2011/07/06 4:46:52 - Attempting to give all users in the Root group access to the 'calendarjp' Admin group
2011/07/06 4:46:52 - Registering 'calendarjp' plugin
2011/07/06 4:46:52 - Successfully installed the 'calendarjp' plugin!
2011/07/06 4:46:52 - Attempting to install the 'captcha' plugin
2011/07/06 4:46:52 - 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 5. SQL in question:
CREATE TABLE gl_cp_config (
  config_name     varchar(255) NOT NULL default '',
  config_value    varchar(255) NOT NULL default '',
  PRIMARY KEY (config_name)
) TYPE=MyISAM

2011/07/06 4:46:52 - 256 - An SQL error has occurred. Please see error.log for details. @ E:\xampp\apache\htdocs\www.hogehoge.com\private\geeklog\system\databases\mysql.class.php line 260

なんか、TYPE=MyISAMがダメって怒られてます。で怒られた内容でググってみた結果の最初のページによれば、
新しいバージョンではTYPE=MyISAMからENGINE=MyISAMに構文が変わっているようです。

対策

数カ所程度ならばパッチあてようかと思いましたが、

babydaemons@babydaemons-mobile ~
$ find /xampp/apache/htdocs/www.hogehoge.com/ -name '*.php' | xargs grep 'TYPE=MyISAM' /dev/null
/xampp/apache/htdocs/www.hogehoge.com/html/admin/plugins/themedit/install.php:                                           . ") TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/autotags/sql/mysql_install.php:) TYPE=MyISAM
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/captcha/sql/mysql_install.php:) TYPE=MyISAM
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/captcha/sql/mysql_install.php:) TYPE=MyISAM
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/mysql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/mysql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/mysql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/mysql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/mysql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/filemgmt/sql/mysql_install.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install.php:) TYPE=MyISAM COMMENT='Forum Extra User Profile Information';";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM;";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) TYPE=MyISAM COMMENT='Forum Extra User Profile Information';";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/links/sql/mysql_updates.php:        ) TYPE=MyISAM",
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/plugins/polls/sql/mysql_updates.php:        ) TYPE=MyISAM",
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php:) TYPE=MyISAM ";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.3.4_to_1.3.5.php:) TYPE=MyISAM
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.3.8_to_1.3.9.php:) TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.3.9_to_1.3.10.php:                . ") TYPE=MyISAM";
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.4.1_to_1.5.0.php:) TYPE=MyISAM
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.4.1_to_1.5.0.php:    ) TYPE=MyISAM");
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php:) TYPE=MyISAM
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php:) TYPE=MyISAM
/xampp/apache/htdocs/www.hogehoge.com/private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php:) TYPE=MyISAM

babydaemons@babydaemons-mobile ~
$

53箇所ですか。。。sedで一括置換出来なくも無いけど、MySQLのバージョンを5.5から落とすのが正解だろうなー。


と、思ったけど!

やっぱり、sedで一括置換!
babydaemons@babydaemons-mobile ~
$ cd /xampp/apache/htdocs/www.hogehoge.com/

shingo@shingo-mobile /xampp/apache/htdocs/www.nanakanet.com
$ tar cvzf TYPE=MyISAM.tar.gz `find * -name '*.php' | xargs grep 'TYPE=MyISAM' /dev/null | awk -F: '{ print $1 }'`
html/admin/plugins/themedit/install.php
private/geeklog/plugins/autotags/sql/mysql_install.php
private/geeklog/plugins/captcha/sql/mysql_install.php
private/geeklog/plugins/captcha/sql/mysql_install.php
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php
private/geeklog/plugins/filemgmt/sql/mysql_install.php
private/geeklog/plugins/filemgmt/sql/mysql_install.php
private/geeklog/plugins/filemgmt/sql/mysql_install.php
private/geeklog/plugins/filemgmt/sql/mysql_install.php
private/geeklog/plugins/filemgmt/sql/mysql_install.php
private/geeklog/plugins/filemgmt/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/forum/sql/mysql_install_2.6.php
private/geeklog/plugins/links/sql/mysql_updates.php
private/geeklog/plugins/polls/sql/mysql_updates.php
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php
private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php
private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php
private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php
private/geeklog/sql/updates/mysql_1.3.4_to_1.3.5.php
private/geeklog/sql/updates/mysql_1.3.8_to_1.3.9.php
private/geeklog/sql/updates/mysql_1.3.9_to_1.3.10.php
private/geeklog/sql/updates/mysql_1.4.1_to_1.5.0.php
private/geeklog/sql/updates/mysql_1.4.1_to_1.5.0.php
private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php
private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php
private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php

shingo@shingo-mobile /xampp/apache/htdocs/www.hogehoge.com
$ ls
html  log  private  TYPE=MyISAM.tar.gz

shingo@shingo-mobile /xampp/apache/htdocs/www.hogehoge.com
$ for f in `find * -name '*.php' | xargs grep 'TYPE=MyISAM' /dev/null | awk -F: '{ print $1 }'`; do sed -e 's/TYPE=MyISAM/ENGINE=MyISAM/' $f > $f.new; mv $f.new $f; done

shingo@shingo-mobile /xampp/apache/htdocs/www.hogehoge.com
$ find * -name '*.php' | xargs grep '=MyISAM' /dev/null
html/admin/plugins/themedit/install.php:                                                  . ") ENGINE=MyISAM";
private/geeklog/plugins/autotags/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/calendar/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/calendar/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/calendar/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/calendarjp/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/calendarjp/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/calendarjp/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/captcha/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/captcha/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/custommenu/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/filemgmt_sql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/mysql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/mysql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/mysql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/mysql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/mysql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/filemgmt/sql/mysql_install.php:) ENGINE=MyISAM";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install.php:) ENGINE=MyISAM COMMENT='Forum Extra User Profile Information';";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM;";
private/geeklog/plugins/forum/sql/mysql_install_2.6.php:) ENGINE=MyISAM COMMENT='Forum Extra User Profile Information';";
private/geeklog/plugins/links/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/links/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/links/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/links/sql/mysql_updates.php:        ) ENGINE=MyISAM",
private/geeklog/plugins/polls/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/polls/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/polls/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/polls/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/polls/sql/mysql_updates.php:        ) ENGINE=MyISAM",
private/geeklog/plugins/spamx/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/plugins/staticpages/sql/mysql_install.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/mysql_tableanddata.php:) ENGINE=MyISAM
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.2.5-1_to_1.3.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.3.11_to_1.4.0.php:) ENGINE=MyISAM ";
private/geeklog/sql/updates/mysql_1.3.4_to_1.3.5.php:) ENGINE=MyISAM
private/geeklog/sql/updates/mysql_1.3.8_to_1.3.9.php:) ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.3.9_to_1.3.10.php:                . ") ENGINE=MyISAM";
private/geeklog/sql/updates/mysql_1.4.1_to_1.5.0.php:) ENGINE=MyISAM
private/geeklog/sql/updates/mysql_1.4.1_to_1.5.0.php:    ) ENGINE=MyISAM");
private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php:) ENGINE=MyISAM
private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php:) ENGINE=MyISAM
private/geeklog/sql/updates/mysql_1.5.2_to_1.6.0.php:) ENGINE=MyISAM

shingo@shingo-mobile /xampp/apache/htdocs/www.hogehoge.com
$

で、取りあえず動いてるっぽい。

まぁ、ヒントもらった先のページでも、The next version of Zen Cart will already incorporate this MYSQL5-specific change.って書いてあったし、一応これで正解なのかも。

まとめ


いやー、Cygwin様様です!w

gem install mysqlしてみた

ここを参考にしました↓

gemのインストールは成功したが・・・

riとRDocはエラー出まくり。ドキュメントだし、時間ないし放置プレーします。orz

[root@babydaemons /export/redmine-0.9.5]# gem install mysql -- --with-mysql-dir=/usr/local/lib/mysql
Building native extensions.  This could take a while...
Successfully installed mysql-2.8.1
1 gem installed
Installing ri documentation for mysql-2.8.1...

No definition for next_result

No definition for field_name

No definition for field_table

No definition for field_def

No definition for field_type

No definition for field_length

No definition for field_max_length

No definition for field_flags

No definition for field_decimals

No definition for time_inspect

No definition for time_to_s

No definition for time_get_year

No definition for time_get_month

No definition for time_get_day

No definition for time_get_hour

No definition for time_get_minute

No definition for time_get_second

No definition for time_get_neg

No definition for time_get_second_part

No definition for time_set_year

No definition for time_set_month

No definition for time_set_day

No definition for time_set_hour

No definition for time_set_minute

No definition for time_set_second

No definition for time_set_neg

No definition for time_set_second_part

No definition for time_equal

No definition for error_errno

No definition for error_sqlstate
Installing RDoc documentation for mysql-2.8.1...

No definition for next_result

No definition for field_name

No definition for field_table

No definition for field_def

No definition for field_type

No definition for field_length

No definition for field_max_length

No definition for field_flags

No definition for field_decimals

No definition for time_inspect

No definition for time_to_s

No definition for time_get_year

No definition for time_get_month

No definition for time_get_day

No definition for time_get_hour

No definition for time_get_minute

No definition for time_get_second

No definition for time_get_neg

No definition for time_get_second_part

No definition for time_set_year

No definition for time_set_month

No definition for time_set_day

No definition for time_set_hour

No definition for time_set_minute

No definition for time_set_second

No definition for time_set_neg

No definition for time_set_second_part

No definition for time_equal

No definition for error_errno

No definition for error_sqlstate
[root@babydaemons /export/redmine-0.9.5]#