XFileSharing Pro - cannot backup dabase need help!!

Message
Author
technoind
Posts: 38
Joined: Aug 05, 2009 7:04 am

cannot backup dabase need help!!

#1 Postby technoind » Dec 05, 2009 8:15 am

I am trying for a week now to back up my database via ssh with no success. my IP2Files table is crashed, using

Code: Select all

mysql> repair table IP2Files;
to repair it with no result.

Every time i use command to backup sql i get the following error:

Code: Select all

mysqldump: Error 1194: Table 'IP2Files' is marked as crashed and should be repaired when dumping table `IP2Files` at row: 9813
Please help :(

User avatar
PilgrimX182
Posts: 2186
Joined: Mar 22, 2006 1:39 pm

#2 Postby PilgrimX182 » Dec 07, 2009 9:30 am

If repair doesn't help, you can erase it completely, not a big deal:

Code: Select all

mysql>truncate IP2Files;