1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Pulling content from one database location for different sites & hosts?

Discussion in 'Databases' started by sixav, Nov 26, 2006.

  1. #1
    Hi

    I plan to use one central database for several web sites (with different hosts) that use the same content.

    I just want to know is there any way to use or pull content from a single database from one host to use with different web sites host on the same or different servers?

    I am using several shares packages & a VPS at the moment (most servers I host use cPanel).

    Is this possible for the above types of hosting package? and
    How can I do that?

    Thank you very much for any answer.

    Six
     
    sixav, Nov 26, 2006 IP
  2. disgust

    disgust Guest

    Messages:
    2,417
    Likes Received:
    133
    Best Answers:
    0
    Trophy Points:
    0
    #2
    yes, you can.

    go into phpmyadmin and setup new users and allow them to connect from hosts other than LOCALHOST. change that entry to the ip of the server they're connecting from.

    then when you're connecting to the db from the other servers, use that user/pass and the ip (instead of localhost).
     
    disgust, Nov 26, 2006 IP
  3. JEET

    JEET Notable Member

    Messages:
    3,825
    Likes Received:
    502
    Best Answers:
    19
    Trophy Points:
    265
    #3
    Godaddy hosting, I think is an example of what is mentioned above.
    It's just about how you connect to your database.
    Bye :)
     
    JEET, Nov 26, 2006 IP
  4. sixav

    sixav Active Member

    Messages:
    123
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #4
    Thanks a lot for a clear answer, Disgust & JEET. It works. :)
     
    sixav, Nov 27, 2006 IP