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

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Administrative and Maintenance Tools - vB Database Backup Pro (Lite) for vb 3.6 (https://vborg.vbsupport.ru/showthread.php?t=126925)

You can join them with a simple dos copy command.

As for the mod itself, read the notes in the config file for the various options.

Finally! Success!

I'm running a Plesk server and tried a few times to get this script running... turning safe_mode off for my domain worked. *Installed*

I have basic computer skills. I had a person install this for me.

I am running this on 3.6.8. My webhost moved me to a different platform. Now when the auto back up runs it turns off my forums. If you are logeed on you get a banner at the top that says " Alert- forums have been shut off" If you are not logged on you get a full message stating that the forums are closed while the data base is being backed up, and does not come back on it just locks itself out. I have to turn off the plugins and hook system and turn it back on to make it work or reset.

Any suggestions on how to fix this
Thanks

Disable the option that turns the forum off.

I did some looking, could you point me in the right direction on how to do that?

Thanks

Its the SHUTDOWN option in the config file.

Installed and a big thanks.

Works well

Installed, ran a manual test and it ran perfect. Will check again tomorrow morning after it runs tonight. Thanks

I did a backup yesterday and it was 163MB and just did the one here and it came out to 113MB. Any reason that there is a big difference?

When I was doing the backup via phpmyadmin I was adding drop tables and all those features.

Quote:

Originally Posted by SVTCobraLTD (Post 1502449)

I did a backup yesterday and it was 163MB and just did the one here and it came out to 113MB. Any reason that there is a big difference?

I cannot answer that as I have no access to your forums or backups.

Hi Paul.... :)

I've been backing up using this mod religiously.... thanks for posting it ...

I'm not that familiar with SQL or vBulletin internaks, so I've been wondering what I'd do if I had a complete hard disk failure on my host server.

I back up nightly using this mod with the option set to a "single file". I then move it to my local machine periodically.

Does the "database" (single file), as I understand it, contain ALL of the traditional data files, plus of all of the vbulletin code (including mods)?

In other words, if I had to setup a new server, would I simply install my licensed version of 1.67pl1 and then somehow have a techie restore this single file, which puts ALL of my threads, posts and forum (including mods) back to exactly the way it was prior to a failure?

Thanks for any feedback....

Regards,
Badger

If by mods you mean plugins then yes. Obviously it wont include any additional files or file edits that some mods use.

Quote:

Originally Posted by Paul M (Post 1509265)

If by mods you mean plugins then yes. Obviously it wont include any additional files or file edits that some mods use.

Yes, I meant "plugins" that are added by mods, but also I use mods that I have to edit various templates....

Do vBulletin templates and all of the AdminCP settings get backed up as part of this single file as well?

Thanks

Regards,
Badger

Anything stored in the database, which they all are.

I just tested this by running it manually and I got

Quote:

The Backup was completed successfully.
Done

but when I go to the backups folder... there is nothing in there. What did I do wrong?

Nevermind lol I found it now!

If I wanted to gzip this, what would I need to add to the config file to do that?

Nothing, this cannot zip the files.

Installed.
Is there a "Best Mod Ever" button I can click?

You can nominate it for MOTM, thats the closest I think.

can i install it safely on 3.6.10 pl2?

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?

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

Quote:

Originally Posted by Paul M (Post 1583064)

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...

:)

Its a setting in the config file.

Quote:

Originally Posted by Paul M (Post 1606388)

Its a setting in the config file.

ahhh...OK! thanks...;)

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.

Quote:

Originally Posted by SkyCatcher (Post 1195529)

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! :D

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

Quote:

Originally Posted by sparky5693 (Post 1455546)

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.

Quote:

Originally Posted by Reven (Post 1152290)

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)

Quote:

Originally Posted by powerful_rogue (Post 1385659)

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...

Quote:

Originally Posted by Marco van Herwaarden (Post 1594202)

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

Code:

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! :)

"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?

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.

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

<a href="https://vborg.vbsupport.ru/showthread.php?t=201319" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=201319</a>

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01930 seconds Memory Usage 1,809KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)bbcode_php_printable (10)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (31)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: