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

linuxϵͳmysqlÈçºÎ½øÐвîÒ챸·Ý

ÈçÌ⣬Çë´ó¼ÒÖ¸½ÌÏ£¬·Ç³£¸Ðл
²¹³äһϠ Ò²¾ÍÊÇÀàËÆwindowsÏ sqlµÄÔöÁ¿±¸·Ý


1.ÔËÐÐmysqlµÄʱºò¼ÓÉÏ --log-update=/tmp/mysql.update.log
2.¸ø²î·ÖÎļþ´´½¨±àºÅ mysqladmin flush-logs
3.»Ö¸´°´±àºÅ´ÓСµ½´óµÄ˳Ðò mysql -D mydatabase < /tmp/mysql.update.log.001

¶àл¥Éϵģ¬¾Ù¸öÀý×Ó£¬ÎÒÏÖÔÚÓиötestµÄÊý¾Ý¿â£¬ÒªÔõô²Ù×÷


ÒýÓÃ
1.ÔËÐÐmysqlµÄʱºò¼ÓÉÏ --log-update=/tmp/mysql.update.log
2.¸ø²î·ÖÎļþ´´½¨±àºÅ mysqladmin flush-logs
3.»Ö¸´°´±àºÅ´ÓСµ½´óµÄ˳Ðò mysql -D mydatabase < /tmp/mysql.update.log.001

д´íÁË
2.½«±àºÅ·­×ª mysqladmin flush-logs

ÒªÖ¸¶¨²î·Öij¸öÊý¾Ý¿â²»»á 

Äܲ»ÄܸøÐ´¸öʵÀý°¡ (¡ïÐÜèµ³¾üίÖ÷ϯ¡ï)

Æäʵ--log-update Êǽ«²Ù×÷¸üÐÂmysqlÊý¾Ý¿âµÄÖ¸Áî´æµ½ÎĵµÖÐ
»Ö¸´ÊǸù¾ÝÕâ¸öÖ¸ÁîÀ´µÄ
ÄãÒªÕæµÄijһ¸öµ¥Ò»µÄÊý¾Ý¿â½øÐвî·Ö ÎÒûŪ¹ý ²»»á


Ïà¹ØÎÊ´ð£º

linux»·¾³ÏÂgethostbynameº¯ÊýÎÊÌâ - C/C++ / CÓïÑÔ

дÁ˸ö²âÊÔ³ÌÐòÈçÏÂ
   
  struct hostent *hp; 
char AlarmDevIP[20];  
  int x2;

hp = gethostbyname("www.google.com");
if (hp)
{ ......

php±àдִÐÐlinux shellÃüÁîµÄ´úÂë

ʹÓÃPHPµÄexecº¯Êýµ÷ÓÃlinuxµÄshellÃüÁÈçdateÈ¥ÐÞ¸Äʱ¼ä»òshutdownȥʵÏֹػú/ÖØÆô£¬µ«ÊÇ·µ»ØÖµ¶¼ÊÇʧ°ÜµÄ¡£¾­¹ý¶à´ÎÊÔÑ飬È϶¨ÊÇûÓÐȨÏÞµÄÎÊÌâ¡£
ËùÒÔ£¬Ð¡µÜÔÚ´ËÇë½Ì¸÷룬ÈçºÎ²ÅÄÜÉèÖÃȨÏÞ£¬µ÷ÓÃlinux shellà ......

Linux Socket HTTPÇëÇóµÄÎÊÌ⣬¸ßÊÖ½ø£¡

СµÜ×î½üÐèÒªÒ»¸öÓÃsocket»ñÈ¡htmlÎĵµµÄ´úÂ룬µ«ÊÇÀÏÊDz»ÄÜ»ñÈ¡ÍêÕûµÄhtmlÔ´Âë¡£Ô­Òò²»Ã÷£¬Íû¸ßÊÖÖ¸µã£¡
C/C++ code:

char *Http_GET(char *host,int port,char *data) //·¢ËÍGETÇëÇó
{
char response[2 ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

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

½¨±í£º²å¼Ç¼
SQL code:

create table tablename (id int,RQ1 datetime,RQ2 datetime)
-- select * from tablename
insert into tablename
select 1,'2009-01-01 10:00:00','2009-01-02 11:00:00' union
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ