Partial database backup and restore?

New Member Joined: Sep 10, 2005 Posts: 18

I am currently running version 7.6, this is want I would like to do if possible.

I would like to start fresh with a clean install, but I don’t want to lose my member logins and my forum postings. I don’t want to back the entire database as I feel some parts of it maybe corrupted.

Is there anyway just to backup the databases related to the forums and the member logins?

Thanks

Sells PC To Pay For Divorce Joined: Posts: 5661

well the one that takes care of all your members is table :

Code:

nuke_users

and your forum :

Code:




nuke_bbauth_access


nuke_bbbanlist


nuke_bbcategories


nuke_bbconfig


nuke_bbdisallow


nuke_bbforum_prune


nuke_bbforums


nuke_bbgroups


nuke_bbposts


nuke_bbposts_text


nuke_bbprivmsgs


nuke_bbprivmsgs_text


nuke_bbranks


nuke_bbsearch_results


nuke_bbsearch_wordlist


nuke_bbsearch_wordmatch


nuke_bbsessions


nuke_bbsmilies


nuke_bbthemes 


nuke_bbtopics


nuke_bbtopics_watch


nuke_bbuser_group


nuke_bbvote_desc


nuke_bbvote_results


nuke_bbvote_voters


nuke_bbwords

But before you do anything backup your database.
but what is more important.why you think your database is corrupted ?

Posted: Tue Oct 11, 2005 9:11 am

I just joined this website and was asked to install a module for them. So I went about the usual method of installing modules that I have done several times before.

To my surprise the module I was adding was not showing up and if you would rename a module that was in the module directory, it would disappear and you would not be able to re-add it.

I researched and came across several people that had similar problems and it all pointed to a corrupted database.

So this is what leads me to believe that the db is in bad shape.

Am I missing the boat on this? Thanks for your help sir.

Posted: Tue Oct 11, 2005 9:21 am

no but this is not some corrupted database.
modules not adding or showing happens.. Sad

in the admin folder..
go to modules/then modules.php
Somewhere about like 136....

there you will find a line that looks like this..

Code:

$db->sql_query("insert into " . $prefix . "_modules values (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1', '0', '')");

Does your look the same ?

Posted: Tue Oct 11, 2005 10:09 am

Here is what mine looks like...

Code:

$db->sql_query("insert into " . $prefix . "_modules values (NULL, '$modlist[$i]', '$modlist[$i]', '0', '0', '1', '0', '')");

So yes, looks the same..

Posted: Tue Oct 11, 2005 10:53 am

well ....

Tell me...are there anby extra addona installed that makes changes..?
Can you post your modules table here..?

Posted: Tue Oct 11, 2005 11:01 am

hitwalker I read many of your posting and you are the person I was hoping would reply.

To be honest, I would rather start fresh; I don’t trust the install that is there now. There are multiple modules and block directories all over the place and the guy whom originally did the install is no longer around.

So what I would like you to help me with please is tell me how I could accomplish this.

After I have finished the new fresh install, how can I backup the databases you mentioned above and restore them on the new location?

I know this has to be done with mysql, but I have no clue on how to do it?

If you could give me instructions on this I would be most grateful and one happy camper.

Thanking you in advance sir

registered · Posted: Tue Oct 11, 2005 9:25 pm

if you have access to the phpMyAdmin tool (a PHP-based front-end to mySQL -- an administrative tool used by MOST web hosts), you would select your database and then there should be an "Export" function tab at the top. Click that and select the tables that you would like to export, and make sure to click the "Add DROP TABLE" option. You can play with the various options to see what SQL is generated and also make sure you select "Save as File" towards the bottom. Also make sure you elect to download the data. (You could also ignore the Structure export altogether and just export the data... just depends on your "taste" and/or "needs".)

You could then review that output to make sure everything looks right to you (since you mentioned possible corruption) -- make sure all the right columns are represented in the structure and data. Then, in your new, clean database, you can select the SQL tab, select your just download file, and click "GO". This will execute your just exported file of SQL commands.

I am sure if you practice with the different options, you'll become a "pro" in no time!

Regards,
montego

Posted: Wed Oct 12, 2005 4:41 am

just a small reply to xgunz to his original question..
yes you can start over again and importing stuff back like the forum and your members.
But be carefull with what you do..
Allways backup and if your not confident enough doing the work ask someone who is...
But i am currious how your modules table looks like..