09:13:09 SELECT * FROM auctionpro.wp_options LIMIT 0, 5000 Error Code: 144. Table ‘./auctionpro/wp_options’ is marked as crashed and last (automatic?) repair failed 0.000 sec

해결
1.mysql 중지
1 2 3 |
sudo systemctl stop mysql |
2. 폴더로 이동후 복구명령어
1 2 3 4 5 6 7 |
cd /var/lib/mysql/$DATABASE_NAME myisamchk -r $TABLE_NAME 또는 myisamchk -r -v -f $TABLE_NAME |
1 2 3 4 5 6 7 8 9 |
root@:/var/lib/mysql/pro# myisamchk -r wp_options - recovering (with sort) MyISAM-table 'wp_options' Data records: 1184 - Fixing index 1 - Fixing index 2 - Fixing index 3 Data records: 1134 |
3.mysql 시작
1 2 3 |
sudo systemctl start mysql |