How to get data from a database to my local machine?

DB is MySQL

[HughMungus]

I have a process that runs on my local machine which requires information from a database to be used in a dos batch file.

Currently, I have a setup where a query string is sent to the web server with the id number of the record I want to get and a page on the web server writes a file to the server which is then downloaded using httpget to be used by the batch file.

Is there a better way to do this? In other words, how can I have a dos batch file interact with the database directly to get the info in the record?

TIA

[coopster]

That method works fine. Or, if it is just a small result set or single row of data, just push it right out to the browser for cut and paste. Hopefully I'm not misunderstanding your question...

[HughMungus]

Well, it's an automated process. The local machine is taking voicemail messages and its behavior is based on the contents of a text file that the local machine gets from the web server (each voicemail mailbox has individual settings). What I'm trying to get around is writing a file to the webserver which is downloaded and replace that with some way for a batch file to make a database call and get info from the db (and create a file locally). Not a huge problem, just kinda clunky in its present form.