CMPS Backup Recovery

[BlackRanger3d]

Hey
backed up my whole forum to my PC
Upgraded from 3.5.0 to 3.5.3.
Lost cmps and gallery.
Reran install files and reinstalled templates. Worked for gallery but not cmps.
So uninstalled cmps (FULL removed files from server) and then reinstalled (full put clean files back).

CMPS works but all my settings are gone, no hacks just news modules etc.

So...since I backedup. Is there a file(s) that I can simply copy over, or even copy code from to get my old settings back.

Or do I have to slog through redoing them.

Thanks.

[KW802]

CMPS settings are stored in the same MySQL database as vBulletin so nothing should've been lost in an upgrade unless you upgraded by starting with a new database and imported your old forum settings into the new DB. After a vB upgrade CMPS would've just needed to be re-installed (or upgraded if going from vB 3.0.x to vB 3.5.x).

What method exactly did you do to upgrade?

[Brian]

If you need to get eveything from the CMPS back, drop your adv_setting, adv_settinggroup, adv_modules, and adv_pages tables. Then restore those tables from your backup, and edit a page and a module through the admin cp to update the cache on those two things.

[BlackRanger3d]

If you need to get eveything from the CMPS back, drop your adv_setting, adv_settinggroup, adv_modules, and adv_pages tables. Then restore those tables from your backup, and edit a page and a module through the admin cp to update the cache on those two things.

Ok thanks for the help.
But could you dumb it down a bit.

By drop do you mean erase/revert?
Since adv_modules (and the others) don't have file extensions that they would be under styles and templates, but I can not seem to find them. Where should I look?

And how do I open up my back file and only selct those tables you listed.

Thanks

[Brian]

Do you have phpMyAdmin? If so, I would suggest creating a new database, then restore your backup to that database. Then browse to each of those tables mentioned above (adv_pages, adv_modules, etc) and click on the 'Operations' tab at the top of the screen. Once there, look for the section that says 'Copy table to (database.table):'. Select your normal database from the select menu there, then add the table name that you are copying in the text box right next to the database name. Make sure the 'Structure and data' radio button is checked, then check the 'Add DROP TABLE' box and click 'Go'. Then repeat for the other tables.