2013/02/06 글 목록

mysqldump: Got error: 145: Table './user/DB명' is marked as crashed and should be repaired when using LOCK TABLES

리눅스/Mysql 2013. 2. 6. 15:01

# mysqldump -u root -p [DB명] > [DB명]

# mysqldump: Got error: 145: Table './user/DB명' is marked as crashed and should be repaired when using LOCK TABLES

에러발생

# mysqldump -u root -p DBname --lock-table=0 > backup.sql

이런식으로 다시 백업

- 도중 DB 손상되었다고 에러뜨면

# 디비접속

# use [디비명];

#repair table [손상된테이블];

하고 다시진행

ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO (0)	2014.07.03
ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist (0)	2013.07.17
mysqldump: Got error: 145: Table './user/DB명' is marked as crashed and should be repaired when using LOCK TABLES (0)	2013.02.06
Mysql 'is marked as crashed and should be repaired' 에러 (그누보드 로그인안됨) (0)	2012.05.29
Mysql 에러 - Timeout error occurred trying to start MySQL Daemon. (1)	2011.11.29
mysql 사이트 메뉴얼 (0)	2011.05.17