Jump to content


Photo

Back up Database


  • Please log in to reply
No replies to this topic

#1 ccmd00d

ccmd00d
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 09 November 2005 - 03:36 PM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users