Jump to content

Archived

This topic is now archived and is closed to further replies.

ccmd00d

Back up Database

Recommended Posts

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.