debugsqlMinor
mysql.proc keeps crashing, cannot do a mysqldump?
Viewed 0 times
cannotcrashingkeepsmysqldumpmysqlproc
Problem
Due to some problems with InnoDB, I'm going to dump all databases to a new server:
The dump process stopped with error:
I've ran the following command to repair all tables in all databases:
When I examine the
However, I still get the same error when re-running the
I have approximately 2000 store procedures. Can that be the reason for the error?
mysqldump -E -R --all-databases | pv -b | mysql -u root -p -h new.serverThe dump process stopped with error:
59.9kB assword: 59.9kB
ERROR 145 (HY000) at line 2970: Table './mysql/proc' is marked as crashed and should
be repaired
228MB
mysqldump: Got errno 32 on writeI've ran the following command to repair all tables in all databases:
mysqlcheck --auto-repair --all-databasesWhen I examine the
mysql.proc status, I get:mysql> check table mysql.proc;
+------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+------------+-------+----------+----------+
| mysql.proc | check | status | OK |
+------------+-------+----------+----------+
1 row in set (0.02 sec)However, I still get the same error when re-running the
mysqldump command.I have approximately 2000 store procedures. Can that be the reason for the error?
Solution
I just had the same problem, this was fixed by issuing a command, assuming mysql data dir is on /var/lib/mysql/mysql
myisamchk -q -r /var/lib/mysql/mysql/proc
Source : http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html
myisamchk -q -r /var/lib/mysql/mysql/proc
Source : http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html
Context
StackExchange Database Administrators Q#25229, answer score: 8
Revisions (0)
No revisions yet.