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ÎļþϵÄÊý¾Ý¿â±í,ÆäËûÁ½ÖÖ¸ñʽ¶¼Éú³É³öÀ´ÁË.È»ºóÔÚÒÆÖ², ¾Í²»»á´æÔÚÎÄÕ¿ªÊ¼ËµµÄÊý¾Ý¿â±í²»´æÔڵĴíÎó.
Ïà¹ØÎĵµ£º
http://hi.baidu.com/fish124423/blog/item/c6f9f310190dd779ca80c456.html½â¾öerror trying access httpd. conf file.you will need to manually configure theµÄÅäÖÃÎÊÌâ
Apache+mysql+phpÔÚwindowsϵÄÅäÖÃ(³É¹¦)
2008-12-16 14:49
ApcheÏÂÔØµØµã£ºhttp://www.apache/org
Or http://www.51cto.com/html/ ......
1 ÄÚ´æ±íµÄ±í»ú¹¹»¹ÊÇÔÚÊý¾Ý¿âÖеģ¬Ö»ÊÇÊý¾Ýʱ·ÅÔÚÄÚ´æÖеġ£
2 ÄÚ´æ±íÖв»¿ÉÒÔʹÓÃTEXTºÍBLOBÀàÐ͵Ä×ֶΡ£
3 ÄÚ´æ±í¿ÉÒÔͨ¹ýmax_heap_table_size = 2048MÀ´¼Ó´óʹÓõÄÄÚ´æ¡£
1 ÁÙʱ±íµÄ±í»ú¹¹ºÍÊý¾Ý¶¼ÊÇ·ÅÔÚÄÚ´æÖеÄ
¾ßÌå¼ûÏ£º
ÄÚ´æ±íʹÓùþϣɢÁÐË÷Òý°ÑÊý¾Ý±£´æÔÚÄÚ´æÖУ¬Òò´Ë¾ßÓм«¿ìµÄËÙ¶È£¬Êʺϻº´æÖÐСÐÍÊý¾Ý¿ ......
ÕâÀïÊÇʹÓÃODBCÀ´×ª»»Êý¾Ý¿âµÄ¡£
1.°²×°mysqlÊý¾Ý¿âµÄODBCÇý¶¯£¬mysql¹ÙÍøÓÐÏÂÔØhttp://dev.mysql.com/downloads/connector/odbc/
2.´ò¿ª¿ØÖÆÃæ°å\¹ÜÀí¹¤¾ß\Êý¾ÝÔ´ODBC£¬ÔÚÓû§DSNÖÐÌí¼ÓÒ»¸öMySQL ODBC Êý¾ÝÔ´¡£
3.½Ó×ÅÔÚÏÂÃæµÄ´°ÌåÖÐÊäÈëÊý¾ÝÔ´Ãû³Æ£¬Èçmysqlodbc£»È»ºóÊäÈë·þÎñÆ÷ServerµØÖ·£¨localhost»òÆäËû£©£¬Óû§Us ......
MySQLÖØÐ°²×°µÄʱºò³öÏÖÁËÎÊÌ⣺Could not start the service MySQL. Error:0,ÔÒòÊÇûÓжԾɵÄMySQLÍêÈ«Ð¶ÔØµô¡£
ÔÚÄã´ÓµçÄÔÀïÐ¶ÔØ¾ÉµÄMYSQLÊý¾Ý¿â·þÎñʱ£¬Ê×ÏÈÏÈÔÚWINDOWS·þÎñÀïÍ£µôMYSQLµÄ·þÎñ¡£ÔÙµ½¿ØÖÆÃæ°åÀïµÄÔö¼Óɾ³ý³ÌÐòÄÚ½øÐÐɾ³ý£¬È»ºóÊÖ¶¯É¾³ýÔ°²×°Îļþ,µ«ÊÇÄã²¢²»ÄÜÍêÕûµÄ°ÑMYSQL·þÎñɾ ......