12
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.