I've noticed problems with this particular code on a couple systems yesterday, will be updated soon.

1. open mysqlbackup.php
2. find $this->OPTIONS = unserialize(stripslashes($this->OPTIONS['data']));
3. replace it with :
$this->OPTIONS = unserialize($this->OPTIONS['data']);

See if u still get the fetch database options problem anymore.

It means it couldn't open the sql dump file for compression.

Noted, :)

My backup file is getting to be over 100 MB, and unfortunately I can't use the shell option, I have to use the php option.

Last night, for the first time, the backup failed to return the forums to their online state. It did so again this morning when I ran it manually.

I suspect the size is an issue - first task on my part is probably going to be moving attachments out of the database (finally) and into the file system.

But - is there any way to guarantee that if the process fails, it doesn't keep my users locked out?

It's more of an issue on browser time, after helping a guy yesterday that had backup files of "1.1gb" timeouts were occuring during the backup, the problem being that for some reason you need to send data to the browser at some intervals to keep it from disconnecting.

Even though I have code that "supposedly" is supposed to ignore browser disconnection, I will need to make mods in version 2 that send updates to the browser..

possibly . . . . . etc..

May want to turn off forum shutdown for now, until the new version.

Perhaps - but I moved my attachments out of the DB (something I've been meaning to do for a while now) and now the backup is 30mb instead of 130, and it doesn't time out anymore. :)

By the time we get big enough to hit that limit again, we'll have moved to new servers and I'll be able to have it go via shell.

Trigunflame, This looks very impressive and may be very timely for me, so in advance...thank you!

My serverhost had indicated that they would do complete backups every night. Last night my site went down and they fessed up that they had not backed up for a week. I lost all posts and new users for the past week. Fortunately it is still a relatively new and small board (200+). My question is regarding optimum backup strategy. Since the server box and drives went down last night isn't it better to have a backup on another physical harddrive somewhere in addition to or in lieu of being on the same box that your site is on? Is there a data backup service that can be purchased where your script would ftp a complete site backup to another secure (hopefully mirrored) backup server?

I may be working through moving to another host soon (fear and dread) but want to choose the optimum backup strategy now. Any input is most appreciated. And I will install this on the first of three sites and let you know how it goes.

I continue to be amazed at the collaborative spirit of incredibly talented and gifted people like yourself. Thanks. :)

We use 1and1 Internet (Dedicated servers).

They include nightly backups for all shared accounts and an FTP server account for backups for dedicated servers.

http://www.1and1.com

Never mention 1&1 again, they are close to being the worst webhost that exist in modern times.

I know, ive had em. :disappointed:

FTP Support is in the current script, but just for transferring the backup.

In version 2, I am transforming the script into a "Forum Backup Script"; so it's reach will include that of backing up the entire forum, not just the SQL File itself.