is database corrupt ?
for some strange reason cant get into the board because of this error :
Invalid SQL:
SELECT COUNT(*) AS count
FROM post
WHERE dateline > '1111354169'
mysql error: Can't open file: 'post.MYI'. (errno: 144)
mysql error number: 1016
so first to do was to repair it - first tried by way of repair in admincp - still no luck whatsoever so went though phpmyadmin and after trying repair for about 5 times the same errors still come up.
new.post repair info Wrong bytesec: 0- 0- 0 at 20232512; Skipped
new.post repair error 5 when fixing table
new.post repair error Can't copy datafile-header to tempfile, error 9
new.post repair status Operation failed
new.post_parsed repair status OK
every other table says OK except ones above - where do i go from here or is it start afresh ???
just got this by running repair in admincp
post Check Warning: Table is marked as crashed and last repair failed
post Check Warning: 1 client is using or hasn't closed the table properly
post Check Warning: Size of indexfile is: 2538496 Should be: 1872896
post Check Warning: Size of datafile is: 28518948 Should be: 28516600
post Check Error: Can't read indexpage from filepos: -1
post Check Error: Corrupt
|