Çë½ÌmysqlÊý¾Ý¿â»¹ÔµÄÎÊÌâ
Ö®Ç°Ð¶ÔØÁËmysql£¬ÖØÐ°²×°ÁËÏ£¬È»ºó֮ǰ°æ±¾µÄmysqlϵÄdataĿ¼ÖÐÊý¾Ý¿âÎļþ¸ñʽΪ£º.MYD ¡¢.MYIÖ®ÀàµÄ¶«Î÷ µ½°Ù¶ÈËÑÁËÏ£¬Ëµ°ÑÕâЩ¿½±´µ½ÐµÄmysql°²×°Ä¿Â¼ÏµÄdataĿ¼Öм´¿Éʶ±ð£¬µ«ÊǺÃÏñ»¹ÊÇʶ±ð²»Á˰¡£¿Ó¦¸ÃÔõô»¹ÔÕâЩ¸ñʽµÄÊý¾Ý¿âÄØ£¿
µ«ÊǺÃÏñ»¹ÊÇʶ±ð²»Á˰¡£º Ìáʾʲô´íÎóÐÅÏ¢ ºÃÏñҲûɶ´íÎóÌáʾ£¬¾ÍÊÇÓÃphpmyadmin¿´²»µ½Êý¾Ý¿â¡£¡£ È»ºó³ÌÐòÎÞ·¨Á¬½ÓÊý¾Ý¿â Ä㽨Á¢Êý¾Ý¿âûÓУ¿ÓÐÎÞÏàӦĿ¼£¿ Óеģ¬ÎÒÔÚɾ³ý֮ǰ£¬Êý¾Ý¿âÊÇÔÚD:\mysql\data\webdataĿ¼Ï ɾ³ýÖØÐ°²×°ºó£¬½«Ö®Ç°±¸·ÝµÄwebdataÄ¿Â¼ÖØÐ¿¼µ½Ðµİ²×°Ä¿Â¼µÄdataÏÂÃæÁË£¬µ«ÊÇÒÀ¾ÉÎÞ·¨Ê¶±ð¡£ Õâ¸öºÍ±àÂëÓйØÏµÂð?ÎÒÏÖÔÚÓõÄÊÇutf-8±àÂ룬֮ǰÓõÄʲô±àÂëÍü¼ÇÁË Ä㽨Á¢webdataÊý¾Ý¿â£¿ show tables; ¿´Ò»ÏÂÕâЩ±íÔÚ²»ÔÚ£¿ Èç¹ûÔÚ£¬Ôò˵Ã÷±íÎļþ *.frm, *.myd, *.myi ÖÁÉÙλÖÃÕýÈ·ÁË¡£È»ºóÔÙ¿´ webdataÊý¾Ý¿âÊÇÒÔÎļþ¼ÐµÄÐÎʽ´æÔÚÔÚdataĿ¼Ïµģ¬ÕâÀïÃæÓкܶàMYIÖ®ÀàÀ©Õ¹ÃûµÄÊý¾Ý¿âÎļþ£¬ÏÖÔÚµÄÎÊÌâ¾ÍÊDz»ÖªµÀÔõô»¹Ôµ½Ð°²×°µÄÊý¾Ý¿âÖУ¬Ôε¹ÒýÓà show tables; ¿´Ò»ÏÂÕâЩ±íÔÚ²»ÔÚ£¿ Èç¹ûÔÚ£¬Ôò˵Ã÷±íÎļþ *.frm, *.myd, *.myi ÖÁÉÙλÖÃÕýÈ·ÁË¡£È»ºóÔÙ¿´ ÊÇÔÚmysqlÃüÁîÐÐÏÂÊäÂð£¿ÌáʾNO database selected datadir¡¡ÖеÄÖµÊÇʲô£¿ÒýÓà datadir¡¡ÖеÄÖµÊÇʲô£¿ È«ÊÇ*.MYI¡¢*.MYD¡¢*.frmÎļþ ÖÕÓÚÕÒµ½ÔÒòÁË 5.1ºóа汾£¬Êý¾Ý¿â²»ÊÇÔÚ°²×°Ä¿Â¼ÏÂÃæ£¬¶øÊÇÔÚC:\Documents and Set
Ïà¹ØÎÊ´ð£º
ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬ ×îºÃÓÐÔ´´úÂ룬лл Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º ½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......
ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺 <?php $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error()); & ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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. ¿ ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from ( SELECT tg.tguildname,c.cid, ( cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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. ¿ÉÊÇÎÒÕÒ ......