2015-07-25, 05:20 AM
Ok so, when I try to access my site it says that datacache is broken
I tried to go into phpmyadmin and repair it but it wouldn't let me repair it.
So I tried to do in the phpmyadmin query runner but that didn't work either (and the syntax was correct)
I had to do like an actual backup on my server aka adding the .myd files and etc to var/lib/mysql instead of doing a .mysql backup.
So the datacache table is broken and its basically unfixable in phpmyadmin.
The page also takes like 10 minutes to load.. when it does it says the mysql server was interrupted or something while loading datacache table.
SQL Error:
145 - Table './zadmin_sxk2ao20skmw/x82sj29wk_datacache' is marked as crashed and should be repaired
Query:
SELECT title,cache FROM x82sj29wk_datacache
I tried to go into phpmyadmin and repair it but it wouldn't let me repair it.
So I tried to do in the phpmyadmin query runner but that didn't work either (and the syntax was correct)
I had to do like an actual backup on my server aka adding the .myd files and etc to var/lib/mysql instead of doing a .mysql backup.
So the datacache table is broken and its basically unfixable in phpmyadmin.
The page also takes like 10 minutes to load.. when it does it says the mysql server was interrupted or something while loading datacache table.
SQL Error:
145 - Table './zadmin_sxk2ao20skmw/x82sj29wk_datacache' is marked as crashed and should be repaired
Query:
SELECT title,cache FROM x82sj29wk_datacache