¸¶½ºÅÍÆ÷À¯(Master4U)
Monday, 17 of January
 

·Î±×ÀÎ Category
Table 'zetyx_group_table' is read only
°ü¸®ÀÚ  2018-03-19 00:19:27 Hit:2457
¸µÅ© #1: https://blackfrost.blog.me/220158330204


Table 'zetyx_group_table' is read only

https://blackfrost.blog.me/220158330204
table 'table_name' is read only


http://b1ix.net À¸·Î ºí·Î±×¸¦ ÀÌÀü Çß½À´Ï´Ù.

Å×ÀÌºí¿¡ select À̿ܿ¡ insert³ª update¸¦ ÇÏ·Á°íÇϴµ¥, table 'table_name' is read only¶ó´Â ¿¡·¯°¡ ¶á´Ù¸é,

ÇØ´ç Å×À̺íÀÌ Á¸ÀçÇÏ´Â À§Ä¡¿¡ °¡¼­ Àб⠱ÇÇÑÀ» »ìÆì º¸¸é µÈ´Ù.



º¸Åë ÇØ´ç Å×À̺íÀº /var/lib/mysql/ÇØ´çdb/ À§Ä¡¿¡ ÀÖÀ» °ÍÀÌ´Ù.



cd /var/lib/mysql/ÇØ´çdb/ ·Î µé¾î°¡¼­ º¸¸é,



-rw-r--r-- 1 mysql  mysql  1477599896  3¿ù  4  2014 table_name.MYD

-rw-r--r-- 1 mysql  mysql    39196672  3¿ù  4  2014 table_name.MYI

-rw-r--r-- 1 mysql  mysql       15389  3¿ù  4  2014 table_name.frm



¾Æ¸¶ Å×ÀÌºí ±ÇÇÑÀÌ À§¿Í °°ÀÌ 644·Î µÇ¾î ÀÖÀ» °¡´É¼ºÀÌ ³ô´Ù. ±×·³ ÇØ´ç ±ÇÇÑÀ»

chmod 660 table_name.MYD ¸í·É¾î·Î 3°³ ´Ù ¹Ù²ã ÁØ´Ù.

ÇÏÁö¸¸ chmod·Î ¹Ù²Ü¶§ÀÇ Á¢¼Ó ¾ÆÀ̵ð·Î ¼ÒÀ¯ÀÚµµ º¯°æ µÇ¾î¼­,



-rw-rw---- 1 root  root  1477599896  3¿ù  4  2014 table_name.MYD

-rw-rw---- 1 root  root    39196672  3¿ù  4  2014 table_name.MYI

-rw-rw---- 1 root  root       15389  3¿ù  4  2014 table_name.frm




ó·³ µÇ¾î ÀÖÀ» °ÍÀÌ´Ù.

±×·¡¼­ chown mysql:mysql table_name.MYD ¸í·É¾î·Î 3°³ÀÇ ÆÄÀÏÀ» ÀüºÎ ¹Ù²ãÁØ µÚ¿¡



mysqlÀ» Àç½ÃÀÛ ÇØº¸¸é µÈ´Ù.

[Ãâó] [MYSQL] table 'table_name' is read only ¿¡·¯¿¡ °üÇÑ »çÇ×|ÀÛ¼ºÀÚ b1ix


º»¹®Àμ⺻¹®¸ÞÀϹ߼Û
¡â a
¡ä ±×´©º¸µå : ºñȸ¿øÀ϶§ ±Û¾²±â ¹öư ³ª¿À°Ô ÇÏ´Â ¹æ¹ý
Copyright 1999-2025 Zeroboard / skin by ChanBi