MySQL MYI 로 DB복구법

Code/DB

MySQL MYI 로 DB복구법

sidcode 2009. 2. 19. 20:23

1. MySql Off

/usr/local/mysql/bin/mysqladmin -u root -p shutdown

2. 복구할 백업 MYI

/usr/local/mysql/bin/myisamchk -r 테이블명 /MYI경로/테이블명.MYI

3. MySql On

/usr/local/mysql/bin/mysqld_safe &