|
|
|
|
³»¿ëº¸±â |
|
|
|
Á¦¸ñ |
|
MySQL 5.x ¹öÀü¿¡ º¹±¸½Ã TYPE=MyISAM Error ÇØ°á ¹æ¹ý |
|
ºÐ·ù |
|
È£½ºÆà ¼ºñ½º |
|
Á¶È¸¼ö |
|
78888 |
|
|
´äº¯ |
|
±âÁ¸¿¡ MySQL 4.x ¹öÀü¿¡¼ ¹é¾÷ ¹ÞÀº sql ÆÄÀÏÀ» MySQL 5.x ¹öÀü¿¡ º¹±¸ ÇÒ·Á°í ÇÒ¶§ mysqldump¸¦ ¹ÞÀº sql·Î º¹±¸ ÇÒ¶§ ¾Æ·¡¿Í °°Àº ¿À·ù ¹ß»ý½Ã
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line
ÇØ°á ¹æ¹ýÀÔ´Ï´Ù.
MySQL 4.x´Â TYPE=MyISAM ÀÌ°í
MySQL 5.x´Â ENGINE=MyISAM ÀÔ´Ï´Ù.
ÇÏ¿© ¹é¾÷(mysqldump) sql ÆÄÀÏÀ» vi·Î ¿°Å³ª ÆíÁý ¿¡µðÅÍ·Î ¿¾î¼ ġȯÀ» ÇØ ÁÖ½Ã¸é µË´Ï´Ù. vi·Î ¿¾ú´Ù¸é
:1,$s/TYPE=MyISAM/ENGINE=MyISAM/g ġȯ¹æ¹ý
:wq ÀúÀå
ġȯ ÈÄ ÀúÀåÀ» ÇÏ½Ã¸é µË´Ï´Ù.
MySQL º¹±¸¸¦ ´Ù½Ã ÇÕ´Ï´Ù.
mysql -uDBuser -pPassword MyDB < MyDB.sql |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
»óÈ£¸í : ÇÑ°½Ã½ºÅÛ ÁÖ½Äȸ»ç | ´ëÇ¥ÀüÈ 070-7163-0277 | Æѽº 02-6008-2514
¼ÒÀçÁö : (07071) ¼¿ïƯº°½Ã µ¿ÀÛ±¸ º¸¶ó¸Å·Î5±æ 35 ÆÄÅ©½ºÄù¾î 7Ãþ
´ëÇ¥ÀÌ»ç ¹Úä±Ô | »ç¾÷ÀÚµî·Ï ¹øÈ£:120-81-57465 | Åë½ÅÆǸž÷ ½Å°í¹øÈ£:Á¦02-680-327È£
´ã´çÀÚ¸ÞÀÏ : / ħÇؽŰí : abuse@doregi.com (À̸ÞÀÏ ¹«´Ü¼öÁý °ÅºÎ) |
|
|
|
|
|
|