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.

Making 2 databases share the same sign up and log in

Discussion in 'Databases' started by qwikad.com, Feb 19, 2015.

  1. #1
    I have two databases (identical, but serving two different purposes) that I want to share the sign up and log in. Right now they have separate sign ups and log ins. How do I connect just the sign up and log in part without sharing the rest of it?
    SEMrush
     
    Solved! View solution.
    qwikad.com, Feb 19, 2015 IP
    SEMrush
  2. #2
    Well, the easiest way would be to just make it into one database (copy the tables from one into the other) and separate them with prefixes if the names of the tables are the same. You'd need some tweaking of the code for accessing the different information of course, but that should be trivial
     
    PoPSiCLe, Feb 19, 2015 IP
  3. qwikad.com

    qwikad.com Illustrious Member Affiliate Manager

    Messages:
    6,133
    Likes Received:
    1,207
    Best Answers:
    22
    Trophy Points:
    400
    #3
    Oh, I see. Will give it a try tonight. Will let you know how it went.

    Added later: My hat's off to you. Just did it and it's working perfectly.
     
    Last edited: Feb 19, 2015
    qwikad.com, Feb 19, 2015 IP
  4. sysdev0

    sysdev0 Member

    Messages:
    30
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    26
    Digital Goods:
    1
    #4
    Bear in mind if the reason you might want two is in case on fails.. if this database fails you're out both.
     
    sysdev0, Feb 20, 2015 IP
  5. qwikad.com

    qwikad.com Illustrious Member Affiliate Manager

    Messages:
    6,133
    Likes Received:
    1,207
    Best Answers:
    22
    Trophy Points:
    400
    #5
    My hat's off to you. Just did it an it's working perfectly.
    Thank you for the reminder. I backup my databases regularly and save them to an external hard drive.
     
    qwikad.com, Feb 20, 2015 IP
  6. PoPSiCLe

    PoPSiCLe Illustrious Member

    Messages:
    4,630
    Likes Received:
    725
    Best Answers:
    152
    Trophy Points:
    470
    #6
    As I understood it, this was separate databases with a joint login (or at least a provision for that) - say two different Wordpress schemes, with the same information in the user-tables. Combining them into one larger database, sharing the user-tables, are trivial, and doesn't do anything to limit security compared to having them in separate databases. However, the point you bring up is a good one, and one should always make sure that data-integrity and backups are current and up-to-date.
     
    PoPSiCLe, Feb 21, 2015 IP
  7. MelikeKilic

    MelikeKilic Greenhorn

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    21
    #7
    thank you ;)
     
    MelikeKilic, Jul 27, 2015 IP