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

Çë½Ì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Ö»ÓпÕÎļþ

ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......

ÎÒÒª°Ñ×¢²áÐÅÏ¢Ìá½»µ½mysqlÖУ¬ÒªÔõô°ìÄØ£¿

ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
    $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......

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Óï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

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. ......

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.
¿ÉÊÇÎÒÕÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ