Daily Auto-Dump of the database mod

[Smitty]

Is there a mod that will auto dump my YabbSE database on a regular basis? The reason I'm looking for this, is because about 3 weeks ago, I lost everything in my database and had to rebuild my board that had over 4000 post. I'm away from home alot and need a mod that will dump the database everyday to a specified directory on my site, just incase the board goes haywire, I can do a restore.


I'm using the supermod version of YabbSE, and I know I have the option of letting the Global Moderators do the dump on a manual basis, but Auto-Dump would be cool to have.

Thanks in advance

[Shadow's Pawn]

This wouldn't work.

You would have to instead write a script on your own machine to connect to the board and do a dump, but the board would not be able to auto-dump to your computer.

[Smitty]

I think it can be done. I wouldn't want it to be written to my computer, instead write it to a directory on my web-server.


I have a guestbook on my site that is written in perl, and it does a auto backup of my book and emails it to me, so I figure one could be written in php to do the same for a yabb board.

[Shadow's Pawn]

You could back it up to the server, sure, but you wouldn't be able to email it to yourself or anything like that automatically.  The dump would just be too large, unless your board is really small.

[Smitty]

Is there a mod that will back it up auto to a web server? I don't want it emailed to me, just back it up to my webserver

[Coyote]

Yeah this can be done,

You need to write a bash script that dumps the DB to a file. and then send you an email to say that its been backed up

To automate it, you will have to se up something called a Cron Job (aka crontab)

I dont have time to post specific details at the moment, but thought you might like the above info - at least its a start for you

[Coyote]

Create a file called daily.sh

Code Select Expand


#!/bin/sh
cd /home/username
rm mybackup.sql
mysqldump --opt -p{DBpassword} -u {DBusername} -B {databaseName} > mybackup.sql
cat msg.txt | /usr/lib/sendmail -t


Create another file called msg.txt

Code Select Expand


From: [email protected]
To: [email protected], [email protected]
Subject: Daily Backup Routine

Begin your message here. It is very important to leave a blank line before you start the body of your message.
The Backup Routine has been executed


Place them both above your public_html directory - in your user directory.

You then need to use Control Panel to setup a cron job with these paremeters.... Feel free to change them, but they work out to be 2am everyday when its less busy.

Minute: 0
Hour: 2
Day: *
Month: *
Weekday: *

So it looks like this...........

Code Select Expand

0 2 * * * {username} /home/username/daily.sh


I havent tested this, but will do over the next couple of days.

I hope it helps - but please check with your host before using this script, as messing with Cron Jobs can cause the server to go dizzy (if you(or I)get it wrong!)

Oh, you obviously have to change the username/dbnames in the scripts and also take out the curly brackets

And CHMOD the bash script to 755.

Good luck

Tony,

[Smitty]

Cool, I'll play around with it and see what I can get done. Thanks for the help