mysqlÎóɾ
¸Õ¸ÕʹÓÃmysql£¬ÎóɾÁËtestÊý¾Ý¿â£¬»¹Ã»À´µÃ¼°±¸·Ý£»
ÔõÑù¿ÉÒÔ»Ö¸´£¿
ÓÃÊý¾Ý»Ö¸´ÎļþÊÔÊÔ
Èç¹ûÓжþ½øÖÆÈÕÖÆµÄ»°¿ÉÒԲο¼Õâ¸öÌù×ӵIJÙ×÷»Ö¸´ÄãµÄÊý¾Ý¡£
http://topic.csdn.net/u/20090608/20/e50feb34-0a07-4675-80d4-2eac35973286.html?58720
ʹÓÃmysqlbinlog»Ö¸´Êý¾Ý
²Î¿¼Ò»Ï¶þ樓°É£¬ÓÑÇé幫頂ÁË¡£
°ï¶¥
mysqlbinlog
SQL code:
[b]ÀûÓÃmysqlbinlog¹¤¾ß»Ö¸´MySQLÊý¾Ý¿â[/b]
Èç¹ûMySQL·þÎñÆ÷ÆôÓÃÁ˶þ½øÖÆÈÕÖ¾£¬Äã¿ÉÒÔʹÓÃmysqlbinlog¹¤¾ßÀ´»Ö¸´´ÓÖ¸¶¨µÄʱ¼äµã¿ªÊ¼ (ÀýÈ磬´ÓÄã×îºóÒ»´Î±¸·Ý)Ö±µ½ÏÖÔÚ»òÁíÒ»¸öÖ¸¶¨µÄʱ¼äµãµÄÊý¾Ý¡£¹ØÓÚÆôÓöþ½øÖÆÈÕÖ¾µÄÐÅÏ¢£¬²Î¼û5.11.3½Ú£¬¡°¶þ½øÖÆÈÕÖ¾¡±¡£¶ÔÓÚ mysqlbinlogµÄÏêϸÐÅÏ¢£¬²Î¼ûmysqlÊÖ²á8.6½Ú£¬¡°mysqlbinlog£ºÓÃÓÚ´¦Àí¶þ½øÖÆÈÕÖ¾ÎļþµÄʵÓù¤¾ß¡±¡£ ÒªÏë´Ó¶þ½øÖÆÈÕÖ¾»Ö¸´Êý¾Ý£¬ÄãÐèÒªÖªµÀµ±Ç°¶þ½øÖÆÈÕÖ¾ÎļþµÄ·¾¶ºÍÎļþÃû¡£Ò»°ã¿ÉÒÔ´ÓÑ¡ÏîÎļþ(¼´my.cnf or my.ini£¬È¡¾öÓÚÄãµÄϵͳ)ÖÐÕÒµ½Â·¾¶¡£Èç¹ûδ°üº¬ÔÚÑ¡ÏîÎļþÖУ¬µ±·þÎñÆ÷Æô¶¯Ê±£¬¿ÉÒÔÔÚÃüÁîÐÐÖÐÒÔÑ¡ÏîµÄÐÎʽ¸ø³ö¡£ÆôÓöþ½øÖÆÈÕÖ¾µÄÑ¡ÏîΪ-- log-bin¡£ÒªÏëÈ·¶¨µ±Ç°µÄ¶þ½øÖÆÈÕÖ¾ÎļþµÄÎļþÃû£¬
ÊäÈëÏÂÃæµÄMySQLÓï¾ä£º
SHOW BINLOG EVENTS G
Ä㻹¿ÉÒÔ´ÓÃüÁîÐÐÊäÈëÏÂÃæµÄÄÚÈÝ£º
mysql --user=root -pmy_pwd -e 'SHOW BINLOG EVENTS G'
½«ÃÜÂëmy_pwdÌæ»»Îª·þÎñÆ÷µÄrootÃÜÂë¡£
1. Ö¸¶¨»Ö¸´Ê±¼ä
¶ÔÓÚMySQL 4.1.4£¬¿ÉÒÔÔÚmysqlbinlogÓï¾äÖÐͨ¹ý--start-dateºÍ--stop-dateÑ¡ÏîÖ¸¶¨DATETIME¸ñʽµÄÆðֹʱ¼ä¡£¾ÙÀý˵Ã÷£¬¼ÙÉèÔÚ½ñÌìÉÏÎç10:00(½ñÌìÊ
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ
public static final DataBase.MAXSIZE=102 ......
ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
$conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......
żµÄÍøÕ¾Õâô˵```
The page cannot be displayed
There are too many people accessing the Web site at this time.
¿Éʵ¼ÊÉÏ×î¶àÖ»ÓÐ3~4¸öÈËÔÚͬʱµÇ¼°¢
ÇëÎÊÈçºÎ½â¾ö°¢?ÒòΪż°²×°mysqlµÄʱºòËÆ ......