PHP session ´íÎó¼°mysql close ´íÎó´¦Àí
ÔÚа²×°ºÃµÄmysql £¬apahce£¬php µÄʱºò£¬Èç¹ûÔÚ´úÂëÖÐʹÓÃÁËsessions_start() µÄʱºò»á³öÏÖÀàËÆÒÔϵĴíÎó£º
Warning: session_start() [function.session-start]: Cannot send session cooki µÈµÄ´íÎó¡£
Çë°²×°ÈçϵÄ˼·ȥÐÞÕý£º
1.ÔÚphp.ini ÖÐÅäÖÃ session.savepath='/tmp'
2.¿ªÆôsession.auto_start=1
3.°Ñ¸ü¸Ä/tmp Ŀ¼ÈÃËùÓÐÈ˶¼¿ÉÒÔдÈë¡£
4.ɾ³ý/tmp ÁôÏÂÀ´µÄÀúÊ·sess_* Îļþ
5.stop apache £¬ÔÙ´ÎÆô¶¯ apache
6.¾¹ýÒÔÉϵÄÐ޸쬻ù±¾ÉÏ¿ÉÒÔ½â¾öÎÊÌâ¡£
7.Èç¹û²»¿ÉÒÔ£¬¿ÉÒÔ°Ñapache µÄĬÈÏÓïÑÔÐÞ¸ÄÎªÒ³ÃæµÄ±àÂëÓïÑÔ¡£
Á¬½ÓÊý¾Ý¿âºóÌáʾÒÔÏ´íÎó£º
Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in
¿ÉÄÜÊÇÓÉÓÚÒ³ÃæÃ»ÓиտªÊ¼¼ÓÔØµÄʱºòûÓÐÑ¡ÔñÊý¾Ý¿â£¬µ«Ö´ÐÐÁ˸ö¯×÷£¬µ¼Ö³öÏָôíÎ󡣿ÉÒÔÓÃÒÔÏµķ½·¨ÐÞÕý£º
if(is_resource($conn))
mysql_close($conn);
Ïà¹ØÎĵµ£º
ÔÚ¿´ÏîÄ¿µÄÊÇ¿´µ½mysql°æ±¾µÄÏîÄ¿£¬·¢ÏÖÖ´ÐжàÌõsqlÓï¾äÊǶ¼ÊÇÏÈ·ÖÀëÒ»ÌõÌõµÄÊý¾Ý¿âÔÙÒ»ÌõÌõÖ´ÐУ¬ÎÒÏëÓ¦¸ÃÓа취һÌõÌõÖ´ÐеİÉ
ËùÒÔ½ñÌìÌØÒâµÄ²éÕÒÁËÒ»ÏÂ
ÔÚjdbcÏÂ˵¿ÉÒÔÉèÖÃÁ¬½Ó×Ö·û´®µÄʱºòÉèÖÃÒ»ÏÂ
ÉèÖóÉÈçÏ嵀 jdbc:mysql://192.168.3.180/sample?user=root&password=&allowMultiQueries=true
¾Í¿ÉÒÔÖ´Ð ......
´æ´¢¹ý³ÌÊÇÒ»ÖÖ´æ´¢ÔÚÊý¾Ý¿âÖеijÌÐò£¨¾ÍÏñÕý¹æÓïÑÔÀïµÄ×Ó³ÌÐòÒ»Ñù£©£¬×¼È·µÄÀ´Ëµ£¬MySQLÖ§³ÖµÄ“routines£¨Àý³Ì£©”ÓÐÁ½ÖÖ£ºÒ»ÊÇÎÒÃÇ˵µÄ´æ´¢¹ý³Ì£¬ ¶þÊÇÔÚÆäËûSQLÓï¾äÖпÉÒÔ·µ»ØÖµµÄº¯Êý£¨Ê¹ÓÃÆðÀ´ºÍMysqlÔ¤×°ÔØµÄº¯ÊýÒ ......
MySQLÐÔÄÜÓÅ»¯µÄ×î¼Ñ20+Ìõ¾Ñé
½ñÌ죬Êý¾Ý¿âµÄ²Ù×÷Ô½À´Ô½³ÉΪÕû¸öÓ¦ÓõÄÐÔÄÜÆ¿¾±ÁË£¬Õâµã¶ÔÓÚWebÓ¦ÓÃÓÈÆäÃ÷ÏÔ¡£¹ØÓÚÊý¾Ý¿âµÄÐÔÄÜ£¬Õâ²¢²»Ö»ÊÇDBA²ÅÐèÒªµ£ÐĵÄÊ£¬¶øÕâ¸üÊÇÎÒÃdzÌÐòÔ±ÐèҪȥ¹Ø×¢µÄÊÂÇé¡£µ±ÎÒÃÇÈ¥Éè¼ÆÊý¾Ý¿â±í½á¹¹£¬¶Ô²Ù×÷Êý¾Ý¿âʱ£¨ÓÈÆäÊDzé±íʱµÄSQLÓï¾ä£©£¬ÎÒÃǶ¼ÐèҪעÒâÊý¾Ý²Ù×÷µÄÐÔÄÜ¡£ÕâÀÎÒÃDz»» ......
¿ÉÒÔÊÊÓÃÈκÎsql , ×Ô¶¯Ê¶±ð×Ö¶ÎÃû£¬ gzipѹËõ , ´øÊä³öbuffer , Ö§³Ö·Ö¿â·Ö±í
ÐèÒª¸¨Öú´úÂëºÍMakefie , ÏÂÃæÊÇÖ÷³ÌÐò´úÂ룬
/**
* mysqlÊý¾Ý±ídump³ÌÐò
* @author : cheng limin
* @date : 2010-1-18
*
* ʹÓÃÑùÀý:
*./dump_mysql -c ../conf/dump.conf
* -t xml
* -s ......