MySQL on another server

[cheesewhisk]

is it possible to access a MySQL database that is hosted on one server using a file on another

ie
can this file...
http://www.myfirstdomain.com/fashdatabasefile.htm

...read this database
http://www.myseconddomain.com/mysqldatabase

?

[Musicman]

Hi,

no answer - you have to find out yourself... First of all, you are not going to use http://somewhere.com/database or anything like that, but rather the mysql_connect data in your script will name a specific server (and perhaps a specific port) rather than the default localhost.
If both domains are running on the same server group / hosting company, there should be no problems. If they are different, it deends on the security policy of the database server whether you can connect directly.
If it does not work, you will probably have to use some proxy scripting. See the latest tutorials to find out more about this topic

Musicman

[cheesewhisk]

i know it's currently localhost that was a bad representation sorry i just needed to get the point of two domains which are on two seperate hosting companies

and if it's not localhost what is the address format?

http://www.mydomain.com
www.mydomain.com
mydomain

localhost.mydomain
i can't find any reference to that bit

what about this one then

host 1 allows php
mydomain 1 has a readdatabase.php file

host 2 doesn't allow php
mydomain 2 has a flash file that loads variables from host 1 readdatabase.php file

will it work?

[Musicman]

Hi,

the address format for a remote mysql server is just an internet address without the http:// prefix, so it could likely be db.provider.com or mysql.provider.com or www.yoursite.com - it could also not work at all.
As for crossdomain scripting: flash does not support it, but if host 2 has any kind of scripting, you could make a proxy script.
Also, you could perhaps create a version of the database script on server 1 that delivers a flash movie rather than variables

Musicman

[cheesewhisk]

ok thanks for the directions


i'll let you know if i get anywhere

cheers