MySQL·Î °£È¤°¡´Ù ÀÛ¾÷ µµÁß ºÐ¸íÈ÷ Å×À̺íÀÌ Á¸Àç Table 'Å×À̺í¸í' doesn't exist
MySQL·Î °£È¤°¡´Ù ÀÛ¾÷ µµÁß ºÐ¸íÈ÷ Å×À̺íÀÌ Á¸ÀçÇϴµ¥
Table 'Å×À̺í¸í' doesn't exist
¶ó´Â ¹®±¸°¡ ³ª¿Ã¶§°¡ Á¸ÀçÇÑ´Ù.
À©µµ¿ì¿¡¼´Â ´ëºÎºÐ ´ë¼Ò¹®ÀÚ ±¸ºÐ¾øÀÌ ¼³Ä¡°¡ µÇÁö¸¸,
°£È¤°¡´Ù°¡ ¸®´ª½º¿ë MySQLÀº ´ë¼Ò¹®ÀÚ ±¸ºÐÇÏ´Â Çü½ÄÀ¸·Î ¼³Ä¡°¡ µÇÀÖ´Â °æ¿ì°¡ ÀÖ´Ù .
show variables like 'lower_case_table_names';
´ÙÀ½°ú °°Àº ¸í·ÉÀ» ½ÇÇàÇÏ°í È®ÀÎ ÇÏ¿´À» °æ¿ì
lower_case_table_namesÀÇ °ªÀÌ 0ÀÎÁö 1ÀÎÁö 2ÀÎÁö¸¦ È®ÀÎÇØ¾ß ÇÑ´Ù.
º»ÀÎÀÇ Å×½ºÆ® ¼¹ö´Â 0ÀÌ¾î¼ ¿À·ù°¡ ³µ¾ú´ø °ÍÀÌ´Ù.
º¸Åë 2´Âº»ÀûÀÌ ¾ø¾î¼ ¸ð¸£°Ú°í 0 ¶Ç´Â 1ÀΰÍÀ» º¸¾Ò¾ú´Ù.
0ÀÏ °æ¿ì : ´ë¼Ò¹®ÀÚ ±¸ºÐÇÔ
1ÀÏ °æ¿ì : ´ë¼Ò¹®ÀÚ ±¸ºÐ¾ÈÇÔ
º»ÀÎÀº ´ë¼Ò¹®ÀÚ ±¸ºÐÀ» ÇÏÁö ¾Ê±âÀ§ÇÏ¿© lower_case_table_namesÀÇ °ªÀ» 1·Î ¼³Á¤À» ÇØÁÖ°íÀÚ ÇÑ´Ù.
MySQLÀÇ my.cnf ÆÄÀÏÀ» °Çµå·Á ÁÖ¾î¾ß Çϴµ¥
º¸ÅëÀº /etc/my.cnf¿¡ Á¸ÀçÇÑ´Ù.
vi·Î my.cnf ÆÄÀÏÀ» º¸µµ·Ï ÇÏÀÚ
Á¢¼ÓÇÏ´Ùº¸¸é [mysqld] << ÀÌ¿µ¿ªÀÌ ÀÖÀ»ÅÙµ¥
Ãâó: https://roqkffhwk.tistory.com/91 [¾ß±Ù½È¾îÇÏ´Â °³¹ßÀÚ]