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.

Bummer you had a bad expierence with them. We've been with them for about a year now and no problems. We don't really use them for much as we have a root server with our own OS installed on it. None of that Control Panel B.S. ;)

WOO! HOO! :up: :up: :up: :up:

I've installed and am able to run the backup successfully with no errors.

Question 1...does this backup only vBulletin MySQL tables or does it also backup vBadvanced, Photopost, etc. tables that populate a MySQL database? I'd love to have this back up the entire database if possible.

Question 2... If I use "vb_" as a vBulletin table prefix how do I designate that for all the tables? In your quote above is that I all I need to put a prefix in front of or do I have to list every table? Just want to make sure I do it right. :)

Thanks for a great addon!

Oh one more question...I am executing the cronbackup and it says it is completed successfully with no errors. How can I open it to make sure everything is good? Thanks again!

Please read the configuration.

By default all tables are backed up. Only if you change the option to a selective backup, is the array needed to specify particular tables.

Sorry, I did read it but it makes sense now. As long as I chose "1" as the backup type, I'm backing up all tables. Very cool. Thank you!

Thank you Trigunflame, that did the trick splendedly :up:

Now clicks install, already voted for HOTM last week :)

Im getting an error message afer i try to run the scheduled task (Step 6 in the install file).

Error: Failover was initiated for MySQLDump Binary, but dump completed successfully.

MySQL Version: 4.1.10a-standard

PHP Version: 4.3.10

Any thing would be helpful

Just quoting Trigunflame's answer below as I knew it was in this thread somewhere, hope this helps.

Oh, ok thanks for that its working now.

Upon review of the code, it appears that LOG_PATH, set in the config file, is not actually being *used*?

the alert that shows at the top of the screen for admins that says the forum is turned off does not get removed even tho the site is on.

Um, no - it is off - your users are getting the FOrum Closed full screen notice. As an admin, you can still log in.

Go turn your site back on. :)

Yes.. need to fix that.

Hi, I keep getting this:

Failover was initiated for MySQLDump Binary but backup completed successfully.

What do I need to do? I had to take the lock option off as it was giving Invalid SQL when I did it.

Sir. Read The Message.

Failover was initiated for MySQLDump Binary
but backup completed successfully.

If the dump exist in its path, then its ok. That is just informing you that the backup could not use MySQLDump, and had to resort to PHPDump.

Hey, I love this MOD, it's worked great...in fact I recently got a chance to test out its results. My forum was recently hacked and our database destroyed, we used a backup created by Database Backup Pro and restored the forum with no problems, except for an error when we tried to re-create a table named Hosted. It was used for an Image Uploader hack. We skipped the creation process of this table and the rest of the restore went fine, with no SQL Errors. After we'd completed the restore process, we opened up the forum and it appears to be stuck in a backup or something. We get the message saying that the forum is offline due to a backup in progress. The Admin Panel cannot be accessed, so I'm not sure what to do. Any help would be much appreciated.

Thanks in advance!
-acidburn0520

BTW: If you'd like to see the site it's URL is: http://www.socomcity.net/forum/index.php

In what way can you not access the ACP - I can get the login screen up ok.

If he tries to login then it takes him again to database backup warning page ;) try to login with test test. P.s : i used it just for test it is probably not a regular forum user :P

By the way did you try to change settings in backup config file. Maybe if you change turn forum off setting and it may work then.

Just a thought, but did you restore in exactly the same dirtectory? or have you changed it?

for eg: is your forum at the same address such as:

yourwebsite.com/forumname

or has it changed to

yourwebsite.com/newforumname

?

Actually...you may have it there...I believe our previous directory was labeled "forums", would that have an adverse effect?

**Edit: I'm not sure if this problem is associated with the DB Backup or what...but whenever I try to login to the Admin Panel, I get a message saying: "This user has not registered and therefore does not have a profile to view."

Yes that is possible. Also the reason the forum is locked into "Forum is down", is due to it being shutdown before the backup was initiated, which is it's intended purpose :)

As for that error message to do with profile, not sure what that would be, I will look into it after the release of Backup Pro version 2.

Yes it could well be.

It sounds like your cookie settings - if they were set for your old forum directory they will now stop working.

Try this:

> ftp to your site

> rename the directory of the forum to what it was AT THE TIME the backup was taken

> go to your site

> in your vB Admin Control Panel (ACP)

vBulletin Options > Cookies and HTTP Header Options > Path to Save Cookies

Make a note of the existing setting (for example mine is set to: /myforums/ )

Then change the setting to:

/

> click on SAVE

> ftp back to your site and name the directory to what you want it to be - for example you said it was: forums

> go back to your site and in your vB Admin Control Panel (ACP)

vBulletin Options > Cookies and HTTP Header Options > Path to Save Cookies

Then change the setting to:

/forums/ (or replace 'forums' with new directory name it is in)

> click on SAVE

----------------------

if that doesnt work let me know.

that's my point, it's not getting turned back on after the backup. this is killing my site. it was off from 4am-11am and the back up was long done. also, I even changed the option to NOT turn the forum off and it still turned it off.

this must be what is happening to me. too bad.

This is a cracking addition, although I've noticed if I backup using this, my DB backup file (uncompressed from the .gz file) is 8.43mb, and if I do a backup directly through VBB it's 10.86mb!! Any reason why the file is smaller? I looked through the raw file using Wordpad and looked at the post table, and it doesn't look like theres 1500 posts in it!!!

After further investigation, I discovered that our directory name was "forum" before we were hacked and is "forum" now. As of this moment, I cannot login to the Administration Panel nor can I login as a User...I'm totally shut out. Whenever I attempt to login I receive an error message stating: "This user has not registered and therefore does not have a profile to view." Could this be associated with an improper vbulletin restore? This was my first time having to attempt to restore vBulletin, I assumed that simply putting all the tables back into the database would bring it back to normal...but it's been quite the opposite.

how were you hacked? via your vB admin panel? via your host account?

I guess you'll need to ascertain whether or not any other damage was done and for how long it was going on (u might need an earlier restore)

Make sure you can use mysqldump from php, make sure safemode is off, wait just a bit until version 2.

Thanks, safe mode is definately off, how would I find out about the mysqldump? I have phpMyAdmin installed if anything can be found there.....