MySQL .frm .myd .myi Îļþ ¼°Êý¾Ý¿â±¾µØÒÆÖ²
½ñÌìÔÚʵ¼Ê¿ª·¢ÖжÔÓÚMySQLÊý¾Ý¿â½øÐÐÒÆÖ²·¢ÉúµÄÎÊÌâÀ´ËµÏÂ. ¿ªÊ¼°Ñ±¾µØdataÖеÄÊý¾Ý¿âÎļþ¿½±´µ½Áíһ̨»ú×ÓÉÏTest, Ö´ÐÐshow tables ; ¿ÉÒÔ¿´µ½Êý¾Ý¿â±í,µ«ÊÇ¶Ô±í½øÐÐÈκβÙ×÷¶¼±¨´í: ±í²»´æÔÚ , ÔÒÔΪMysqlµÄÊý¾Ý¿âÎļþ(.frm)Copy->stickµ½±¾µØ°²×°MySQLDBĿ¼µÄdataÎļþ¼ÐϾͿÉÒÔ.ÊÂʵ²»ÊÇÎÒÃÇÏëµÄÄÇÑù. ¶ÔÓÚMySQLÊý¾Ý¿âµÄÒÆÖ²,ÎÒÃÇÄÜ¿´µ½µÄÖ»ÊÇËüÉú³ÉµÄ±í½á¹¹ ÒÔ¾ÍÊÇ˵ÒÔ .frmΪºó׺ÃûµÄÎļþ.
ʵ¼ÊÉÏ, .frm .myd .myi¶¼ÊÇMysql´æ´¢Êý¾ÝµÄÎļþ, ´ú±íMySQLÊý¾Ý¿â±íµÄ½á¹¹/Êý¾ÝºÍË÷ÒýÎļþ ,ÎÒÃÇĬÈÏ´´½¨Êý¾Ý¿âºÍ±íʱֻÉú³ÉÊý¾Ý¿â±í½á¹¹µÄÎļþ.frm. ÒÆÖ²Êý¾Ý¿âʱ,±ØÐë´æÔÚÈýÖÖ¸ñʽµÄÊý¾Ý¿â±íÎļþ,²ÅÄÜÕý³£Ê¹ÓøÃDB, µ±ÎÒÃÇÔÚ±¾µØ´´½¨³öÊý¾Ý¿â»¹ÓиÃÊý¾Ý¿âÓòϵıíʱ, ÔÚdataÎļþ¼ÐÏÂÖ»´æÔÚÊý¾Ý¿âµÄ×Ö·û¼¯ÃèÊöÎļþºÍÊý¾Ý¿â±í½á¹¹Îļþ,ÈôÐèÒªÒÆÖ²Êý¾Ý¿â, Ó¦¸ÃÔÚ ¸ÃÊý¾Ý¿âÓòÏÂ, ÒѾÍÊÇ˵ use targetDatabase; ºóÖ´ÐÐÒÔÏÂÓï¾äÉú³ÉÆäËûÁ½ÖÖ¸ñʽµÄÊý¾Ý´æ´¢Îļþ,
alter table targetTableName ENGINE = MYISAM ROW_FORMAT = COMPACT;
¶Ôÿ¸ö±í¶¼Ö´ÐÐÒÔÉÏÓï¾äºó, ÔÚ¿´¿´dataÎļþϵÄÊý¾Ý¿â±í,ÆäËûÁ½ÖÖ¸ñʽ¶¼Éú³É³öÀ´ÁË.È»ºóÔÚÒÆÖ², ¾Í²»»á´æÔÚÎÄÕ¿ªÊ¼ËµµÄÊý¾Ý¿â±í²»´æÔڵĴíÎó.
Ïà¹ØÎĵµ£º
Èç¹ûͬÒâϵͳÖÐͬʱ´æÔÚinstall mysqlºÍno—install mysql£¬ÄÇôÔõÑù½øÐÐÁ½¸ö°æ±¾µÄÇл»Ê¹ÓÃÄØ£¿ÓÖ»áÓöµ½Ê²Ã´ÑùµÄÎÊÌâÄØ£¿
Ê×ÏÈ£¬install mysqlµÄmysql·þÎñÊÇĬÈÏÆô¶¯µÄ£¬ÔÚÈÎÎñ¹ÜÀíÆ÷½ø³ÌÖпÉÒÔ¿´µ½¼¸ÌõsqlµÄ×ÖÑÛ£¬Èçmysqld.exe,sqlbrowser¡£ÕâÊÇinstall mysqlµÄ·þÎñ¡£ÄÇôͨ¹ý¿ì½Ý·½Ê½»ònavicat¾ÍÄÜÆô¶¯Ê¹ÓÃinstall ......
Ò»°ãÔÚMYSQLʹÓÃÖÐÎIJéѯ
¶¼ÊÇÓà set NAMES character
character_set_client £¬ÕâÊÇÓû§¸æËßMySQL²éѯÊÇÓõÄʲô×Ö·û¼¯¡£
character_set_connection £¬MySQL½ÓÊܵ½Óû§²éѯºó£¬°´ÕÕcharacter_set_client½«Æäת»¯Îªcharacter_set_connectionÉ趨µÄ×Ö·û¼¯¡£
character_set_results £¬ MySQL½«´æ´¢µÄÊý¾Ýת»»³Écharact ......
×òÌ죬¹«Ë¾´Ó·þÎñÆ÷ÉϸãÏÂÀ´Ò»¸ö´óµÄÊý¾Ý¿â£¬Îļþ´óСΪ487MB£¬ÓÐͬÊÂ˵½«php.iniµÄÎļþÅäÖÃÖеÄpost_max_size¸ÄΪ±ÈÄãÒªµ¼ÈëµÄÊý¾Ý¿âÎļþ´óһЩµÄ£¬±ÈÈçÏÖÔÚÎÒÒªµÄµ¼ÈëµÄÊý¾Ý¿âÎļþÊÇ487MB£¬ÄÇô¿ÉÒÔ½«´ËÏî¸ü¸ÄΪ£º700MB£¬ÔÙʹÓÃphpMyAdmin¹¤¾ßµÄµ¼È빦ÄÜÀ´ÊµÏÖ£¬µ«ÊÇ£¬ÎÒÊÔÓÃÁË´ËÖÖ·½·¨²»ÄÜ×àЧ£¬È»ºóÓëÓоÑéµÄÅóÓѽ»Á÷£ ......
ÎÒд¹ýµÄ½Ì³Ì²»¶à£¬¶øÇҴ󲿷ֶ¼ÊÇÀ´Ô´ÓÚ±ðÈ˵Ľ̳̣¬²»¹ý£¬ÕâÀïËù½éÉܵ쬶¼ÊÇÈÚÈëÎÒËù×ܽáµÄ¾Ñ飮££ÒýÑÔ
¡¡¡¡
¡¡¡¡PHPµÄÖ´ÐÐЧÂÊÊÇÓÐÄ¿¹²¶ÃµÄ£¬ÕâÒ²ÊÇÎÒϲ»¶ËüµÄÔÒòÖ®Ò»£¬ºÍËü³ÆÎª¾øÃî´îµµµÄMysqlÒÔ¼°ApacheÏëÈںϣ¬²»Äܲ»¾ªÌ¾ÆäЧÂÊÁË¡£PHP¸üÐÂÒ²ºÜ¿ì£¬ÕâÀïÁоÙÁËĿǰ×îа汾PHP4.3.2RC4£¨¼¸ºõûÓÐBUGÁË£¬¹À¼ÆÐ´Í ......
MySQLÖØÐ°²×°µÄʱºò³öÏÖÁËÎÊÌ⣺Could not start the service MySQL. Error:0,ÔÒòÊÇûÓжԾɵÄMySQLÍêÈ«Ð¶ÔØµô¡£
ÔÚÄã´ÓµçÄÔÀïÐ¶ÔØ¾ÉµÄMYSQLÊý¾Ý¿â·þÎñʱ£¬Ê×ÏÈÏÈÔÚWINDOWS·þÎñÀïÍ£µôMYSQLµÄ·þÎñ¡£ÔÙµ½¿ØÖÆÃæ°åÀïµÄÔö¼Óɾ³ý³ÌÐòÄÚ½øÐÐɾ³ý£¬È»ºóÊÖ¶¯É¾³ýÔ°²×°Îļþ,µ«ÊÇÄã²¢²»ÄÜÍêÕûµÄ°ÑMYSQL·þÎñɾ ......