Multiple wordpress on 1 database?

Discussion in 'Databases' started by pixeladd, Jun 11, 2008.

  1. #1
    I have several domains all hosted on a private server
    is there any way to install wordpress on lots of domains using just one sql database?

    thanx
     
    pixeladd, Jun 11, 2008 IP
  2. Boulder

    Boulder Well-Known Member

    Messages:
    806
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    118
    #2

    Yes that can be done! Just change the table prefix (so each install has unique prefix) when you install the wordpress applications.

    In the config file you will see the default prefix is set like this:

    $table_prefix = 'wp_'

    So when you do a second install that prefix will need to be different. It will give you the option to change it on install.

    Boulder
     
    Boulder, Jun 11, 2008 IP
  3. pixeladd

    pixeladd Banned

    Messages:
    2,238
    Likes Received:
    93
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thanx alot
    never realized it was that easy

    saves me alot of time
     
    pixeladd, Jun 11, 2008 IP
  4. pneulameiro

    pneulameiro Peon

    Messages:
    440
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #4
    if your blogs are in a dedicated server there is no problem. And one security alert: put the prefix of your wordpress tables ramdon strings. For example: wp_djsdedhudedka_
     
    pneulameiro, Jun 11, 2008 IP