ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] myisam »P innoDB

[µo°Ý] myisam »P innoDB

½Ð°Ý¤@¤U §ÚAppservªºª©¥» ¬O 2.6.0ª©ªº
¤@¶}©l¸ê®Æªíªº«¬ºA¬Omyisam
¦ý¬O§Ú²{¦b·Q§ï¦¨InnoDB(¯S©w¤@­Ó¸ê®Æªí·Q§ï)
·Q»¡¥h­×§ï ¦ý¬O¦b§ï«¬ºA¤¤ ¨S¦³innodbªº¿ï¶µ
¦Ó¥B§Ú¿é¤Jtype = XXXXX¤§Ãþªº«ü¥O
³£·|¥X²{  #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 ...........
³o­Ó¿ù»~
½Ð°Ý³o­Óª¬ªp¸Ó«ç»ò³B²z..
¦]¬°±MÃD·|¥Î¨ì
©Ò¥H¨Ó³o´£°Ý
½Ð°ª¤â¬°§Ú¸Ñµª><

¸É¥R:
ÁÙ¦³ §Ú·Q¸Õ°µ°Q½×°Ï
¬Ýªº¬O¥»½×¾Âªº³o½g¤å³¹ http://forum.twbts.com/redirect. ... amp;goto=nextnewset
¥Ø«eÃöÁp©Ê¤w¸g¥i¥H¨Ï¥Î¤F(³o½gªº²Ä2­¶ ¦³«Ø¥ßªºµ{¦¡½X ¨C­Ó«Ø¥ßªºµ{¦¡½X³Ì«á¤@¦æ type ³£·|¥X²{¤W­±1064ªº°ÝÃD)
¦A¨Ó´N¬O²Ä4­¶
ÃöÁpÀ˵øµe­± §Úµo²{ ¥u¦³¤º³¡³sµ² ¦Ó¨S¦³«á­±ªºINNODBªº¨º¨Ç¿ï¶µ
¤~µo²{¨S¿ìªk§ï§ÎºA
¦pªG¯uªº¨S¿ìªk§ï
¥ÎMYISAM¥i¥H°µ°Q½×°Ï¹À? ´N¥Î±Ð¾Çªº¤è¦¡¤@¼Ë¤U¥h¹À??

TOP

Appservªº 2.6.0ª©¥»¤º§tªºMySQLª©¥»(MySQL 6.0.4-alpha)¦³¬Û·í¤jªº»yªkÅÜ­²
«Øij¥Î¦^AppServ 2.5.10(MySQL 5.0.51b)

TOP

¦^´_ 3# gucci
¦pªG ¤£¤è«K ¨Ï¥Îª©ªºappserv ¬O§_Áٯ৹¦¨©O?
§Ú¦³µ{¦¡½X ¨Ï¥Îª©ªº
phpmyadmin¾ã­Ó·|±YÃa ¤£¯à°õ¦æ ³s¶}³£¤£¯à¶}
¥Î·sª©ªº´N¨S¨Æ¤F
©Ò¥H§Ú¤~¥Î·sª©ªº

TOP

¦^´_ 4# e0626e


    ±q©x¤è¯¸¬Ý¨ì 2.5.10 »P 2.6.0 ªº mysql ¤À§O¬O 5.0.51b »P 6.0.4-alpha¡C
¥¦­Ìªº password() ¨ç¼Æ¤w¤£¤ä´©Âª© old_password() ©Ò¥[±Kªº±K½X¡C
¦Ó³s½uªº client (PHP mysql extension) link ªºª©¥»¦³¥i¯à¤w¸g¤Ó¡A©Ò¥H±K½X®Ú¥»¹ï¤£°_¨Ó¡C
¸Ñ¨Mªk½Ð°Ñ¦Ò¡G(´N¬O¤â°Ê­«³]±K½X)
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html
http://blog.kurrunk.com/archives/197

TOP

¦^´_ 2# e0626e


    Appservªºª©¥» ¬O 2.6.0ª©ªº¦w¸Ë®É´N­n³]©w¤ä´©
¤ß¦w¡A¥­¦w   
µoªí¥ô¦óµL·N¸qªº·PÁ©ÎÄé¤ô¤å³¹¤@«ß¬å,¬Ã±¤±b¸¹,½Ð¸Ô¾\ª©³W!!

TOP

§Úª¾¹D«çﻤ£¥Î­«·s¦w¸Ë´N¥i¥H±Ò¥Î¤F
±Nmy.ini ¸Ì­±ªº skip innodb µ¹µù¸Ñ±¼
¦A±Nmysql ­«±Ò´N¦n¤F!!

TOP

·í§Ú¬Ý¨ì³o¥DÃD®É¥H¬°¬O±´°QMysql ¤¤ªº MyIsam »P InnoDB ¨â­ÓStorage Engines¤§®t²§¡Aµ²ªG¬O  AppServ (Apache¡BPHP¡BMySQL¡B phpMyAdmin)¡A¹ï©ó¥u¦w¸ËMySQL56¨ÓºN¯ÁDataBases¥H¶}µo¯S©wÀ³¥Î(¦pªÑ²¼¼Æ¾Ú)¡A¥B¤S¹ïdB§¹¥þ¥Í¤âªº§Ú¡A¦ü¥G¨«¦b¤@±ø©t¿W¤§¸ô¡C
MyIsam »P InnoDB ¨â­ÓStorage Engines¤§®t²§¡A¹ï©ó³æ¯Â¼Æ¾ÚÀ˯Á¤ÀªRªºÀ³¥Î¦Ó¨¥¡A¦ü¥G¤£¬O§Ú©Òª`·Nªº­«ÂI¡A¦b MySQL 5.5.5¤§«e MyISAM ¬O¹w³]ªº(default) storage engine¡A±qMySQL 5.5.5.°_¹w³]ªº  storage engine¬°InnoDB ¡C
¤@¤Á³£¦bºN¯Á¤¤¡A¥Ø«e§Ú¤ñ¸û¦n©_¥B¦³¿³½ìªº¬OTablesªºµ²ºc»PDatabase Designer Toolsªº¨Ï¥Î¡AdbForge Studio for MySQL¬Ý°_¨Ó¦n¹³¥i¥H¸Õ¸Õ¡C
«Ü©êºp¡A§Ú¬O¤p¾Ç¥Í¡A¤£¯à¤U¸üÀɮסA¬O­Ó¤p§¾«Ä¡I

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD