Dump DB to CSV

[cmadsen]

I have a form that is inputing to a mySQL db. I need to dump that table to a csv file and then FTP that file to a XP folder on another computer. The problem I'm having is the transfer of the file to the XP computer.

[Twey]

In what language?

[cmadsen]

PHP. This job needs to be automatic thru a cron job.

[Twey]

Hm, it's probably easiest to use a shell script for the FTP transfer:

ftp -in <<EOF
open ftp.backupsite.com
user youruser yourpassword
mput /some/directory/*
bye
EOF

[cmadsen]

Thanks. I forgot all about shell scripting.