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

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ÎļþϵÄÊý¾Ý¿â±í,ÆäËûÁ½ÖÖ¸ñʽ¶¼Éú³É³öÀ´ÁË.È»ºóÔÚÒÆÖ², ¾Í²»»á´æÔÚÎÄÕ¿ªÊ¼ËµµÄÊý¾Ý¿â±í²»´æÔڵĴíÎó.
                                                                                                                  


Ïà¹ØÎĵµ£º

Mysql°²×°°æÓëÃâ°²×°°æµÄÇл»Ê¹ÓÃ

Èç¹ûͬÒâϵͳÖÐͬʱ´æÔÚinstall mysqlºÍno—install mysql£¬ÄÇôÔõÑù½øÐÐÁ½¸ö°æ±¾µÄÇл»Ê¹ÓÃÄØ£¿ÓÖ»áÓöµ½Ê²Ã´ÑùµÄÎÊÌâÄØ£¿
Ê×ÏÈ£¬install mysqlµÄmysql·þÎñÊÇĬÈÏÆô¶¯µÄ£¬ÔÚÈÎÎñ¹ÜÀíÆ÷½ø³ÌÖпÉÒÔ¿´µ½¼¸ÌõsqlµÄ×ÖÑÛ£¬Èçmysqld.exe,sqlbrowser¡£ÕâÊÇinstall mysqlµÄ·þÎñ¡£ÄÇôͨ¹ý¿ì½Ý·½Ê½»ònavicat¾ÍÄÜÆô¶¯Ê¹ÓÃinstall ......

MySQL ±àÂë»úÖÆ

Ò»°ãÔÚMYSQLʹÓÃÖÐÎIJéѯ
¶¼ÊÇÓà set NAMES character
character_set_client £¬ÕâÊÇÓû§¸æËßMySQL²éѯÊÇÓõÄʲô×Ö·û¼¯¡£
character_set_connection £¬MySQL½ÓÊܵ½Óû§²éѯºó£¬°´ÕÕcharacter_set_client½«Æäת»¯Îªcharacter_set_connectionÉ趨µÄ×Ö·û¼¯¡£
character_set_results £¬ MySQL½«´æ´¢µÄÊý¾Ýת»»³Écharact ......

MySQLµ¼Èë´óÊý¾Ý¿âÎļþµÄ·½·¨

×òÌ죬¹«Ë¾´Ó·þÎñÆ÷ÉϸãÏÂÀ´Ò»¸ö´óµÄÊý¾Ý¿â£¬Îļþ´óСΪ487MB£¬ÓÐͬÊÂ˵½«php.iniµÄÎļþÅäÖÃÖеÄpost_max_size¸ÄΪ±ÈÄãÒªµ¼ÈëµÄÊý¾Ý¿âÎļþ´óһЩµÄ£¬±ÈÈçÏÖÔÚÎÒÒªµÄµ¼ÈëµÄÊý¾Ý¿âÎļþÊÇ487MB£¬ÄÇô¿ÉÒÔ½«´ËÏî¸ü¸ÄΪ£º700MB£¬ÔÙʹÓÃphpMyAdmin¹¤¾ßµÄµ¼È빦ÄÜÀ´ÊµÏÖ£¬µ«ÊÇ£¬ÎÒÊÔÓÃÁË´ËÖÖ·½·¨²»ÄÜ×àЧ£¬È»ºóÓëÓо­ÑéµÄÅóÓѽ»Á÷£ ......

WinodwsÏÂIIS/Apache+PHP+MySQLµÄ°²×°ÅäÖÃ

ÎÒд¹ýµÄ½Ì³Ì²»¶à£¬¶øÇҴ󲿷ֶ¼ÊÇÀ´Ô´ÓÚ±ðÈ˵Ľ̳̣¬²»¹ý£¬ÕâÀïËù½éÉܵ쬶¼ÊÇÈÚÈëÎÒËù×ܽáµÄ¾­Ñ飮£­£­ÒýÑÔ
¡¡¡¡
¡¡¡¡PHPµÄÖ´ÐÐЧÂÊÊÇÓÐÄ¿¹²¶ÃµÄ£¬ÕâÒ²ÊÇÎÒϲ»¶ËüµÄÔ­ÒòÖ®Ò»£¬ºÍËü³ÆÎª¾øÃî´îµµµÄMysqlÒÔ¼°ApacheÏëÈںϣ¬²»Äܲ»¾ªÌ¾ÆäЧÂÊÁË¡£PHP¸üÐÂÒ²ºÜ¿ì£¬ÕâÀïÁоÙÁËĿǰ×îа汾PHP4.3.2RC4£¨¼¸ºõûÓÐBUGÁË£¬¹À¼ÆÐ´Í ......

MySQL²»ÄÜÆô¶¯·þÎñ1067´íÎó

MySQLÖØÐ°²×°µÄʱºò³öÏÖÁËÎÊÌ⣺Could not start the service MySQL. Error:0,Ô­ÒòÊÇûÓжԾɵÄMySQLÍêÈ«Ð¶ÔØµô¡£
    ÔÚÄã´ÓµçÄÔÀïÐ¶ÔØ¾ÉµÄMYSQLÊý¾Ý¿â·þÎñʱ£¬Ê×ÏÈÏÈÔÚWINDOWS·þÎñÀïÍ£µôMYSQLµÄ·þÎñ¡£ÔÙµ½¿ØÖÆÃæ°åÀïµÄÔö¼Óɾ³ý³ÌÐòÄÚ½øÐÐɾ³ý£¬È»ºóÊÖ¶¯É¾³ýÔ­°²×°Îļþ,µ«ÊÇÄã²¢²»ÄÜÍêÕûµÄ°ÑMYSQL·þÎñɾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ