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
|