Non oddc/jdbc remote connection to MySQL

[Anon]

I will try to keep this simple. I am looking for different alternatives to getting data into a MySQL database from a command line output from a remote machine. This is what I have so far:

email: Parse the output from the command line and simply email it to the MySQL database server, where a sendmail script can add it to the database

ftp: Parse the output into a csv text file and ftp it to the MySQL server and then let a cron job pick it up and import the data into the database

htttp: (This is a little more difficult since I am trying to do everything through a command line) I could use a custom php command script to do an http insert into the database (the security on this method could be of concern).

Any feedback would be GREATLY appreaciated. If anyone has any experience importing command-line output into a remote MySQL database please elaborate.

Thanx
Roy

[lowtide]

http://www.anse.de/mysqlfront/

[Anon]

I don't see what this has to do with the topic? I am looking for alternative means to import data into a MySQL database, ie ftp, http, email from an unattended command line environment on Linux.

That looks like a nice front end to manage a MySQL database though, thanx for the link.

Roy