1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2002
    Rep Power

    Seperate databases?

    I am just now getting involved in the whole web database thing and had what I assume is a pretty general question. I am working on a couple of scripts in php that use access to a database to store everything from customers emails for a newsletter to news stories for a section on the site. Here's my question.

    Should I have two seperate databases, one for emails, and one for newsletters, or is all the information really on the same database on the server, but just seperated by identifiers and such breaking the information down into groups on a single storage unit? I am using mysql.

  2. #2
  3. Contributing User
    Devshed Intermediate (1500 - 1999 posts)

    Join Date
    Oct 2001
    New Zealand
    Rep Power
    It'll all be on one database server, so the easiest thing to do is just create tables under different names, then go about your script building as usual and nobody will know the difference.

    BTW, if it's all for the same business then you never know when the two sets of data may actually be needed together!

IMN logo majestic logo threadwatch logo seochat tools logo