HOW TO: Automated database backups (1 line of code + cPanel)

[Tom K.]

Can you make the backupdb.php file run and backup the ENTIRE database not just the mybb tables?

Yes you can.

Anyone want to enlighten me how? My host only allows PHP execution in crons

[KuJoe]

I believe it's in the wiki. I'm fairly certain that the Admin CP backup feature will backup all tables on the database and not just MyBB ones, I could be wrong since I don't use it anymore but last I checked it had my custom tables in it.

[TheGodFather]

This user has been denied support.

giving these errors

/home/xxxxxx/autodbu.sh: line 42: 5G: command not found
/home/xxxxxx/autodbu.sh: line 746: mutt: command not found

How to fix them?

[KuJoe]

Can you post the contents of autodbu.sh (without the database connection information of course).

[TheGodFather]

This user has been denied support.

Sorry, wrong place.

This errors occurred in drankur's auto database .sh file.

http://pastebin.com/0n7ms1gf

[KuJoe]

Oh ok. Good luck then.

[TheGodFather]

This user has been denied support.

/home/xxxxxx/autodbu.sh: line 42: 5G: command not found
error fixed.

Do you have any idea on mutt -s function which is giving this error
/home/xxxxxx/autodbu.sh: line 746: mutt: command not found

drakur delayed in responding, so asking you for suggestion

[jameel225]

This user has been denied support.

Ok, what am I doing wrong here? I'm not getting any emails/error messages. I first thought I had the server time wrong so I set it to run every few minutes to test...still nothing. Username and DB name are the same...is that a prob?

/usr/bin/mysqldump -hlocalhost -umyname_mybb -pxxxxxxxxxx myname_mybb | gzip > /home/myname/dbbackup/mybb.sql.gz

File is named crondb, removed .txt extension. Script is CHMOD to 755, dbbackup folder is CHMOD to 666

Path to script is

/home/myname/crondb

Hosting is shared on SharkSpace, with cPanel ver. 11.25.0-RELEASE.
OS Linux, theme x3, MySQL version 5.0.89-community, Apache version 2.2.14, cPanel Pro 1.0 (RC1)

thanks a lot working fine with me ..

[hankypanky2004]

This user has been denied support.

Is there any code to automatically remote upload backups to another FTP?

[martec]

Thanks...
work fine here...

have code to backup specific folder to mail?