Page 1 of 1
SOLVED: mysql table is marked as crashed and should be repaired
Posted: Tue Aug 28, 2018 3:58 pm
by mister_v
Hi,
I have the error message:
table is marked as crashed and should be repaired
So how do I do that ?
Re: mysql table is marked as crashed and should be repaired
Posted: Tue Aug 28, 2018 4:03 pm
by chris
Re: mysql table is marked as crashed and should be repaired
Posted: Thu Sep 06, 2018 6:31 pm
by mister_v
Thanks that worked.
But now I have another problem.
The repair process crashed.
Probably because of diskspace.
But I have enough free, just /tmp is full.
I assume it uses /tmp, how can I change this?
Re: mysql table is marked as crashed and should be repaired
Posted: Thu Sep 06, 2018 6:40 pm
by chris
Default MySQL repair uses
/tmp as temporary dir.
In many system /tmp is now mounted as tmpfs in ram memory,
and is limited in size.
You can change it
/etc/mysql/my.cnf
change the
tmpdir variable to another dir:
and restart MySQL:
Re: SOLVED: mysql table is marked as crashed and should be repaired
Posted: Fri Sep 07, 2018 7:26 am
by mister_v
Thanks, changing the tmpdir worked.