I have a process where I am updating a 75-million record weekly. The update adds some new records and changes others. The customer's desire is to keep a versioned backup of this and 4 other related tables each time the process is run. Mysqldump seems to be the fast way of doing this. However, I am trying to overcome a security problem. I can create a shell script to dump all 6 tables, and that works well if I include the password in the command line to mysqldump. However, that will leave the password in the clear in the log files, and I don't really want that. I tried the following:

mysqldump -u user -p database table > outFile <passwordFile

but that didn't work. Can someone suggest an alternative?

Thanks Gary