글
MySQL 5.0 에서 에러 상황 극복?
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
어쨋든 다시 올리면 아래와 같은 냄새나는 메시지를 뿜으면서 전혀 응답을 하지 않는다.
* Checking for corrupt, not cleanly closed and upgrade needing tables.
체크하면서 lock 을 거는것 같은데 자세한 건 모르겠고... 아무리 기다려도 웹에서 응답할 생각을 안하길래... 어떻게 해결했는고 하니...
그냥 루트로 권한 변경해서 mysql 데이터가 저장되는 장소에서 isam 체크를 한번씩 돌려보았다. -0-
root@daphne:/var/lib/mysql# myisamchk */*.MYI
...
Checking MyISAM file: mysql/columns_priv.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
Checking MyISAM file: mysql/db.MYI
Data records: 9 Deleted blocks: 1
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
---------
Checking MyISAM file: mysql/func.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
Checking MyISAM file: mysql/help_category.MYI
Data records: 36 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
---------
Checking MyISAM file: mysql/help_keyword.MYI
Data records: 401 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
---------
Checking MyISAM file: mysql/help_relation.MYI
Data records: 825 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
Checking MyISAM file: mysql/help_topic.MYI
Data records: 475 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check record links
---------
Checking MyISAM file: mysql/host.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
Checking MyISAM file: mysql/proc.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links
---------
Checking MyISAM file: mysql/procs_priv.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
---------
Checking MyISAM file: mysql/tables_priv.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
---------
Checking MyISAM file: mysql/time_zone.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
Checking MyISAM file: mysql/time_zone_leap_second.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
Checking MyISAM file: mysql/time_zone_name.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
Checking MyISAM file: mysql/time_zone_transition.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
Checking MyISAM file: mysql/time_zone_transition_type.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
Checking MyISAM file: mysql/user.MYI
Data records: 16 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links
---------
...
(현업에서 이렇게 처리하면 난리나겟지만.. ㅋㅋㅋ)
