Can more than one directories share same database?

Discussion in 'Directories' started by Idiot Inside, Dec 30, 2007.

  1. #1
    Hello,

    It seems virtually possible, but have anyone done it practically? Can more than 1 directories use same database while they reside in same (server) and cPanel account?

    Any answers would be greatly appreciated. Of course +reps to kind helpers :)

    Thank you.
     
    Idiot Inside, Dec 30, 2007 IP
  2. fweikeong

    fweikeong Peon

    Messages:
    51
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    having different sets of tables for different application in a single database is perfectly alright, the only thing is your application must be able to differentiate the tables itself. If you are getting a program elsewhere, generally there is a 'table prefix' option available during installation, just set the second copy of the installation with a different table prefix and point the database to the same database.

    Be sure to check if the 'table prefix' option is available for your program, otherwise you may not be able to share one database with two copies of the same program.
     
    fweikeong, Dec 30, 2007 IP
  3. Marty_

    Marty_ Banned

    Messages:
    1,031
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    0
    #3

    I guess it depends on the script, like what information is kept in the database, users and listings wouldn't be a problem, but themes and possible other settings might, however these kinds of things can be worked around by creating a duplicate "table_config2" for example. Then in most cases a few edits to some files will distinguish the two sites.

    PS: Probable best to ask in the database section.
     
    Marty_, Dec 30, 2007 IP
  4. never2late

    never2late Peon

    Messages:
    19
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Yup they sure can.
    You would need a different prefix for both of them though
     
    never2late, Dec 30, 2007 IP
  5. mikey1090

    mikey1090 Moderator Staff

    Messages:
    15,869
    Likes Received:
    1,055
    Best Answers:
    0
    Trophy Points:
    445
    Digital Goods:
    2
    #5
    yes they can.

    when you see these directory networks and blog networks with 250+ blogs, its just 1 DB and many wordpress blogs.

    Its not advised. Pure spam and duplicate content. Google will stick all pages straight into the supplemental index and you wont have many cached pages.
     
    mikey1090, Dec 30, 2007 IP
  6. Marty_

    Marty_ Banned

    Messages:
    1,031
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    0
    #6
    If I'm not mistaken, I think he's looking to have two domains using and showing the same listings, ie: details entered into one directory will appear on the other ?
     
    Marty_, Dec 30, 2007 IP
  7. mikey1090

    mikey1090 Moderator Staff

    Messages:
    15,869
    Likes Received:
    1,055
    Best Answers:
    0
    Trophy Points:
    445
    Digital Goods:
    2
    #7
    yeah thats what he wants. duplicate sites.
     
    mikey1090, Dec 30, 2007 IP
  8. pipes

    pipes Prominent Member

    Messages:
    12,766
    Likes Received:
    958
    Best Answers:
    0
    Trophy Points:
    360
    #8
    As already mentioned, its a bad idea to use the same database on other sites, even if you want to use a database from one directory on another, mix it up a bit, delete/add/rename at least some of the categories.

    But from what your asking and hoping for, in regards to saving a bit of time with one thing, the effort would go to waste because your directories will be clones.
     
    pipes, Dec 30, 2007 IP
  9. enQuira

    enQuira Peon

    Messages:
    1,584
    Likes Received:
    250
    Best Answers:
    0
    Trophy Points:
    0
    #9
    Yes, as long as they have different table prefixes. I think for phpld the prefix is fixed "PLD" so the script should be modified to support this. in esyndicat you can specify the table prefix for each installation.
     
    enQuira, Dec 30, 2007 IP
  10. jbladeus

    jbladeus Peon

    Messages:
    485
    Likes Received:
    12
    Best Answers:
    0
    Trophy Points:
    0
    #10
    Yes, it can easily be done. However, whats the use of having two virtually identical sites displaying the same set of data? Won't be beneficial to either of them and might instead get them penalised for having duplicate content.
     
    jbladeus, Dec 30, 2007 IP
  11. Idiot Inside

    Idiot Inside Well-Known Member

    Messages:
    1,300
    Likes Received:
    65
    Best Answers:
    0
    Trophy Points:
    155
    #11
    Thanks for the input guys.

    I understand the duplicate thing, and I will be randomizing the listing in each category so that it looks different than others.
     
    Idiot Inside, Dec 30, 2007 IP
  12. SuperBytes

    SuperBytes Peon

    Messages:
    129
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    0
    #12
    Yes, it's extremely easy on the same cPanel account. Using the same script, simply point them both to use the same database, this can be done with any scripts.
     
    SuperBytes, Dec 30, 2007 IP
  13. DownUnder

    DownUnder Well-Known Member

    Messages:
    1,251
    Likes Received:
    152
    Best Answers:
    0
    Trophy Points:
    105
    #13
    Not sure but if you could set up feeds from directoy A, you could then bring what ever feeds you wanted into directory B.

    but i am not seeing why or what you would do this for ? anyway good luck with it.
     
    DownUnder, Dec 30, 2007 IP