Server to Server root prob

[wudz]

Hi,
Not to sure if this is the correct forum for my problem, but here it is.
I have a site running mySQL and the hosting I would like to keep but is in another country, not UK where I am based.
I have a domain hosted on another server which I would like to use as the main site domain and is a .co.uk which I belive has to be hosted in the UK.
Now when I use the UK domain and link to my overseas SQL data base it changes the path eg /home/

http://www.myurl.com/index.html/.....

the /home/ is the problem which causes errors when the database is called..etc.
Is there a way around this or should I bring my site to a UK hoist...
Sorry for the long post, but perhaps someone has had a simlar problem..
Cheers

John

 

[jpadie]

no-one ever responded to this post. strange.

there is no requirement for a .co.uk to be hosted in any particular jurisdiction in the world.

i'm not sure what the path issue is with mysql. i would guess this may be an issue with your upload program (dreamweaver?) rather than anything more sinister.

i am assuming that you only reference this url once in your db connection script. ie mysql_connect("

http://www.myurl.com",

username, password). of course the "/index.html" is incorrect as you need a hostname and not a page address.

you also need to make sure that your foreign host has allowed external access to the mysql db. possible but unlikely. you can test this by telnet(ting) to port 3306 on the remote host and see whether it lets you in.

if you have eternal port access, you then need to make sure that the username and pwd you have works from a remote host. lots of pitfalls here!

 

[wudz]

Hi jpadie,

You are spot on yet again, it was the host name I required and I did get that sorted and all is now OK.
Many thanks for responding, thought I had asked in the wrong place..
I am sure that in the not to distant future your knowledge will be required again.

Cheers

John