Webmaster2020.com

Hi,

I have the error message:
table is marked as crashed and should be repaired

So how do I do that ?

The simple answer :
if you want more information:
https://dev.mysql.com/doc/refman/8.0/en ... table.html
or
http://dev.mysql.com/doc/refman/5.0/en/ ... epair.html

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?

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:

Thanks, changing the tmpdir worked.