2005年12月07日
Mysql on Cygwin
¥á¥â¤Ç¤¹¡¥
¡ô¢¨°õ¤Ï¼ÂºÝ¤Ë¤Ä¤Þ¤Å¤¤¤¿½ê¤Ç¤¹(¡£Á¡®¡Ë ¸å¤Ç¹Í¤¨¤ë¤È¤Ä¤Þ¤é¤ó¤³¤È¤Ç¤Ä¤Þ¤Å¤¤¤¿¡¦¡¦¡¦
£±¡¥WindowsÈǤÎM£ùSql¤ò¥¤¥ó¥¹¥È¡¼¥ë¡¥¥¤¥ó¥¹¥È¡¼¥ëÊýË¡¤ÏŬÅö¡¥
mysql-essential-5.0.16-win32.msi
£²¡¥LinuxÈǤΥ½¡¼¥¹¤ò¥¤¥ó¥¹¥È¡¼¥ë
mysql-5.0.16.tar.gz
¢¨¤Á¤ã¤ó¤È¤·¤¿¥½¡¼¥¹¤ò¥¤¥ó¥¹¥È¡¼¥ë¤·¤Þ¤·¤ç¤¦(^^¡¶
£³¡¥untar
£´¡¥./configure --prefix=/usr/local/mysql --without-server
¢¨/usr/src¤Ê¤É¤ÇŸ³«¤·¤Ê¤¤¤È¡¤make install¤Î¤È¤¤ËÊѤÊinstall¤¬»È¤ï¤ì¤ë¡¥
¤Ê¤¼¤«home¤Ë¤¢¤Ã¤¿ns/install¤¬»È¤ï¤ì¤Æ¤¿¡¥¥Þ¥¸¤Ç¡ª
£µ¡¥°ìÉô¤ò¥³¥á¥ó¥È¥¢¥¦¥È
grep -rl "#pragma interface" * | xargs -r sed -i "s/#pragma interface/\/*#pragma interface*\//g"
£¶¡¥make, make install
£·¡¥DB¤Ë¥¢¥¯¥»¥¹¤¹¤ë¤È¤¤Ï̵Íý¤ä¤êTCP/IP¤ò»È¤¤¤Þ¤¹
$mysql -h 127.0.0.1
¤½¤Î¾
API¤ò»È¤¦¤È¤¤ÎÃí°Õ
-dl¤ò¤Ä¤±¤Æ¥³¥ó¥Ñ¥¤¤¹¤ë¾ì¹ç¤Ï¡¤°Ê²¼¤ò¤ä¤Ã¤Æ¤ª¤¯
$ cd /usr/lib
$ ln -s libcygwin.a libdl.a
libmysqlclient.so: undefined reference to `uncompress'
¤È¤¤¤¦¥¨¥é¡¼¤¬¤Ç¤ë¤È¤¤Ï¡¤¥³¥ó¥Ñ¥¤¥ë»þ¤Ë-lz¤ò¤Ä¤±¤Þ¤·¤ç¤¦¡¥
MySQL¤ÇInsert¤Î¤È¤¡¤¡ÉToo Long¡¦¡¦¡¦¡¦¡É¤È¤¤¤¦¥¨¥é¡¼¤¬½Ð¤¿¤é¡¤ÆüËܸ쥳¡¼¥É¤ÎÌäÂê¤Ê¤Î¤Ç
my.ini¤Î°Ê²¼¤ò¥³¥á¥ó¥È¥¢¥¦¥È¤¹¤ë¡¥
#sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
¤³¤ì¤Ç¤â¥À¥á¤Ê¾ì¹ç¤Ï¡¤ÁÇľ¤Ë°Ê²¼¤Î¥³¥Þ¥ó¥É¤Ç¡¤Ê¸»ú¥³¡¼¥É¤òÀßÄꤹ¤ë¡¥
mysql> set names sjis;
»²¹Íʸ¸¥ ¡§ GoogleÀèÀ¸¤Ë´¶¼Õm(__)m
http://perldoc.jp/docs/modules/DBD-mysql-2.1026/DBD/mysql/INSTALL.pod
http://inagi.himitsukichi.com/~aozora/cgi-bin/pukiwiki/pukiwiki.php?mysql%A4%F2%A5%B3%A5%F3%A5%D1%A5%A4%A5%EB
http://www.jaist.ac.jp/~kiyoshiy/memo/cygwin_programming.html
http://www.sixnine.net/cygwin/cygwin-doc/dlopen.html
http://www.mysql.gr.jp/mysqlml/mysql/msg/4260
Posted by masakichi : 00:58 | ¥³¥á¥ó¥È (52)