XFileSharing Pro - Table './admin_xfs/Sessions' is marked as crashed how to fix

Message
Author
alexjer12
Posts: 3
Joined: Jan 04, 2013 5:41 am

Table './admin_xfs/Sessions' is marked as crashed how to fix

#1 Postby alexjer12 » Feb 10, 2013 11:30 am

When I try to login It gives this error message
Software error:

Can't exec:
Table './admin_xfs/Sessions' is marked as crashed and should be repaired at Modules/DataBase.pm line 55.


How to fix it.Please help me.Thanks

admin
Site Admin
Posts: 1839
Joined: Mar 22, 2006 12:32 pm

#2 Postby admin » Feb 10, 2013 11:45 am

What is your domain name?

Jesse202
Posts: 246
Joined: May 07, 2010 6:24 pm

#3 Postby Jesse202 » Feb 11, 2013 2:40 pm

ssh:
mysqlcheck -r database name

Stefanzm
Posts: 85
Joined: Apr 08, 2012 3:41 pm

#4 Postby Stefanzm » Feb 12, 2013 8:43 am

If jesse202 command doesnt work , change it like this:

mysqlcheck -u(xfs db user) -p(xfs db password) --all-databases -r


Do not put space between -u and the user or -p and the password .

The final command should look like this:

mysqlcheck -uuser -ppassword --all-databases -r
or
mysqlcheck -uuser -ppassword -r --all-databases

Not sure on the correct syntax . But one of both should work perfectly .

Guizmo
Posts: 19
Joined: May 27, 2012 3:41 am

#5 Postby Guizmo » Feb 12, 2013 2:39 pm

Stefanzm wrote:If jesse202 command doesnt work , change it like this:

mysqlcheck -u(xfs db user) -p(xfs db password) --all-databases -r


Do not put space between -u and the user or -p and the password .

The final command should look like this:

mysqlcheck -uuser -ppassword --all-databases -r
or
mysqlcheck -uuser -ppassword -r --all-databases

Not sure on the correct syntax . But one of both should work perfectly .
You have to put a space between -u and user but not between -p and password ;)

So it'll be : mysqlcheck -u user -ppassword -r --all-databases

cf : http://dev.mysql.com/doc/refman/5.0/fr/ ... check.html