Hi Philg,
The script is now creating the files, but I cant transfer / delete them in ftp software. When I telnet in and ls I see ?'s after each filename.
Do I have to close the files after mysqldumping to them or something?
Help appreciated.
Thanks
#!/bin/sh
/usr/bin/nice -20 /usr/local/bin/mysqldump -q -hhost.com -uusername -ppassword databasename > /usr/home/backup/databasename_`/bin/date +%Y%m%d`.sql
cd /usr/home/backup
/usr/bin/find *.sql -mtime +7 -delete
echo "Database backup complete. Please FTP in and collect resulting .sql files" | /usr/bin/mail -s "Database backup complete "
me@me.com ;