phpBB and blogging software in the same mySQL Database?

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
unknownsoldierX
Registered User
Posts: 3
Joined: Tue Mar 22, 2005 1:03 am

phpBB and blogging software in the same mySQL Database?

Post by unknownsoldierX » Tue Mar 22, 2005 1:05 am

I new to PHP and databases. Would it be OK to have phpBB2 and Wordpress using the same mySQL database as long as the prefixes where different? I.e., if my phpBB where to use the prefix phpBB_ and Wordpress use a different prefix?

flogger12
Registered User
Posts: 14936
Joined: Tue Nov 25, 2003 2:13 am

Re: phpBB and blogging software in the same mySQL Database?

Post by flogger12 » Tue Mar 22, 2005 1:15 am

unknownsoldierX wrote: I new to PHP and databases. Would it be OK to have phpBB2 and Wordpress using the same mySQL database as long as the prefixes where different? I.e., if my phpBB where to use the prefix phpBB_ and Wordpress use a different prefix?

absolutely, no probem at all, just give whatever program you want to use the database, a different table prefix and you are set.

robert

unknownsoldierX
Registered User
Posts: 3
Joined: Tue Mar 22, 2005 1:03 am

Post by unknownsoldierX » Tue Mar 22, 2005 1:27 am

I have my hosting with Godaddy. I asked them and they said it would screw things up. They said I would need to upgrade to get more databases or use blog software that didn't use a database. I'm new to mySQL and databases all together, but my intuition told me it should work fine that way.

Does the backup feature in phpBB only backup those items with the phpBB_ prefix?

User avatar
salty78
Registered User
Posts: 63
Joined: Sat Feb 21, 2004 10:14 am

Post by salty78 » Tue Mar 22, 2005 2:23 am

As far as I know, the phpBB backup feature only backs up the default tables. However, you can tell it to back up additional tables by listing the tables with a comma between tables.
meh

User avatar
MHobbit
Former Team Member
Posts: 4761
Joined: Thu Mar 18, 2004 5:32 pm
Location: There and Back Again

Post by MHobbit » Tue Mar 22, 2005 2:48 am

Salty78 is right.
I new to PHP and databases. Would it be OK to have phpBB2 and Wordpress using the same mySQL database as long as the prefixes where different? I.e., if my phpBB where to use the prefix phpBB_ and Wordpress use a different prefix?


Yep. My blog uses the same DB has my forum and portal do. It may or may not be efficient, but it works perfectly well.
Former phpBB MOD Team member
No private support is offered.
"There’s too many things to get done, and I’m running out of days..."

flogger12
Registered User
Posts: 14936
Joined: Tue Nov 25, 2003 2:13 am

Post by flogger12 » Tue Mar 22, 2005 3:27 am

to start with godaddy doesn't have a clue when it comes to hosting, their business is domain registration and they should have stayed there.

also, they most likely just want you to upgrade to a more expensive package.


just make a backup from your admin panel, if you don't have any MODs installed, that will backup everything, do a full backup. then go ahead and install the blog, using the same database but a different table prefix and you will be fine.

by the way, there is a blog MOD for phpbb, a couple of them, check out phpbbhacks.com for them.


robert

unknownsoldierX
Registered User
Posts: 3
Joined: Tue Mar 22, 2005 1:03 am

Post by unknownsoldierX » Tue Mar 22, 2005 8:59 am

Yeah, I figured the tech I talked to either didn't know what they were talking about, or was just trying to trick me into upgrading. Everythings been working fine.

As far as backup, I was wondering how I would go about backing up, say, just my blog. Without downloading the entire database.

Locked

Return to “2.0.x Support Forum”