Thread: Administrative and Maintenance Tools - vBulletin Cron Based Database Backup
View Single Post
  #775  
Old 12-08-2012, 04:28 PM
Gary_Oak Gary_Oak is offline
 
Join Date: Oct 2012
Posts: 28
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by djbaxter View Post
Glad to hear it's working now.

Two more hints:

1. Combine Files = Yes
2. Block Processing = Yes
3. If you have Gzip enabled on your server (most do), I'd recommend GZip Files = Yes

This will make smaller files.

Remember! Old backup files once created are NOT deleted. You need to go into your site via FTP or SSH and delete old backups periodically or you'll eventually fill up the disk.
As am I, I've always loved the vBulletin backup system but I'm not that skilled when it comes to this kind of stuff yet.

I had already done all of those except the Gzip one because I wasn't sure if it would work and I wasn't sure I would need it, but yeah I'll go ahead and set it Yes as well.

I realized that as I was studying up on how vBulletin works some months ago and then as I was deleting some things off my server the past few days. I thought my host gave me unlimited disc space, but what use would I have for extremely old backups anyway? Thanks!

Quote:
Originally Posted by djbaxter View Post
  1. Create a NEW EMPTY database - because you don't want to overwrite your actual forum database with old data.
  2. Using FTP, download one of the backups to your home computer.
  3. Go into phpMyAdmin and click on Import and follow instructions there.
Okay I will try that out, thank you again! To create a new empty database, you go into the cPanel and into MySQL Databases and just create a new database and/or assign a user to it, correct?

Edit;

Quote:
Originally Posted by smirkley View Post
Rereading the last few pages it seems we have a common theme here.

The manual run of the cron produces expected output where you expect them in your settings.

But the automatic cron trigger produces in cron logs "Automatic Database Backup for vBulletin - Backup Completed Successfully" yet succesful doesnt mean any file shows up where it should. Tested on multiple times settings.

Running on : vb 4.2.0 Patch Level 3
I haven't tested the automatic backup yet, as I have it set to 5:30 PM my time and it's 11:30 AM my time right now. I'll check it this evening though, and get back to you as to whether or not it is working for me. I have vB 4.2.0 Patch Level 2, now I can upgrade because I can backup my database. Lol
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02900 seconds
  • Memory Usage 1,769KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete