¼Ç¼MYSQLµÄÊý¾ÝÐÞ¸Ä
ÇëÎÊ¿ÉÒÔÀ¹½ØMYSQLµÄÊý¾ÝÐ޸IJ»£¿ ÎÒÏÖÔÚÓÐÒ»¸öPHP+MYSQLϵͳ ÎÒÏÖÔÚÏë¿´¿´Ìí¼ÓÒ»¸ö»áÔ±»á¶ÔmysqlÊý¾Ý±í½øÐÐÄÄЩÐ޸Ļò²åÈë ÇëÎÊÎÒ¿ÉÒÔÔÚÌí¼Ó»áÔ±µÄʱºò mysql¼Ç¼Ï¶ÔÄÄЩ±í½øÐÐÁËÐ޸ĻòÕß²åÈë²»£¿ ·ÖÎöPHPÔ´ÎļþºÜÂé·³ ÓÐЩ»¹zend¼ÓÁËÃܵÄ55
´ò¿ªÈÕÖ¾¼´¿É¼Ç¼SQLÓï¾ä [mysqld] log=123.log ÎÒÔÚ[mysql]ÏÂÃæ¼ÓÁËÕâ¸ö£º #LOG log=mylog.log È»ºóÖØÆôÁËmysql show variables like 'log'; È»¶ølog»¹ÊÇOFF ÊDz»ÊÇÄÄÀïû¿ªÆô³É¹¦£¿ ÄãµÄmysql °æ±¾ÊǶàÉÙ£¿ÒýÓà ÎÒÔÚ[mysql]ÏÂÃæ¼ÓÁËÕâ¸ö£º #LOG log=mylog.log È»ºóÖØÆôÁËmysql show variables like 'log'; È»¶ølog»¹ÊÇOFF ÊDz»ÊÇÄÄÀïû¿ªÆô³É¹¦£¿ select version() select version(); 5.0.22-community-nt; »¹ÓÐÔÙÈõÈõµÄÎÊÏ Ôõô¸´ÖÆcmdÀïµÄÄÚÈÝ£¿ OKÁË ÔÀ´ÎÒ·Å´íÁË Òª·ÅÔÚmysqldÏÂ..55 ÈçºÎ²é¿´ÈÕ־Ĩ£¿±ÈÈç²é¿´ÎÒµÄmylog.log ÎÒÔõôÔÚwinÉÏËÑË÷²»µ½Õâ¸öÎļþ£¿ ÔÚÄãµÄdatadir Ŀ¼ÖÐ ¼Ç¼±¾´ò¿ª ¹þ¹þ ÓÐÓÃÁË Ð»Ð»acmain_chm ллWWWWA лл´ó¼Ò ºÇºÇ£¬À´ÍíÁË
Ïà¹ØÎÊ´ð£º
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......
ÈçÌ⣬MySQL²»»áÕâÑù°É Ö§³Ö£¬Ä㽨Á¢Êý¾Ý¿âµÄʱºòÖ¸¶¨×Ö·û¼¯utf8»òÕßgbk¾ÍÐÐÁË¡£ http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx MySQL ÖÐÎÄÏÔʾÂÒÂë Ö§³Ö£¬¼ì²é×Ö·û¼¯ÉèÖà ֧³Ö£¬¼ì² ......
ÎÒ¿ª·¢ASP.netʱ ²åÈëÍâÎÄÂÒÂë SHOW VARIABLES LIKE 'character%'; Õâ¸öʱºò character_set_client utf8 character_set_connection utf8 character_set_database utf8 ch ......
ÇëÎÊÏÂÄÄλÈÊÐÖÓбȽϺõı¸·Ý·½°¸£¬ÓÃʲô¹¤¾ß»òÕßÓÃʲô·½Ê½£¬Ð¡µÜ½è¼øÏ ֱ½ÓÓÃMYSQLDUMP±¸·Ý OR ÓÃSQLYOGÖ®ÀàµÄͼÐλ¯¹ÜÀí¹¤¾ß±¸·Ý Ö±½ÓÓÃmysql×Ô´øµÄ mysqldump ¾Í¿ÉÒÔÁË¡£ http://dev.mysql.com/doc/re ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......