Multiple Databases

[mgregg]

A couple of years ago when I first installed a PHBB forum on my site I had to create a mysql database in order for it to function. Well, to say I was in over my head would be an understatement, but I did finally get it to work.

My problem is that I've created several different databases, but I don't know which one is actually the one used for my forum. I think I have 10 total created, but not sure which ones to delete since they're not being used. It's been like this since I created the forum, but I'd like to tidy things up and get rid of what I'm not using.

Any tips on how to find out which database I'm actually using, and is it okay to delete the others?

Thanks!

Mike

[BerksWebGuy]

In your forum folder using FTP, look for config.php. You should see lines like:

$dbhost = 'mysqlxx.powweb.com';
$dbname = 'somethingName';
$dbuser = 'somethingUser';
$dbpasswd = 'somethingPassword';

That will be your database info. You can probably delete the rest. It may be a good idea to log into phpmyadmin.powweb.com to check before deleting the others.

Good Luck :cool:

[mgregg]

I found the info you mentioned in the config.php file and then proceeded to delete the other 9 databases in OPS. The forum still works and has all the info so I must be okay.

Thanks for the help!

Mike

[BerksWebGuy]

Glad you figured it out ;)

[YvetteKuhns]

That is great that you are removing unnecessary databases! It takes less time for PowWeb to make backups. ;)

[xanthakita]

those backups just saved my bacon too...! :) I do have an odd problem I'm trying to setup a third set of phpbb forums for a fansite. I can get the forums to install, however it's not taking my login ... meaning when I put in the admin id and password... the forums simply redisplay the login prompt again. I know this is simple, but I'm blind to it. Any suggestions?

skip it. I gave it some time to recoup. and guess what? I can get right in! :) anyhow, again I'm glad that there are backups!