mysqldump 㨠repair with keycache - ã„ã¡ã„ã®æ—¥è¨˜ã§ã‹ã„テーブルをdumpã—ã¦importã—ãªãŠã™ã¨ãã«ã€alter enable keys㧠"repair with keycache" ã«æ‚©ã¾ã•ã‚Œã¦ãŸã‚“ã§ã™ãŒã€MySQL Forums見ã¦ãŸã‚‰ãã®ã‚‚ã®ã‚ºãƒãƒªãªã®ã‚’見ã¤ã‘ãŸã®ã§ãƒ¡ãƒ¢ã€‚ http://forums.mysql.com/read.php?35,155467,166902 ã”å˜çŸ¥ã®æ–¹ã«ã¯å½“ãŸã‚Šã¾ãˆãªæ„Ÿã˜ã§ã™ãŒã€è‡ªåˆ†ã¯ãã‚‚ãã‚‚ repair by sorting 㨠repair with keycache ã®2通りã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒå‡ºã—分ã‘られã¦ã„ã‚‹ã“ã¨è‡ªä½“ã«æ°—ã¥ã„ã¦ã¾ã›ã‚“ã§ã—ãŸã€‚ mysqldump mysqldumpã‚’ã¤ã‹ã£ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’(ãã®ã¾ã¾importã«ä½¿ãˆã‚‹)SQLæ–‡ã«åã出ã—ã¾ã™ã€‚ % mysqldump -uuser -ppass -hhost hoge > hoge.sql ã“ã®ã¨ãhoge.sqlã®ä¸èº«ã¯ã“ã‚“
{{#tags}}- {{label}}
{{/tags}}