My host and I just discussed increasing my bandwidth, and they felt they needed to transfer my entire account to a new server, ontop of that changed my account to a reseller!! Im furious, because I had no warning and didnt make a recent enough backup of my db.

Is there any way to retrive that? I do have the most recent backup of the XOOPS files and all, how do I reuse this? I really have no clue how to write table data, so is there anyway around this? Thanks alot .

unless you actually have a dump of the MySQL db, then there is no recovery.

or if they haven't deleted that actual db from that particular server maybe they could do a dump or transfer for you either by mysqldump or by copying/moving the MySQL files for that db from the /var/lib/mysql/
but if they can't then, i'm afraid it looks like u gotta start again or use your last known backup if u have 1.

files are unimportant to the db itself.. you can reuse them, but if u haven't actually got the sql dump/backup your db is lost.

Your hosting company should have a backup of your entire site, including the DB, it may be a week old, but at least you will have something.

Give them a call or however they take care of things, since they moved your site to a different machine and not coordinating that with you, they should be quite cordial about giving you some good service

good luck!! like they say, your data is only as good as your last backup