vb.org Archive
Page 17 of 64 « First 71516 17 181927 Last »
Show 40 post(s) from this thread on one page

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)

David Gillaspey 12-30-2006 07:20 PM
The config file has a setting for closing the forum (or not). Is it, in fact, necessary to close the forum during the automated backup?

Thanks.

Sincerely,

David Gillaspey

Paul M 12-30-2006 11:18 PM
If you run your backups in a quite period then no, it's not. I don't use that option.

David Gillaspey 12-31-2006 03:16 AM
OK. Thanks, Paul.

Sincerely,

David Gillaspey

Joey805 01-01-2007 08:48 PM
How does this handle the old backup files? Will it delete backups, say after a week old automatically? Or do they just keep getting placed in the backup folder and you have to go manually delete them so you don't eventually run out of disk space?

Paul M 01-01-2007 09:30 PM
You must manually delete them.

BigJohnny 01-02-2007 11:44 PM
Quote:
Originally Posted by Paul M (Post 1148739)
You must manually delete them.
aww crap.... that was the best feature of the old version.......

oh well.... i like the way this backs up better though :)

Reven 01-07-2007 12:11 AM
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.

If you want to do the same, here is what to do. Please note, though, that this will only work if you have chosen to combine all data into one SQL file and not split each table into its own file.

File: ./includes/mysqlbackup.php

FIND (lines 525 to 527):
PHP Code:
                // Free Memory
                $this->MYSQL->free_result($rows);
            } 
ADD BELOW:
PHP Code:
            // Compress file
            if(extension_loaded('zlib') && $this->COMBINE)
            {
                echo "Creating gzip file from SQL file<br />"; vbflush();

                $file = fopen($this->FILE, 'r');
                $data = fread($file, filesize($this->FILE));
                fclose($file);

                $file = gzopen($this->FILE, 'w9');
                gzwrite($file, $data);
                gzclose($file);

                rename($this->FILE, $this->FILE . '.gz');
            } 
You must also have the zlib extension compiled into PHP. Most shared hosts will have zlib installed as well as most PHP installations in general. The script will not attempt to compress the file unless zlib is installed. You can find out if you have zlib by entering the Admin CP and going to Maintenance > View PHP Info and looking in the Configuration Command section for '--with-zlib'.

Spun2U 01-07-2007 01:00 AM
Very nice!!

Thanks Paul! :D

zetetic 01-12-2007 10:03 PM
Quote:
Originally Posted by Reven
I've added a bit of code into mysqlbackup.php to compress the resultant SQL file with gzip.
Thanks!

TheFrienzNet 01-13-2007 07:10 PM
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.
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 172643155 bytes) in /usr/local/psa/home/vhosts/frienz-network.com/httpdocs/includes/mysqlbackup.php on line 534

Hmph.. I guess the memory exhausted?


All times are GMT. The time now is 01:16 PM.
Page 17 of 64 « First 71516 17 181927 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01707 seconds
  • Memory Usage 1,748KB
  • 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
  • (2)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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