I am looking for different alternatives to getting data into a MySQL database from an unattended command line output (a script) 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 appreciated. If anyone has any experience importing command-line output into a remote MySQL database please elaborate. Thanx Roy --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
