database help!

By Bios-1 on 14 Nov 2002 at 02:17 UTC

I already have some tables in my database that are the same as drupal eg. access is in use by my vBulletin and so are some others. Is there a way i can change it to have a main_ at the start of each prefix and also not have any errors on my site?

Comments

Not Sure but Good Idea

fuzzygroup commented 14 November 2002 at 13:49

I know that when you install phpbb, it asks you for a tablename prefix which it then establishes as a constant for all SQL table name references. This is good for low end hosting situations where you often have only a single DB. Here's a modified version of how I do it in my code.

// UPDATE THIS HERE
// prevents namespace collisions w/ existing tables
// note that tihs is optional and will generally be left blank
$table_prefix = "";

// CONSTANTS START HERE
// db table names
// the core message data
define('EMAILS', $table_prefix.'fo2_emails');

and then when I reference a table in my sql, it becomes:

"SELECT subject, accountaddress FROM " . EMAILS . "WHERE subject = 'XYZ' ";

NOTE: I'm not saying that this helps you at all but that it's a good idea for the future of Drupal.

do you need a place to host more than one db? [n/t]

gene@csof.net commented 14 November 2002 at 22:43

I have a little (read: tiny) hosting company I run off a single debian server that I can set you up on and I'll happily give you a half dozen dbs if you want (with phpmyadmin access)... email me at genem_at_cascadehosting_dot_com if you're interested.

Apps sharing the same db is scary, but the other comment here seems like a good tip if you aren't up for switching hosts.