vb.org Archive - vB Database Backup Pro

Page 2 of 2

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)

- - vB Database Backup Pro - Convert to run on vB3.5 (https://vborg.vbsupport.ru/showthread.php?t=112304)

hilfe-forum

05-05-2006 08:42 AM

"Could not fetch database options. Shutting backup down"

any clue why i do get this emssage after starting the cronjob manually?

Paul M

05-05-2006 04:19 PM

No idea.

aleclee

05-07-2006 07:42 PM

Quote:

Originally Posted by jlaine

Don't quote me on this, but I seem to recall having the same problem when executing it manually via vbulletin's cron manager back when I was on 3.0... If you allow it to execute automatically, the problem doesn't happen.

If only I were that lucky. :(

Tralala

05-07-2006 08:01 PM

Quote:

Originally Posted by LiveWire

So far no new version has ever been released, though I believe Trigunflame is working on a completely new system.

LiveWire has his new one here; how do the two back-up systems compare?

Mitendrius

06-28-2006 03:16 PM

I m gettin this error message

Parse error: syntax error, unexpected T_VARIABLE in /is/htdocs/VBulletin/includes/mysqlbackupconfig.php on line 56

Paul M

06-28-2006 05:34 PM

Check for a typing error, possibly a missing semi-colon from the line above.

Neo_obs

06-29-2006 09:18 AM

I keep getting this error

Failover was initiated for MySQLDump Binary & An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

I checked and the folder is 777 and inside the forum folder. Do i need to turn safe mode off?

Do you think I can get some personal help as i am now clueless

Paul M

06-29-2006 04:26 PM

Yes, you will almost certainly need safe mode off to run this.

Neo_obs

06-30-2006 03:47 AM

how do i turn safe mode off? cause im not familar with linux

Paul M

06-30-2006 05:17 AM

Contact your host.

Neo_obs

07-01-2006 08:18 AM

thanks paul for this I absolutely love the idea but I cant turn off safe mode.(host wont let me) but i do appreciate your effort and love all your other hacks. Keep up the good work.

Mouse_cats

07-19-2006 06:01 AM

thanks paul installed

I||usi0nz

07-31-2006 04:12 PM

how come i see differently in cron.php i couldn't find some of those things.

Art Andrews

07-31-2006 05:19 PM

Mastercoder Paul,

Any idea on what might trigger this error after manually running the schedule:

DB Backup
Processing access : Total Rows = 0
Processing adminhelp : Total Rows = 1240

Fatal error: Call to undefined function mysqli_unbuffered_query() in /home/.griff/c17lm/themppc.com/forums/includes/class_core.php on line 1093

Paul M

07-31-2006 06:53 PM

That seems to be a php/mysql problem. You have obviously opted to use mysqli in your config, but php is complaining it can't find a mysqli function.

Mysticales

08-14-2006 05:32 PM

I have this issue.. I had the 3.0.7 version, worked BEYOND my expactions.. took only 2 mins to fully backup a 400 mb SQL database (Well.. was 400 in the backup archive)

However.. this new version after I went to 3.5.4 it took.. um.. 2 hours to do.. it made MORE files in the backup folder vs a .tz file or whatever.. it was slow etc.. Did I mess up in the conversion? Cause a cron job loop? Why did it make more files vs the 1 archive file and what could cause it to change so drastic from 2 min backup process to like 2 hours?

Paul M

08-14-2006 06:29 PM

By default, the settings in the conversion are set for one file per table, as that's what I do. Change the combine setting if you want one file. As for time, sorry, no idea.

Mysticales

08-14-2006 06:42 PM

How was it set on OLD mod? 1 file period?

I mean.. just kinda curious what I COULD be doing wrong.

Paul M

08-14-2006 06:46 PM

Like I said, change the COMBINE setting to suit what you want, it's a setting in the config file.

Mysticales

08-14-2006 11:29 PM

K, Do you think it would increase the time if it did it one by one?

I mean how big is your backup file? I know we have a large community. Just wondering if maybe I set something wrong up when I converted the 3.0x version over.

Paul M

08-14-2006 11:38 PM

My backups total about 500MB, and take about 5 mins to run.

Mysticales

08-14-2006 11:54 PM

Just to be stupid...

What Cron settings did you use? Cause all I can "think" of is that I caused it to loop... but not sure.

Im worried about retrying it again.. cause I had "Lock Tables" enabled.. meaning.. I couldnt even do ANYTHING to restore forum access after I started running it.

Paul M

08-15-2006 12:21 AM

I never use the lock tables option, nothing but trouble ....

I'm at work so I can't tell you what options I have, as I have no access to them, I'll look tomorrow.

Mysticales

08-15-2006 12:33 AM

Great! Btw.. thanks for saying "Dont lock tables"

Your guide or somewhere said it was recommended more to prevent locking.

How will this play into effect on a large forum?

rainyleaves

09-16-2006 12:40 PM

I installed like below...

Quote:

Originally Posted by Paul M

This is what happens when you try and find all the changes you made and end up missing bits - this got missed as well;

Code:

Find ;



                if (!$this->TYPE && $this->COMBINE)



Replace With ;



                if ($this->MULTIFILE == 0)

Added to file.

But I got combine error.
I mean that Combined .sql file is empty(0Byte).

And that I changed code like below!!

Quote:

Originally Posted by 99Percent

another correction I am making for mysqlbackup.php:

instead of

Code:

if (!$this->TYPE && $this->COMBINE)

it should say:

Code:

if ($this->TYPE && $this->COMBINE)

and in mysqlbackupconfig.php
instead of

Code:

  If you have selected option 0 to dump specific tables. This 

  option determines whether or not the dumps are Re-Combined

It should say:

Code:

  If you did not select option 0 to dump specific tables. This 

  option determines whether or not the dumps are Re-Combined

It worked fine!!!!

Thanks 99Percent & Paul ^^

hnjco

09-19-2006 03:00 AM

Quote:

Originally Posted by Paul M

Is the destination accessible to php (i.e. if it's outside the forum root is basdir protection stopping you). Basically that's a server permission error, not a hack error.

well, I think this is error of concern... if we are saving database backups under public_html anybody can download those. Secured way of using this script is to save the backups under root of the server or in the folders which are not accessible via web.

may be a point to look in your future release of this mod.. on the whole this mod is awsome

thanks

Paul M

09-19-2006 10:53 AM

Quote:

Originally Posted by hnjco

may be a point to look in your future release of this mod.. on the whole this mod is awsome

There is nothing to look at - this will save backups wherever it has permission to - it is up to you (the user) to have the correct permissions set-up to allow it to write where you want it to.

xcingix

12-11-2007 01:35 PM

Any plans for 3.6.8 or 3.7.0?

All times are GMT. The time now is 12:19 AM.

Page 2 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01162 seconds Memory Usage 1,780KB 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 (5)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (28)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: