Installed. Works like a charm just like the 3.6.xx version.

Hi Paul,

i recently updated my board to 3.7 (2 weeks ago), before i had the 3.6 version installed.
Now the last 2 days, my board doens't come online anymore after the backup.

Should i upgrade to this version (are there changes with the 3.6v?) or what would be the problem?

I haven't change a thing....

Turn off the board close option.

Works awesome! Thanks for this!

Hi Paul,

Is this meant to close your forums? Reason I ask, is because when I tested it out before, it didn't close my forums. I clicked "Run Now".

Do I just set this too 1? :

Can any problems arise from having your forum stay open, or is it best to close them?

Also, how do we get it to save as one .sql file, and not a .sql file for each table?

Yes, you would set that to 1. I dont close my forums.

As i recall, for one file you would set the combine option to 1.

I see. Thanks, Paul!

I've installed this and while it's running quite happily on some of my sites, it isn't working on others.

It appears that it dies and skips the rest of the table after 1.9GB even if the tables are backed up individually. With a 10GB post table on one site and a 2.5GB post table on another this isn't therefore giving the expected results.

Is there a way to get it to handle large tables correctly, or do I need to give up on it as a bad job on these particular sites? The whole reason I installed it is to save me having to log into SSH every day to take backups, but it is looking like it isn't going to stop my need for that at the moment.

As I recall, this has a 1 hour script timeout so maybe you are exceeding that. Try upping it to 2 hours. There are no size restrictions in this other than ones the OS you are running may apply.

I've modified this script to create a folder per day, while it creates a backup file in the folder every 6 hours. How is this different? Well, instead of it rewriting the file, it'll make a new one, thus a 6 hour cron per day gives around 4 backup files per folder. I did this by forcing the file name to be a time, instead of a date, as well as

Thus it just creates a new file for each time that a new backup is made, in one folder per day (since the folder name is just the date and not the time, thus it doesn't create another one). How does this help? Well, it helps keep backups of times where the forums could be up and running great, but prevent backing up or replacing a backup of when the forums were hacked or whatever.

So, lets say your forum was backed up. Awesome! Now, sometime before the next backup, a hacker or someone you thought you could trust goes crazy and deletes all posts, users, or just generally messes up the software data. Well, unless caught before the next backup and the forums are running fine enough to use crons, then it'll replace the old backup file with the screwed up one. Thus, the backup won't help in that situation...

So, I just have it do a 6 hour backup per day, thus around 4 backup files in one daily folder. Anyways, just wanted to explain this, and am willing to help or re-release my modified version that does just this. However, I would need permission first, so that's why I'm posting.

If not, oh well. Thanks for releasing a killer mod! Definitely making me feel at ease :D

I get the error:

Make sure the path to store the backups is correct (must create a all folders in the path, if not already created)

First of all - thank you very much for providing this useful enhancement! :)

Regarding the timeouts I wonder about the flaweless function of this tool within my server-restrictions: as my provider told me, there is a timeout of 30 seconds regarding perl- and php-sripts. My database is growing beyond 30 mbs, maybe that could provoke an interruption of the backup-tool with an incomplete dump?

This should override the 30 second default timeout in php.

How different is this from the 3.6 version that I currently run?

Minor changes, no need to change it if the 3.6 version is running ok for you.

Very good. I'll mark this one as installed though.

I love this mod. It has made my life much easier.

Paul, just to clarify, and more for my sake... does this have the capability to back up to db on my server automatically and dump thie old one? Where does it save? In what format does it save? Sorry if this had been answered but I couldnt find the exact issues.

thanks

This simply backs up your database to somewhere on your server according to the cron timer..

You tell it which file it writes to. Mine goes into a file above the public area so nobody can access it but me...

It has no ability to upload the db, you would have to do that through more mundane means.

I have a db question in regards to this mod and wonder if someone could answer it in PM?

It never finishes for me, it always get stuck and never fully completes.. how come?

Its not really possible for me to know the answer to that.

this script stops after 30 seconds.

Perhaps you are running in safe mode ?

thanks alot Paul M for your great mods,,

1. How does it work ? snapshots please?
My database experiences heavy load,
2.so does this hack backup the database in batches for example and then compliled in one file or even each table in one file ?
3. Does it work with very large databases ?
4. Does it le me choose the folder and file name ?

You can choose to have all your tables saved separately or one combined file..
You choose the destination of the saved file..
It crashes 25% of the time when I'm running it on my forum (the complete db is about 400mb)..

If it crashes 25% of the time then you have a local issue. My db file is over 1GB and it never crashes.

Yes, i am running in safe mod. My hosting provider cant disable safe mod.

Then you are screwed, there is no way to overide the 30 second timeout in safe mode.

Hi,
what i do for set setting vb Backup?
Time,data and ... . ?

Very good master:) Thanks for hack

Thanks for this, just installed.

I was wondering, does it delete backups after a certain period of time? Or does it continually create backup and you need to manually delete them?

Thanks :)

It does not delete backups (unless they are the same name as the new one its creating, in which case it will overwrite).

Thanks you for the reply Paul. :)

Thanks Paul!

anyone know the path to outside public html? i have errors cannot write file, i have set the backups dir to > home/mysitecom/backups and set the chmod to 777

its usually better to use a relative path, like ../../backups/

ahh right thanks, thats 'backups' within public html? - well ok then :)

i should of used outside pub_html to save space... its not writing a file for me whatever dir i try or do... should of worked the first time, i'll read through this thread and see if i can find a solutions, cheers

EDIT, the solution for me was to write these databases outside of public_html, security and space saving...

The people having problems are forgetting the forward slash

/home/mysitecom/backups/

cheers

one last thing... to make it perfect this hack should gzip the output file and maybe have a setting to keep backups for a defined time period, say...going back 3 weeks or 2 days or whatever :)

cheers