I am trying to backup my mySQL database using the cron tab in cpanel. This is the following command i am using...
mysqldump --user=user --password=temp --quick --add-drop-table --add-locks --extended-insert --lock-tables --all derek_IST | gzip > /home/databackup-`date -I`.gz
This command is set to go every 15 min for testing....however i am get the following error in my email.
/bin/sh: /home/databackup-2005-11-09.gz: No such file or directory
My question is how do i set the directory where to store the file? I dont know what my root we directory is...
Back up Database
No replies to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users