ÕÒmysql·þÎñͻȻµ±µôÔÒò
linuxÉϵÄmysql·þÎñÔÚ½Ú¼ÙÈÕͻȻµ±µô
ÏÖÔÚÕÒÔÒò£¬»³ÒÉÊÇ´ÅÅ̿ռ䲻¹»£¬ÏÖÔÚÐèÒªÕÒµ½È·ÔäµÄÖ¤¾Ý¡£
£±¡¡¾ßÌåÔÚÄĸöÎļþÏ¿ÉÒÔÕÒµ½£¬Ëûµ±µôµÄ¾ßÌåʱ¼äºÍÔÒò£¿
£²¡¡windowsÏÂcÅÌ¿ÉÒÔ±¨´ÅÅ̿ռ䲻¹»µÄÔÒò£¬²»ÖªµÀlinuxûÓÐÀàËÆwindowsµÄcÅÌ£¨¾ßÌåÊÇÄĸöĿ¼£©¿Õ¼ä²»×㣿
dataĿ¼ÏµÄerrÈÕÖ¾
linux ÏÂûÓÐÕÒµ½errÈÕÖ¾
ûÓÐERRÈÕÖ¾£¬ÔòÔÚMYSQLÕâ¸ö²ã´ÎÉÏûʲô°ì·¨ÁË¡£
½¨ÒéÂ¥Ö÷µ½ LINUX °æÈ¥ÎÊһϣ¬²Ù×÷ϵͳ²ãÉÏÓÐʲô¼Ç¼¿ÉÒԲ쿴¡£
ÕÒµ½ err
090626 20:26:58 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000010' (relay_log_pos 318)
090626 20:26:58 [ERROR] Could not find target log during relay log initialization
090626 20:26:58 [ERROR]
¿´ÏÂlinuxµÄ´íÎóÈÕÖ¾ÊÇ·ñÓз¢ÏÖ°É:
tail -f /var/log/messages
¸Ðл´ó¼Ò mysqlÀí½âÓÖÉîÁËЩ
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
Èç¹ûmysqlÔÚ¹¤×÷µÄʱºò³öÏÖÒì³££¬µ¼ÖÂphp³ÌÐòûÓзµ»ØÖµ£¬php»áÈçºÎ´¦Àí£¿ »¹ÊÇÒªÊÖ¶¯Ð´ÈÝ´í´¦Àí
ÅжÏmysqlº¯ÊýµÄ·µ»ØÖµ php×Ô¼ºµ±È»²»»áÈÝ´íÁË ÄãÐèÒª×Ô¼ºÐ´
µ±È»ÒªÊÖ¶¯À´Ð´
×Ô¼ºÐ´°¡
ÄǾÍÒª¶ÔÄã ......
ÏÖÓÐÈçÏÂÒ»´æ´¢¹ý³Ì£º
SQL code:
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_Test`(
in $W_id int
)
BEGIN
DECLARE $type int DEFAULT 0;
DECLARE $preID int;
DECLARE $nextID int;
DECLA ......
jspÁ¬½ÓmysqlÊý¾Ý¿â²éѯ£¬²¢ÔÚÒ³ÃæÏÔʾ Öм䲻ÓÃstruts£¬ÔõôʵÏÖ£¬ÇóÀý×Ó
javabean ×öÁ¬½Ó
jsp Ò³ÃæÊµÀý»¯Àà
jsp Ò³ÃæÏÔʾÊý¾Ý
<%@ page contentType="text/html;
charset=gb2312" ......
ÔÚphpÖÐÓÃÕâ¾ä¾Í¿ÉʵÏÖ¶Ô¿Í»§¶Ë×Ö·û¼¯µÄÉèÖÃ....
mysql_query("set names gb2312")
ÇëÎÊÔÚjspÖÐÈçºÎʵÏÖÕâ¾ä¹¦ÄÜ£¿£¿£¿
jspÖУº
<%@page language="java" contentType=&q ......