emptying db with cron
Am trying to set up a cron which empties a database and then restores from a file
Have come up with
mysql -u USERNAME -PASSWORD DBNAME > /usr/bin/php /home/domain/public_html/dump.sql
Not sure why I cant get this to work as a cron?