Çë½Ì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»ÖªµÀÔõô»¹Ôµ½Ð°²×°µÄÊý¾Ý¿âÖУ¬Ôε¹
ÊÇÔÚmysqlÃüÁîÐÐÏÂÊäÂð£¿ÌáʾNO database selected
datadir¡¡ÖеÄÖµÊÇʲô£¿
È«ÊÇ*.MYI¡¢*.MYD¡¢*.frmÎļþ
ÖÕÓÚÕÒµ½ÔÒòÁË
5.1ºóа汾£¬Êý¾Ý¿â²»ÊÇÔÚ°²×°Ä¿Â¼ÏÂÃæ£¬¶øÊÇÔÚC:\Documents and Set
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ
public static final DataBase.MAXSIZE=102 ......
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......
ÈçÉÏ ±íÖÐ usertime×ֶμǼÓû§µÇ¼µÄʱ¼ä
ÄÇÎÒÏë²é³ö±íÖÐSQL code:
+----------+---------------------+------+
| username | usertime | type |
+----------+---------------------+------+
......