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

[ladyunicornejg]

I don't mind being notified about things that aren't problems, but I want there to be some information not just "your scheduled task has been run." If it's giving me a copy of the database (which I have one of my jobs set to do), the email is fine...but "it worked" would get annoying to see on a routine basis.

Oh, on the line that tells it to email you the database, is there a way to specify a subject? I'm using gmail and it'd be nice to be able to have it take all of the backups and put them together (via a label) and then archive them so I never get bothered with notifications about unread messages just to have the backup sitting there.

[Richard.R]

any chance this could be used so the backup name could contain a date variable?

aka so it could allow multiple daily backups


like one of my friends had used

[name removed]-07-03-10.sql.gz for example

[ladyunicornejg]

any chance this could be used so the backup name could contain a date variable?

Yes. At the top of your script put:

NOW="$(date +"%m%d%Y")"

And for your backup name:

/MY/BACKUP/LOCATION/BACKUPNAME_$NOW.sql.gz

Like that?

[Richard.R]

any chance this could be used so the backup name could contain a date variable?

Yes. At the top of your script put:

NOW="$(date +"%m%d%Y")"

And for your backup name:

/MY/BACKUP/LOCATION/BACKUPNAME_$NOW.sql.gz

Like that?

Thank you! I somehow missed that post

[Tom K.]

What type of file do I save this as?

[Prentice]

just as "file" no file extension I believe.

[ladyunicornejg]

What type of file do I save this as?

just as "file" no file extension I believe.

Yep, remove the extensions entirely.

[RPicard]

I do this straight from the ACP. Am I missing something or is it the same thing?

[Tom K.]

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

[KuJoe]

I do this straight from the ACP. Am I missing something or is it the same thing?

Nope. Please read the first post in this thread.

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

Yes you can.