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)

Quote:

Originally Posted by Paul M (Post 1445603)

Fix the error in your config file is what you do. :)

Whatever you edited (on line 14 I would guess) has a mistake in it that you need to correct.

I didnt edit anything in that file though.

Then your file is corrupted. There is no such error in the proper copy.

Quote:

Originally Posted by Paul M (Post 1445847)

Then your file is corrupted. There is no such error in the proper copy.

I was using notepad, I used wordpad and it made it better, kept on having whacky characters for spaces.

Thanks. Great hack. Worked with no errors.

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.

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

If I start using this, and merge all sql data into the one file as mentioned, do I need to make any other changes to be able to use the backup this will create?

I had this working before, but now that we switched servers I can't figure it out to save my life.

Here is what I have as my path in the backupconfig file:
'/var/www/vhosts/mysite.com/httpdocs/back-up/'

Is this not right for a path? The folder is CHMOD to 777, so techically it should work correct?
I still get the error when I go to "Run Now" on the scheduled task manager. On the main page of the admin panel it says "Server Type - Linux Safe Mode". Does this have any reason as to why I can't get it to work? Thanks!

-Edit-
Where it says mysite.com, I actually have my forum url. I didn't want someone to mention that as a problem, lol.

Based on that, "../back-up/" should work.

Still doesn't work:

Database Backup

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

Whats weird, is it seems to make a folder for the backup inside the correct folder, but there is never anything in the folder? If it's creating a folder inside the correct folder, wouldn't that be the correct path?:confused: I can't understand why it would make a folder with the date but be empty? Thanks!

Sorry but i cant help you with server permissions, talk to your host.

Quote:

Originally Posted by Paul M (Post 1448846)

Sorry but i cant help you with server permissions, talk to your host.

So thats why its making the folder but not putting anything in it becuase its not allowing it to write?

Quote:

Originally Posted by 92GreenGT (Post 1449086)

So thats why its making the folder but not putting anything in it becuase its not allowing it to write?

Correct, your server is not allowing the write operation.

X vBulletin 3.8.12 by vBS Debug 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 (5)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01751 seconds Memory Usage 1,753KB 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 (5)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
Messages: