Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÄ


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

MySQLÊý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


public static final DataBase.MAXSIZE=102 ......

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

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

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ