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 Link to comment https://forums.phpfreaks.com/topic/2837-back-up-database/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.