About this Page
This is a discussion on Reloading DB within the Purged Topics forums, part of the NM Staff category; Hi, I recently installed a new site, and opted for a different theme. My original theme was smartDark, but I ...

TuNa · #1 (**permalink**) 02-17-2003, 02:02 PM

Hi,

I recently installed a new site, and opted for a different theme. My original theme was smartDark, but I have since changed to fiblack. Before I reinstalled my site I did back up my DB.

All I want to keep is the forums, with forum posts and users that registered accounts on my old site. The site was ported, as is the new 1, but I'm guessing I cant just upload the old DB to a new theme :?

How do I go about re-uploading the DB to the new site and just keep the User accounts, Forums and Forum posts within along with all permissions?

If some1 can help me out on this I would be very greatful. Ive looked over the DB SQL but tbh it doesnt meen anything to me

ops:

mikem · #2 (**permalink**) 02-17-2003, 02:15 PM

Ok so are you wanting to make a NEW Nukesite with phpBB ported Forums and then reload your Data from your backup DB , just users, Forums and Forum posts?
No other data?

mikem

TuNa · #3 (**permalink**) 02-17-2003, 02:54 PM

Sorry for the long wait for a reply.

Yes thats all I need I think, unless you can think of any other important data that I'll need to make them work.

P.S.

ops: Where do I upload the file to in PHPmyAdmin?

Martin · #4 (**permalink**) 02-17-2003, 03:30 PM

My forum tables are located in the database "phpnuke" with my nuke tables. I would assume yours will to if your db is named the same.

TuNa · #5 (**permalink**) 02-17-2003, 03:39 PM

What Data from the sql backup file do I need to use and where abouts in PHPMyAdmin do I place it?

mikem · #6 (**permalink**) 02-17-2003, 08:29 PM

You would need all these tables from your saved DB file. Basically you can cut and paste thee tables and their info into a new text file and then save it as whatever.sql

nuke_bbauth_access
to
nuke_bbwords
total of 27 bb tables

also,
nuke_users
nuke_users_suspend
nuke_users_pending

The main ones though are all the _bb tables and the users table. If you are only planning to restore your Forums and posts and users info.

Once you get your Nuke/phpBB back up and running, then upload the whatever.sql fiel you made in phpmyadmin.
BACKUP your DB BEFORE uploading your whatever.sql file. Just in case it doesn't work.

mikem

About this PageThis is a discussion on Reloading DB within the Purged Topics forums, part of the NM Staff category; Hi, I recently installed a new site, and opted for a different theme. My original theme was smartDark, but I ...

Reloading DB

About this Page
This is a discussion on Reloading DB within the Purged Topics forums, part of the NM Staff category; Hi, I recently installed a new site, and opted for a different theme. My original theme was smartDark, but I ...