i got access to cpanel

I am looking at a demo for cPanel, though I don't use it. It might or might not work for you.

It looks like after you log into cPanel there is a screen that reminds me of the Control Panel in Windows (icons for Mail, Webmail, Change Password, etc.). Down in that list I see an icon called MySQL Databases. Click on that.

Next you come to a screen called MySQL Account Mainenance. If you scroll to the bottom you'll see a link to phpmyadmin. Click that.

That should take you to a phpmyadmin screen.

There, on the left, you should see a list or a dropdown list of databases. Hopefully you know the name of you XOOPS database, but let's pretend it's myXoops. You should see something like myXoops(89) which shows that the database called myXoops has 89 tables.

You should see tabs across the top of the phpmyadmin screen. Click the Export tab. Here you have several options and I'm not sure which is the best. Do some homework here and consider making mulitiple copies with different options settings.

After you have your mySQLbackup, do a Google search about restoring databases. I'm not sure how you do that through an ISP since I have my server here at home.

I hope this will help you.

WAIT! HOLD ON A SECOND...

It looks like there's an icon called Backup on the cPanel page. If you click that it looks like you can download a mySQLdatabase backup. That's the best thing to do, I think.

Again take all of this with caution because I've never used cPanel.

But at any rate you're going to need a backup of your data if you're to have any hope.

You might want to have a full backup (it's an option), but you should have the MySQL backup as a separate file as well. I think that you'll want to have it not packaged with everything else in a compressed file.

i checked phpadmin and found this error
SQL query:

SHOW KEYS FROM `xoops_session`
MySQL said:

#1016 - Can't open file: 'xoops_session.MYI'. (errno: 145)
what should i do now

repair the session table choose sessions table in the left column of my admin, click options up top, click repair.

see if that helps.

done it mate.thanks for u r all of your support.

It's working? Cool.

Now for the love of God man, back it up! Use the backup feature of cPanel and read up on the backpack module. You should get a backup at least monthly if not weekly or daily.

I'm glad everything worked out well.