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һ¸öµ¥Ò»µÄÊý¾Ý¿â½øÐвî·Ö ÎÒûŪ¹ý ²»»á
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÄ¿Ç°ÔÚ±¾µØµÄlinuxÉÏдÁËÒ»¸öswingµÄ½çÃ棬Ïëͨ¹ýÕâ¸ö½çÃæÀ´¿ØÖÆÆäËüµçÄÔµÄlinuxÖØÆô¡£ ÎÒÖªµÀÓÃRuntime.getRuntime().exec("shutdown -r");¿ÉÒÔ¿ØÖƱ¾»úLinuxÖØÆô£¬µ«ÊÇÔõô¿ØÖÆÔ¶³ÌµÄlinuxÖØÆôÄØ£¿ ......
ÔÚÈýÊ®½²Óöµ½ÕâÑùÒ»¸öÎÊÌâ¾ÍÊÇÔËÐдúÂëʱ³öÏÖ´íÎó Fatal error: Call to undefined method mysql::fetch_array() in D:\WWW\news\index.php on line 12 £¬ÎÒ°Ñmysql::fetch_array() ¸Ä³Émysql::fetch_row() ÓÖ³öÏÖF ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆ̨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......