I have a major problem:
Basically, I need to be able to update two databases. One runs on a machine but cannot automatically run queries and dump the data to the local file system. The other database is on a *nix server and is MySQL.
Now, I need to be able to somehow write a program that checks for updates in the local database (checking the database file timestamps or what have you, I'm not sure), tells it to run a query or number of queries, then uploads the resulting CSV files to the web server in a certain directory (probably via FTP). What would be better than this, of course, is somehow telling it to run a MySQL query on the web server while reading the CSV files generated by the local database. Even better still, being able to run the query on the local database and upload the data as a MySQL query without needing to save it to CSV files first.
That's just one side of the equation. I also need it to check the web server in a specific directory periodically for .dta files which it will generate every time a customer leaves an order. It needs to be able to download these files and place them in a directory on the local machine.
This is where my problem is: I don't really know where to start, what programming language to use, and even if I use C, what type of architecture I'm looking at. While I have written a fair amount of C before, I am not sure about Internet-based programming since I have never done such a thing (by this I mean communication to the Internet).
I'm also not sure how I would run the queries on the webserver, and if a good way to get the CSV files read is to put a directive in the main loading page to read the mysql queries generated by the local program.
In fact, I'm even wondering whether Java would be a better bet.
Anyway, if you guys could help me and lay to rest my fears, that would be a good start.
Thanking you in advance...