Use several databases?

[nobru]

Hi all,
I am developping a Web site with PHP and Mysql.

I currently have 1 database for all that needs to be displayed on the Web site.

Now, I want to develop an admin area.
The thing is that to that end, I need to use some new variables which are not necessary for the Web site, but only for me as an admin.

Is it better to use the same database (which is located at the hosting company) to store these new data or should I create a new one (locally)?

If I want to create a new one, is it possible to connect to 2 different databases and create SQL queries with a join to 2 tables, each being in a different db?

Thanks in advance any advice, I am a bit in the dark right now!
Nobru

[the_Igel]

If you create a local db at your home computer, your web scripts won't be able to communicate with it from the hosting server.
But you (probably) mey create another db at hosting, if you feel like it.

[notionlogic]

As far as I'm aware, you can't join between tables on different servers but your question is slightly odd...

If you just want some variables stored for your own use then simply create a table in the existing database. Nothing else will use that information unless you want it to plus ytou can access it from anywhere!

[nobru]

OK, your answers sound logical, thanks guys.