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

Ïëд¸ömysqlµÄÅú´¦ÀíÎļþ°ï¿´¿´Ôõôд

±ÈÈçÏÂÃæµÄ´úÂë
d:
mysql -u zhongda -p
show slave status\G;
±£´æ³É.batµÄÎļþ
ÔËÐкó Ò»ÊäÈëÃÜÂë¾Í²»Ö´ÐÐ
show slave status\G;
ÎÒÏëÊäÍêÃÜÂëºó¼ÌÐøÖ´ÐÐ
show slave status\G;

ÒªÔõôд

cmd주
D:\>mysql -u zhongda -p -e "show slave status\G" > e:\test.bak

Â¥ÉϵĿÉÒÔ˵Çå³þµãÂð ÎÒû½Ó´¥¹ýÅú´¦ÀíÎļþ

BatchFile code:
d:
mysql -u zhongda -pÃÜÂë -e "show slave status\G;"


ÕâôִÐоͿÉÒÔÁË¡£

Ö§³Ö¡£

ÒýÓÃ
BatchFile coded:
mysql -u zhongda -pÃÜÂë -e"show slave status\G;"

ÕâôִÐоͿÉÒÔÁË¡£


ÒýÓÃ
cmd주
D:\>mysql -u zhongda -p -e "show slave status\G" > e:\test.bak

Ô­À´ÄãÊÇÏë×ö³ÉbakµÄÎļþµ÷ÓÃÃüÁÄÇÖ±½Ó°ÑÉÏÃæÕâ¸öÓï¾ä¿½±´µ½Ò»¸öbakÎļþÀïÃæ¾Í¿ÉÒÔÀ²£¨µ±È»£¬ÉÏÃæµÄÓï¾ä»á°Ñshow slave statusµÄ½á¹û´æ½øÈ¥e:\test.bakÎļþ£¬Èç¹ûÏëÖ±½ÓÔÚÆÁÄ»ÏÔʾ½á¹û£¬Ôò°ÑÉÏÃæÓï¾äµÄºóÃæ²¿·Ö¡°> e:\test.bak¡±È¥µô¾Í¿ÉÒÔÁË
±¾À´bakÀïÃæ¾Í¿ÉÒÔÖ´ÐÐcmdϵÄÃüÁîÂï



ÔÎ Ôõô»á½á²»ÁËÌù Ò»½áÌù¾Í±»Ìß³öÀ´ÁË


Ïà¹ØÎÊ´ð£º

mysqlµÄÇý¶¯³ÌÐò

ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......

cÓïÑÔÈçºÎÁ¬½ÓMYSQL£¿

´ó¼ÒºÃ:
ÎÒÊǸãCµÄ, ÏÖÔÚÏëÓÃC Á¬½ÓMYSQL,µ«ÊÇÔõôҲÁ¬½Ó²»ÁË,ÎҵĴúÂëÈçÏÂ:
#include <stdio.h>
#include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h"
......

mysqlÄ£ºý²éѯÈçºÎ²éѯÁ½¸ö¹Ø¼ü×Ö

ÎÒÓõÄlikeÄ£ºý²éѯ£¬±ÈÈçmysqlµÄnameÖÐÓС°csdnÂÛ̳ϵͳ¡±Õ⼸¸ö×Ö£¬ÈçºÎÔÚ <input>Öвéѯ¡°csdn ϵͳ¡±Ò²ÄܳöÀ´Õâ¸ö¡°csdnÂÛ̳ϵͳ¡±£¬ÎÒÏÖÔÚÊDz顰csdn¡±»òÕß¡°ÏµÍ³¡±¶¼¿ÉÒÔ¡£Ð»Ð»¸÷λÁË£¡²»ÖªµÀÎÒÕâô±í´ï ......

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

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

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

Äã¾ÍÕâ½ÓÔÚҳà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ