remote ODBC connections

Hi, I am wondering if there are web hosts that allow you to remotely connect to your database remotely from your home computer. My website is scripted in php and relies on a backend mysql database.

I need to extract data from my web database on a daily basis. Currently, the way I do this is using phpAdmin, which requires I use a web browser, and perform repetitive task of exporting the data to a csv file that I can import into the mysql database running at my local machine at home.

What I really want to do is be able to run a program on my Windows based desktop (from home) which can extract the specific data I need with one click of a button. This would be no problem if I happened to be running my own webserver on my LAN at home, but I am not. My web site is hosted my a commercial web host.

I was hoping I could connect to the database on my web host using a standard ODBC connection string, just as I could if the database happened to reside on my LAN. But my understanding is that this may not be possible because most web hosts block port 3306 (mysql's TCP port)

Any ideas here?

 

 

 

 

Top