Thanks Paul,
Works perfectly.

One question. What's the benefit/advantages of saving the MySQL backup in seperate files for each table? And, that of saving them all as one file?

Thanks again...

It makes it easier to restore just one table if you need to. If you need to restore all tables then one simple copy command will join all the files into one.

works finally in that way

Paul,

It shows that this hack has been updated since I installed when I look at the thread from the forum. I have 2.12. Is there an update that you added that you forgot to tell us about in this thread or am I just dilusional?

Nothing to worry about - I simply updated some comments in the config file to (hopefully) eliminate some of the repeating questions.

I just installed this in my site -- I made a few config changes and ran my first backup. All went well...or so I thought. When the script is done running, it doesn't re-activate the forums? My forums are still closed.

If I go into vBulletin's Admin-CP to turn the forums back on, they are listed as already being on. To "Truly" reactivate the forums, I just click on "yes" again and save.

Refresh the forums, and all is well.

Is there a fix/way to get the forums to turn back on after the backup?

Thanks!

If your backup completes okay then the forums will turn themselves back on, so I would guess your backup didn't complete ok.

Well, I didn't get any errors, I have a very large .sql file in my backup directory (changed my config to create one large file vs. multiple tables). Short of wiping out my database and uploading the backup from your application -- I'd say it worked just fine.

The same thing happened with prior releases as well -- I just never said anything. I figure it would get fixed in later releases.

I can't fix something that afaik works. If the backup completes okay then the last step turns the forum on, does your cron job actually log a completed ok message ?

I assume you know you can disable the option to close the forum if you want, it's not necessary for it to be closed.

Is it possible someone could modify this script to compress the forum backups?

It's an awesome script, but after a week of 100mb backups, it takes up ALOT of space

It's either 100mb per backup without compression, or 21mb with

Would it be ok for someone to do that Paul M?