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µÄ
Ïà¹ØÎÊ´ð£º
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ÒýÓÃ
now()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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.
¿ ......
¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿
1 nike 100 ϵͳʱ¼ä
2 nike 300 &n ......
ÐèÒªÔÚMySQLÀïÃæÐ´¸ö´¢´æ¹ý³Ì,
·ÃÎÊoracleµÄÊý¾Ý.
Ŀǰ²»ÄÜ
oracle¿ÉÒԾͿÉÒÔÁ¬½Ómysql£¬Í¨¹ýodbc+dblinkÀ´Á¬½Ó
ûÓа취¡£Ä¿Ç°µÄMYSQLµÄ°æ±¾ÖÐÉв»Ö§³ÖÁ¬½Óµ½ÆäËüÊý¾Ý¿â£¬
ÕæÍ¦ÓÐÏë·¨µÄ ĿǰÎÒû×ö¹ý
......