Mysql to desktop

[dswilder]

I am needing a way to move MYsql data from the web server to my local desktop with a script or by some other automated means, but my web host has too many restrictions that will not allow me to access the database. I do not have ODBC access nor telnet access. Without these two I do not know what else I can do.

It does not matter what format it is in when it gets to my desktop as long as it can be imported into a database, csv, txt, etc...

Any help is appreciated, Thanks.

[NogDog]

How do you currently interract with the database now? (Server-side scripting language, tool like PHPMySQL, or what?)

[dswilder]

The data is entered via a PHP web page and I have myphpadmin installed to access the data. I can manually export the data from this and then import into my local DB, but I want something that will automate this. I can handle the importing once it is on my local machine. I just need a way to get it there.

[NogDog]

Well, I was thinking along the line of a PHP script using the MySQL SHOW commands to output the SQL to recreate the table and data, but then you'd still need to manually save the output to a local file and then import it via SQL or PHPMyAdmin on the PC. As far as something to do it fully automatically, I'm not sure about that. Maybe something using CURL on the PC to call the PHP script on the server?

[chazzy]

Not sure how you'd pull this off in windows, but you could schedule something to run locally daily a specific time to grab data off a particular website.
Otherwise, you could setup a local webserver and have something run and grab from your host (could be another webpage)

[dswilder]

Ii beginning to think that a new hosting company would be better. Does anyone know of hosting company that will allow ODBC that is relatively inexpensive and reliable?

[chazzy]

I'm sorry, but why do you need ODBC?
ODBC is extremely insecure, thus the name "open database connection" anyone can read what you send from server to client.

[dswilder]

I would like to use my Access database forntend on my local computer to read and manipulate the adata stored in the Mysql database on the web server. Right now I have to manually export the data and then import it.

[chazzy]

I can't think of any host that supports anything like that. Although, have you considered switching to a windows server instead of linux if this is the route you want to pursue? You have to understand why ODBC is extremely bad and why hosts do not support it, you're not just opening your data, you're opening the entire server for people to come in.

[dswilder]

I understand now.

I am going to attempt something with php that outputs a txt file and then ftp the file back to my desktop.

If anyone has any other ideas or has a php script to run that will output a txt file let me know.