ccmd00d Posted November 9, 2005 Share Posted November 9, 2005 Hi all, 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... Thanks, Derek Quote Link to comment https://forums.phpfreaks.com/topic/2837-back-up-database/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.