Administrative and Maintenance Tools - vB Database Backup Pro (Lite) for vb 3.6

This modification is no longer available or supported.

When vb 3.5 first came out I was using this backup system on my vb 3.0 - and having nothing better to use - I converted it to work on vb 3.5 (here) and since then I have cut it down and adapted it for vb 3.6.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. A while ago David gave me permission to release my adaption, but until now I haven't got round to it. Trigunflame did mention a few months ago he was working on a new version, but nothing ever appeared.

I have stripped out much of the extra stuff that I do not use (or indeed, could not get to work). This is a simple (lite) version that does a php based dump of your database either as one file, or one file per table. It's been in use on our forum since the day 3.6 was installed.

Notes:
* I will not add anything new to this, or spend vast amounts of time supporting it.
* This is a Lite version to allow people to use the basic 3.0 backup functionality on 3.6.


History:

v2.10 : First internal version.
v2.11 : Bug fixes, some code changes.
v2.12 : Initial Public Release.

[Paul M]

Yes.

[mkdevo]

hi paul. not sure if you can answer this or not:

my host recently upgraded to php version 5.2.6. ever since then, when the backup is complete, it does not turn the forums back on automatically. i have to manually turn the forums on myself every morning.

any idea of a fix for this?

[Paul M]

The only "fix" is not to use that function, you dont need to turn the forum off.

[princeedward]

Originally Posted by Paul M

The only "fix" is not to use that function, you dont need to turn the forum off.

hi paul...it would be nice if you can you tell us exactly...which file to edit and set this function...and how to do it...coz' my site remain closed also after backup...

thanks and best regards...

[Paul M]

Its a setting in the config file.

[princeedward]

Originally Posted by Paul M

Its a setting in the config file.

ahhh...OK! thanks...

[adwade]

First of all, I want to THANK PaulM for taking the time to create this MOD and put up with all the people not reading the THREAD for excellent help information before posting that...

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

I took the time to read ALL 42 pages of this thread last night and this morning, and was quite surprised to find that all the issues seem to have been addressed.(it's just people aren't reading the answers posted here )

I too, got the above error when I first installed the MOD and tried to run a backup, but I kept reading over the various posts and figured out what I had done wrong.(i.e. I needed to use ../../backup as my path to the backup folder)

In particular, I want to THANK SkyCatcher for his l-o-n-g winded post about this problem.

Originally Posted by SkyCatcher

If I read ONE MORE POST about how to set the path correctly or receiving the

Error I'm going to explode!

Setting the correct path for Linux Distributions

I think if his post had been ANY shorter, I would still have been lost, but he kept trying to get his point across, I kept reading his post, and I finally got it!


Also wanted to THANK Sparky5693 for his info about how to create an automatic rolling 7-day backup via this MOD. Works fine!

Originally Posted by sparky5693

For those of you that wanted this to delete old backups, you can change the format it names the saved file to accomplish something close. Using the method below, the output file is named Sun, Mon, Tue... etc. By doing this, it would just overwrite the correct the 7 day old file on each save.

Want to say THANKS to Reven and his bit of code to auto gzip the resulting file.

Originally Posted by Reven

I've added a bit of code into mysqlbackup.php to compress the resultant SQL file with gzip. My database is about 35MB, and it's making it 5MB.

I added it in as he described and when it tried to run, I got an out of memory error. So, upon reading Rogue's post (in reference to a php.ini file and the php memory limit)

Originally Posted by powerful_rogue

Thanks, I'll alter to 64.
He said as he's never used vbulletin before he had no idea what directory it had to go in. I'll check over on vb.com

I too went looking for where the php.ini file goes??

Not being able to find such on vB.com, I returned to vB.org and managed to turn up this post below...

Originally Posted by Marco van Herwaarden

You can create a .htaccess with lines like the following to override some php settings (if host has set to allow this):

php_value memory_limit 32M

Alternative might be to include a line like the following in your config.php (should do the same):

PHP Code:

ini_set('memory_limit', 32 * 1024 * 1024); 


So I just wanted to add that I created an .htaccess file in my forums directory (containing only php_value memory_limit 64M) and then the backup routine ran fine and created the gzip file as well! :up:

Other posts in the thread helped me understand bits & pieces of how this MOD works and I THANK everyone for their informative input, but a special KUDOS goes out to the key players mentioned above. THANK YOU!

[kronnos]

"Note: This modification is now discontinued" - I want to use this mod to backup my database using VB 3.6. I want to use the backup when I move to a new server and upgrade to 3.8. Will I have to install thsi mod on 3.8 to be able to use the restore function?

Edit: Ok installed and ready to try it. I cant find it anywhere in my admin panel to try to backup manually, how do i do it?

[adwade]

From my understanding, no you do not need this MOD installed to restore the files to your MySQL database.

In AdminCP, under Scheduled Tasks, Scheduled Task Manager, you should have an entry entitled Database Backup. You can do a Run Now and see if it works OK for you.

[SVTCobraLTD]

Nevermind I see there is a 3.8.x version available.