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]#