Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql µ¼ÖÂËÀ»ú

»·¾³£ºwin2003 apache2 resin3 php5 mysql5
mysql´íÎóÀï³öÏÖÕâ¸ö£¬·þÎñÆ÷Ö±½ÓËÀµ½ÄÇÀï¡£
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090928  8:57:56  InnoDB: Database was not shut down normally!

²»ÖªµÀÎÊÌâÔÚÄÇ£¿
ibdata filesÓëib_logfiles²»Æ¥Å䣬ֱ½ÓCOPYµÄ£¿

·þÎñÆ÷ËÀÁË£¬ÖØÆôºó¾Í³öÕâ¸öÌáʾ¡£²»ÊÇÖ±½ÓcopyµÄ¡£
Êý¾Ý¿âÊÇͨ¹ýsqlÎļþµ¼ÈëµÄ£¬Ã»Óе¼ÈëÊý¾ÝÎļþ¡£

°ÑÄãµÄibdata1, ib_logfile* ÒƵ½ÆäËüĿ¼ȥ£¬È»ºóÔÙÊÔһϡ£

ÄãÊÇ˵µÄdataĿ¼£¿

ÔÚ ±¾µØ¼ÆËã»ú ÎÞ·¨Æô¶¯mysql·þÎñ ´íÎó1067£º½ø³ÌÒâÍâÖÐÖ¹

¶Ô´íÎó1067µÄ½â¾ö°ì·¨£¬²éÕÒÈçÏ£º

1¡¢ÐÞ¸Ä%windir%\my.ini£¬Ôö¼Ó
[mysqld]
#ÉèÖÃbasedirÖ¸ÏòmysqlµÄ°²×°Â·¾¶
basedir=D:\Program\Tools\mysql
datadir=D:\Program\Tools\mysql\data

windowsÌáʾµÄ´íÎó1067²¢Ã»ÓÐÌ«¶à¿É²Î¿¼¼ÛÖµ¡£¶Ô½â¾ömysqlµÄÆô¶¯ÎÊÌâ°ïÖú²»´ó¡£

¸ãÁËÐí¾Ã£¬Ò»¸öÆô¶¯ÎÊÌ⻹ûÓи㶨¡£×îÖØÒªµÄת»ú³öÏÖÔÚ·¢ÏÖE:\MySQL\data\Ŀ¼ÏµÄhostname.errÎļþ¡£ÕâÀïÃæÏêϸдÃ÷ÎÞ·¨Æô¶¯µÄÔ­Òò£º

[ERROR] Default storage engine (InnoDB) is not available

Õâ¸ö¾ÍÊÇΪʲôÎÒµÄmysqlÎÞ·¨Æô¶¯µÄÖ±½ÓÔ­Òò£¬½â¾ö°ì·¨£º

1¡¢´ò¿ªmy.ini»òmy.cnfÎļþ£¬ÕÒµ½default-storage-engine=InnoDBÕâÒ»ÐУ¬°ÑËü¸Ä³Édefault-storage-engine=MyISAM¡£

2¡¢ÁíÍâÒ»¸ö½â¾ö°ì·¨£º

ÔÚwindows2003°²×°MySQLºó£¬Èç¹û·¢ÏÖserviceÆð²»À´
1¡£¼ì²éwindowsµÄ


Ïà¹ØÎÊ´ð£º

jsp±¸·ÝmysqlÖ»ÓпÕÎļþ

ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

ÎÒÒª°Ñ×¢²áÐÅÏ¢Ìá½»µ½mysqlÖУ¬ÒªÔõô°ìÄØ£¿

ÎÒÔÚ×¢²áÒ³ÃæдÈëÁËÈçÏ´úÂ룺
<?php
    $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔÇ°°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

Çë½ÌÒ»¸ömysql triggerµÄÎÊÌâ

ÇëÎÊÔÚmysqlµÄupdate triggerÖУ¬ÈçºÎ»ñÈ¡µ±Ç°Ö´ÐеÄsqlÓïÖеÄwhereÌõ¼þ£¬Ð»Ð»
ÎÊÌâ±È½ÏÆæ¹Ö£¬ÎªÊ²Ã´ÒªÕâÑù£¿

ÔÚtriggerÖлñÈ¡µ½Óï¾äÒª×öʲôÄØ


ÎÒµÄÕâ¸öupdate trigger¸üеÄÊÇmemcache£¬¶øÎÒ»¹Òª´Ómemcac ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ