Auto database backup

[truzenzuzex]

Any chance of a hack to auto dump my database to a protected directory on my server?

Thanks, T

[filburt1]

Run a cron job that does it. That's what I do and it works fine.

[truzenzuzex]

Could you explain a little more please?
Kinda new to this.

[filburt1]

1. Create a file like this in notepad (don't give it any extension):

#!
echo Dumping database to file...
mysqldump --opt -uusername-ppassword dbname > ~/dump.sql
echo Dump complete!

2. SSH into your host and type (where filename is whatever you named the file in step 1)

chmod +x ~/filename

3. Set the script to be a cron job. Ask your host on how to do this.

[truzenzuzex]

Right, thanks alot mate.

[Rapid Gaming]

Today at 06:50 PM filburt1 said this in Post #4
1. Create a file like this in notepad (don't give it any extension):

#!
echo Dumping database to file...
mysqldump --opt -uusername-ppassword dbname > ~/dump.sql
echo Dump complete!

2. SSH into your host and type (where filename is whatever you named the file in step 1)

chmod +x ~/filename

3. Set the script to be a cron job. Ask your host on how to do this.

Is that CHMOD 0777 and can we make it automatically generate a name such as dump015215252.sql, etc

Thanks!

[filburt1]

No, it's not chmod 777. I don't know how to rename the file like that. chmod +x makes it executable.

[Rapid Gaming]

Yes 0777 and 777 are the same (at least, i think) -- How often do you backup your database if you don't mind me asking pls?