Partial database backup and restore?

xgunz · 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

hitwalker · 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 ?

xgunz · New Member Joined: Sep 10, 2005 Posts: 18

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.

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

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 ?

xgunz · New Member Joined: Sep 10, 2005 Posts: 18

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

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

well ....

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

xgunz · New Member Joined: Sep 10, 2005 Posts: 18

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

montego · 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

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

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