having two databases

russellharrower · **Joined:** April 4th, 2007, 11:39 pm **Posts:** 151

Hi I am designing my new website, the database for the website is on the webserver, but the same db is on the studio PC.

I am running into the following issue. in short i need to close connection to the SAM pc so I can run mysql under the now playing information on my site.

I have tried $db=>close(); but nothing.
If anyone can help that would be great.

russellharrower · **Joined:** April 4th, 2007, 11:39 pm **Posts:** 151

Can anyone help plz?

Elevatorboy · **Posted:** November 2nd, 2009, 10:37 am

Patience, please. You posted on a weekend in a user-based forum. If & when someone knows, I'm sure you'll get your answer.

WDA1 · **Posted:** November 2nd, 2009, 11:20 am

Why are you running the same database on your webhost that you're running on your SAM PC? This isn't required.

russellharrower · **Joined:** April 4th, 2007, 11:39 pm **Posts:** 151

I am running my website MYSQL on my webserver. that database hosts all the data from news stories to pages etc.
the SAM DB is on the studio computer.

I hope that helps.

WDA1 · **Posted:** November 3rd, 2009, 7:18 am

The NOW PLAYING information does not run off the MySQL on your website. Your website pages will connect to your MySQL on your SAM machine.

FesterHead · **Posted:** November 3rd, 2009, 1:19 pm

It is best to not re-use the database connections.
Use one for the webserver database and one for the SAM database.

Mic-Beatz · **Joined:** March 21st, 2007, 5:27 am **Posts:** 198

Try "Mysql Replication" we have just started using it other than small problems we bump we are doing allright

russellharrower · **Joined:** April 4th, 2007, 11:39 pm **Posts:** 151

I am trying to close connection to the sam DB

Forum rules

having two databases

Who is online