mysqlÒ»¸ö±íµÄ·ÖÇøÎļþ¶ªÊ§
²Ù×÷ϵͳÊÇlinux,
ÔÚ½øÐÐselect²éѯµÄʱºò±¨´í£ºCan't find file: 'myinfo' (errno: 2)
½á¹ûÔÚÊý¾Ý¿âĿ¼ÀïÒ»²é£¬myinfoµÄ·ÖÇøÎļþÈ«²»¼ûÁË£¬µ«ÊÇÏàÓ¦µÄmyinfo.frm myinfo.parÎļþ»¹ÔÚ¡£
Êý¾Ý¿âÄÚÆäËüµÄ±í»¹¶¼Õý³££¬Î¨¶À¸Ã±íµÄ·ÖÇøÎļþĪÃûÏûʧ£¡
¶øÇÒ£¬Êý¾Ý¿âĿ¼µÄ´óСû±ä£¬Ò²¾ÍÊÇ˵ÎļþÒ²Ðí»¹´æÔÚ£¬µ«¾ÍÊÇÕÒ²»µ½ÁË£¡
ÄãÓÃ
ALTER TABLE FF DROP PARTITION partition_names
¿´¿´ÄÜ·ñ³É¹¦£¬±íÖеÄÊý¾ÝÊÇ·ñ¶ªÊ§
²»ÐУ¬²úÉú´íÎó
ERROR 1017 (HY000): Can't find file: 'myfile' (errno: 2)
SELECT * from TT
ÄÜ·ñ³É¹¦
Ò²²»ÐУ¬»¹ÊDzúÉú´íÎó£º
ERROR 1017 (HY000): Can't find file: 'myfile' (errno: 2)
ÔÚÊý¾Ý¿âĿ¼Ï£¬´Ë±íµÄ*.MYDºÍ*.MYIÎļþ¶¼²»¼ûÁË£¡ÎÒ¾ø¶ÔûÓÐɾ³ý¹ýÕâЩÎļþ£¡
²é¿´INFORMATION_SCHEMA.PARTITIONS±í
¿ÉÒԲ鿴±í¾ßÓÐÄö·ÖÇø¡¢·ÖÇøµÄ·½·¨¡¢·ÖÇøÖÐÊý¾ÝµÄ¼Ç¼ÊýµÈÖØÒªÐÅÏ¢
MYDÊÇÊý¾ÝÎļþ£¬Ã»ÓÐÁË£¬Êý¾Ý»á¶ªÊ§£¬ÔÚLINUXÏÂÓ¦¸ÃÓдÅÅָ̻´Ö®ÀàµÄÈí¼þ°É£¿
myinfo ±íµÄÒýÇæÊÇʲô£¿ create table Óï¾äÊÇʲô£¿
ÒýÇæÊÇmyisam
Ïà¹ØÎÊ´ð£º
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......