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?

Sorry, I won't support that - the problem with compression is that there isn't a common method that will work across all platforms - some servers will use gzip, others winzip. That's why it's not part of this lite version. (JFYI - My [daily] backups are 600MB).

Heh is that on the cable forum? I post there as AdamD

Yea, I can understand that.

Will you be bringing out a "non lite" version?
I'd pay for that, heh

Yes, that's CF's backups. :)

Nope, I won't be doing a non lite version. I don't have the time to write/support paid modifications.

I'm having the same error as the earlier poster. The backup appears to be completed ok (no error messages in log), yet my forums are not turned back on afterwards. Forums are giving out a "forum closed" message to any non-administrators, but when I look in the admincp, the forums are already listed as "on". By just resaving with that setting, forums pop back on and all is well.

FWIW, it was working fine for a week or two (backups each morning) until I noticed this behavior for the first time yesterday morning (when my page-monitoring service started to squawk at me every 5 minutes).

I know I can disable the forums being turned off, but nevertheless it appears that there may be some issue with the current code, at least as applied to my own forum.

Code cannot work, and then not work, something must have changed.

Also, same question as I asked the other person - does your cron job actually log a completed ok message ?

Installed!

Thank you, I lost my database not too long ago due to a hosting problem. And I had no relevant backup that worked.

Works great. :)

I'm getting the same thing as well, it finishes, but leaves the forum closed, even though the admin panel says "on"

The log says

37074 Database Backup 11:04, 24th Oct 2006 MySQL Backup was completed successfully with no errors.

Sorry, but it works fine for me, I cannot replicate such an occurance, nor can I see any way for it to happen. I suggest you just don't use that option.

Thanks Paul. Installed and working great! ;)

Any ideas why I get this message every time I run it? Plus I dont have an option in the control panel anywhere for some reason to set my options, I have installed it correctly. Thanks

Error:

An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

The message means either you have set the backup folder incorrectly, or the permissions on it are wrong. There are no ACP options for this, just the supplied config file.

How do I know where it is trying to back up to then? I dont see an option anywhere stating where it would go, so I can check the permissions =) Thanks

The setting is in the [supplied] config file.

Any other ideas? I edited the correct backup directory, and I still get the same message...The DIR is also chmod 777

I tried

/domains/MYWEBSITE.net/public_html/backup/nightly/

as well as

/backup/nightly/

Try using a relative path, like ../backup/nightly/

Tried that as well, chmod to 777, still the same result

Hey Paul, I'm getting this error when I try to run a backup manually.

Database Backup

Processing access : Total Rows = 0
Processing adminhelp : Total Rows = 1394

Fatal error: Call to undefined function mysqli_unbuffered_query() in /home/horizon/public_html/includes/class_core.php on line 1066


Any suggestions? :) Thanks a lot.
David

Edit: I see it also didn't turn the forum back on either.

That's a bug in vbulletin.

There is no such php function as mysqli_unbuffered_query().

The only thing you can do is use mysql, not mysqli.

It didn't turn the forum on because it failed.

Hi Paul,

How can I use MySQL instead of MySQLi if I already specified MySQLi in the vBulletin config file when I setup vB?

Just change (edit) the config file.

Hmm I went into config.php in the includes folder and changed mysqli (first option) to mysql, saved and now when I load the board, I just get a completely blank white page...

Any idea how I can fix this?

Thanks Paul,

David

Sounds to me like you may have made an editing error, so the config file isn't loading.

I just changed mysqli to mysql. I changed it back to mysqli and everything came up normally.

Is there anything I have to do aside from changing mysqli to mysql?

Sorry to be a noob

i have a windows server and have created a folder called backups

c:\backups

what would the path be needed to save in this folde and not the forum folder

tia

"c:\backups\"

However, php may not have permission to write to it.

Any more ideas on this? It still will not work =( Thanks

Sorry, I can't help you with permission problems on your server. Speak to your host.

An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

Refer to post 117

I got it working. For some reason it had to have a . in front of /backup/nightly, like ./backup/nightly/ no clue what the . means but it worked