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

2¸ömysqlÎÊÌâÇë½Ì

1 MYSQL 5.0µÄ´íÎóÈÕ־ĬÈϱ£´æÔÚÊý¾ÝĿ¼ÏµÄhostname.errÎļþÖУ¬ÓÃÃüÁîÔõôÐ޸ĴíÎóÈÕÖ¾´æ·ÅµÄλÖ㬾ßÌåÃüÁîÊÇʲô£¬ÁíÍâ¿ÉÒÔͨ¹ýÎļþÐÞ¸ÄÂð£¬ÔÚÄÄÀïÐ޸ģ¬ÎÒÔÚmy.iniÀïºÃÏóûÓÐÕÒµ½¡£
2 MYSQL 5.4µÄ´íÎóÈÕÖ¾±£´æµ½Ê²Ã´µØ·½È¥ÁË£¬ÎÒÔõôûÓÐÕÒµ½.
лл´ó¼ÒÁË¡£
ÒýÓÃ1 MYSQL 5.0µÄ´íÎóÈÕ־ĬÈϱ£´æÔÚÊý¾ÝĿ¼ÏµÄhostname.errÎļþÖУ¬ÓÃÃüÁîÔõôÐ޸ĴíÎóÈÕÖ¾´æ·ÅµÄλÖ㬾ßÌåÃüÁîÊÇʲô£¬ÁíÍâ¿ÉÒÔͨ¹ýÎļþÐÞ¸ÄÂð£¬ÔÚÄÄÀïÐ޸ģ¬ÎÒÔÚmy.iniÀïºÃÏóûÓÐÕÒµ½¡£

error log ÊÇÔÚ datadir ϵģ¬Ã»Óа취Ð޸쬳ý·ÇÄãÁ¬datadir Ò»Æð¸Äµô¡£
ÎļþÃûÄãµ½ÊÇ¿ÉÒÔÓà log-error ²ÎÊýÀ´Ö¸¶¨¡£

ÒýÓÃ2 MYSQL 5.4µÄ´íÎóÈÕÖ¾±£´æµ½Ê²Ã´µØ·½È¥ÁË£¬ÎÒÔõôûÓÐÕÒµ½.

ÏàͬλÖ㬼ì²éÒ»ÏÂÄãÊÇ·ñ´ò¿ªÁËerror log ¹¦ÄÜ¡£

SQL code:
mysql> show variables like 'log_error';
+---------------+------------------------
| Variable_name | Value
+---------------+------------------------
| log_error | C:\Program Files\MySQL\
+---------------+------------------------
1 row in set (0.00 sec)

mysql>


ÎļþÃûÄãµ½ÊÇ¿ÉÒÔÓà log-error ²ÎÊýÀ´Ö¸¶¨¡£
---------------------------------------
ÔõôÓà log-error ²ÎÊýÀ´Ö¸¶¨Ñ½£¬ÎÒÓÃset log_error = "f:\mysql.err"; Ìáʾ˵log_errorÊÇÖ»¶Á±äÁ¿£¬²»ÄÜÐ޸ģ¬Ð»Ð»¡£


ÒýÓÃÔõôÓà log-error ²ÎÊýÀ´Ö


Ïà¹ØÎÊ´ð£º

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

MYSQLÊÂÎñ»Ø¹öµÄÎÊÌâ

SQL code:

CREATE PROCEDURE A()
BEGIN
DECLARE 'Constraint Violation'
CONDITION FOR sqlexception;
DECLARE EXIT HANDLER FOR
'Constraint Violation' ROLLBACK;
BEGIN TRAN ......

MYSQL character_set_server Ôõô¸Ä

ÎÒ¿ª·¢ASP.netʱ 
²åÈëÍâÎÄÂÒÂë 
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8 
character_set_connection utf8 
character_set_database utf8 
ch ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ