Sharing tables between Databases

Avatar
  • Answered
Greetings,

I have two sites with two databases I need to share site1 users and session with site2. Can anyone assist me with this task as I have no knowledge in MySql.
Avatar
Scott
Hello,

Thank you for your question on sharing information to two databases. This would entail creating two database connections, one to each one and then running the same query against both databases. This way they both have the same information. It is not sharing a single table with both databases, but having an identical table in both and updating them at the same time.

Unfortunately we cannot provide specific code as solutions, but I hope this explanation helped you so you can go from there.

Kindest Regards,
Scott M