Database Corrupt table

[jnet]

OK

I tried to optimize my DB in phpmyadmin and it says

 

Table './jnet_cient/tblticketreplies' is marked a...

jnet_client.tblticketreplies optimize Error Table 'tblticketreplies' is marked as crashed and ...

jnet_client.tblticketreplies optimize error Corrupt

 

I looked at the tblticketreplies table and I see the Collation says " in use" other tables collation is latin1_swedish_ci

what should I do now?

Edited February 25, 2010 by jnet

[jnet]

Ok I need help please it is this able

 

tblticketreplies

 

it is corrupted and repairing it does not work

 

tblticketreplies' is marked as crashed and last (automatic?) repair failed

 

 

Now I can not back my DB

[rmccny]

Repair the table using this query in phpMyAdmin:

 

REPAIR TABLE tblticketreplies;

If that fails, you will have to shut down MySQL and run as root:

 

myisamchk --recover

If you do not have root access, ask your host to do it. Otherwise your only real recourse is to restore your WHMCS database from last nights backup (I assume you're using WHMCS's nightly backup feature).

 

In either case, MAKE A BACKUP before doing any further repair actions. You should still be able to use mysqlhotcopy to make a backup; it should skip crashed tables.

[jnet]

Ok REPAIR TABLE tblticketreplies; failed again and again and it seems I lost all the replied I made to clients ticket

[jnet]

OK I solved the issue

 

Thanks but when I gzip the db and try to extract to SQL some thing still seems to be wrong

[rmccny]

The table repaired ok?

 

What seems to be wrong with your backup, can you elaborate?

[chostwales]

I have this exact issue still. Tried an upgrade to 4.2, but still nothing. I press download and it starts to download till it reaches 238kb. Try to unzip it, but it appears to be corrupt. Also the back ZIP files i get via email are also corrupt as well.