vb.org Archive - Administrative and Maintenance Tools

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 (Lite) (https://vborg.vbsupport.ru/showthread.php?t=201319)

As posted many times, thats a (write) permissions error.

can you added a compression as TGZ, TAR or ZIP ????

ist fine :)

mann and tried several ways but still is not doing "help

Warning: is_file() [function.is-file]: open_basedir restriction in effect. File(../backup/2009-Mar-06) is not within the allowed path(s): ([path]/:/home/www/web1245/phptmp/:/home/www/web1245/files/:/home/www/web1245/atd/) in [path]/includes/mysqlbackup.php on line 211

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(../backup/2009-Mar-06) is not within the allowed path(s): ([path]/:/home/www/web1245/phptmp/:/home/www/web1245/files/:/home/www/web1245/atd/) in [path]/includes/mysqlbackup.php on line 246

Warning: is_dir() [function.is-dir]: open_basedir restriction in effect. File(../backup/2009-Mar-06) is not within the allowed path(s): ([path]/:/home/www/web1245/phptmp/:/home/www/web1245/files/:/home/www/web1245/atd/) in [path]/includes/mysqlbackup.php on line 257

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backup/2009-Mar-06/Forum-2009-Mar-06-aaggregate_temp_1227319800.sql) is not within the allowed path(s): ([path]/:/home/www/web1245/phptmp/:/home/www/web1245/files/:/home/www/web1245/atd/) in [path]/includes/mysqlbackup.php on line 153

Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backup/2009-Mar-06/Forum-2009-Mar-06-aaggregate_temp_1227319800.sql) is not within the allowed path(s): ([path]/:/home/www/web1245/phptmp/:/home/www/web1245/files/:/home/www/web1245/atd/) in [path]/includes/mysqlbackup.php on line 163

An error occured during the Backup : Could not open Destination SQL file for writing.

Installed. :) Nominated MOTM. ;)

Quote:

Originally Posted by bleros (Post 1761739)

mann and tried several ways but still is not doing "help

The errors tell you whats wrong - you have an open_basedir restriction in place, preventing php writing to your destination.

what need to do ??S:

Sorry, I cant help with server support, you must contact your host.

This mod nearly gave me a heart attack today, i was browsing my forums when all of a sudden a message in red comes at the top of the forums (Forums are turned off) :eek: or whatever it says. I thought i was been hacked, so went into admincp and looked at the setting for board on/off it was set to on. Took me about ten minutes to realise what had happened. :o:D
Good mod, but it didn't half give me a scare.:D

how long does it typically take for the import to complete? my attempt has been stuck on the "Importing Product, Please Wait..." page for hours without changing.

It only takes a few seconds - looks like you import hung, cancel it and try again.

hmm...I've tried it a few times with the same result.

I'am wondered: when I choose switch off the forum being DB backup, the forum is OFF for over a hour, how to solve that problem, due of DB backup progress takes no more than 5 minutes?

As I have repeated many times in the various threads, if you have problems with the option to turn the forum off, then dont use that option.

*uninstalled*
I have read this entire thread and people asked over and over about
An error occured during the Backup : Could not open Destination SQL file for writing.
The only answer given was "its a database issue". It might be hard to understand but some of us dont have the knowledge to know where to look. Maybe a hint as to what we need to look at? What might be the problem or who to contact on our side.

You didnt read very hard then, its a server (permissions) error, not a "database issue".

I cannot fix your permissions, if you dont know how, then you either contact your host, or someone who can.

Quote:

Originally Posted by Paul M (Post 1777005)

You didnt read very hard then, its a server (permissions) error, not a "database issue".

I cannot fix your permissions, if you dont know how, then you either contact your host, or someone who can.

Fair enough. So what would I say when I call them? Not trying to be a smart ass I just know how it is when you call them.
My best guess is something about the permissions on there end? I 777ed everything, maybey it didnt take. I will try this. Thank you

The most common cause (if the folders are set to 777) is open_basdir restrictions, esp on servers running Plesk.

Dear Paul,

May i just clarify with you in your previous post that you stated that you will have only 7 folders & backups.

For example, if today is monday, the script will just overwrite the current existing monday file (belonging to the previous week)?

https://vborg.vbsupport.ru/showpost....3&postcount=52

Quote:

Originally Posted by mrtroybaker (Post 1777048)

I am also a newbie.
How about doing a screenshot on this post https://vborg.vbsupport.ru/showpost....4&postcount=47 and tell your webhost that you also do want to change your folder settings to something similar like that?

Quote:

Originally Posted by sakiri (Post 1777637)

For example, if today is monday, the script will just overwrite the current existing monday file (belonging to the previous week)?

That is correct.

it works for me very well...i had little issues with it but nothing that could not be solved with patience
10x

Quote:

Originally Posted by Paul M (Post 1777753)

That is correct.

Thanks. :)

got a few questions:
where can I edit the settings?
where does the backup go to?

1. In the settings file

2. Wherever to set it, see Q1.

thanks installed and works

I had the sql issue, but my path was wrong in the config file, once I put the path in, it worked like a dream on 3.8.2, thanks.

Quote:

Originally Posted by Paul M (Post 1743836)

There is no limit built into this, so as long as your php does not timeout there is no reason you can t use it with a 2GB database.

I'm having the timeout issue. Backup stops around table "template" or "thread". Any suggestions? I'm on godaddy. I had the write error issue, too. I simply changed
$backup['DUMP_PATH'] = '../../backups/'; to
$backup['DUMP_PATH'] = './backups/';
and it worked just fine. Also change the date to small L and that works just fine, too. Thanks!

P.S. I'd love for this to work... I'm getting real tired of running mysqladmin backups! :D

Decades ? :)

I'll be happy if I'm still alive in decades to come :D

Thanks for doing this, Paul. :)

The instructions were simple enough even for a ROOKIE like me. :)

Question:

I followed instructions and uploaded the XML file.

Now what?

Is there something I need to run?

I see "Alter the cron job to suit"

not sure how I do that.

Is there some sort of .exe file I run to make sure I start backing up my DB?

And I'm guessing this is only for vbulletin, yes? Won't work with photopost pro...?

Thanks again!

Paul, when I run it... I get the following error:

An error occured during the Backup : Could not open Destination SQL file for writing.

I've checked permissions and have tried various paths.

i works! ok so now, im looking for to get another hosting and move all info of my forum to the new hosting ill looking for to get.. what exactly i have to do ? do ill lose any info ?

Do I really have to set the folders to 777? Isn´t it unsecure?

Apache needs write access to create the files, how you do that is upto you - 777 is the easiest way.

Cheers paul for this mod :)

Just for information:

For those of you who would like your sql dumps to be a little more secure, It is posible to have them save outside of your "public folder"
all you need to do is find out the full path to your sever for example mine looks something like this.

Code:

$backup['DUMP_PATH'] = '/home/fhlinux123/x/yoururl.com/user/mysqlbackups/'; //

Then just make sure the folder you defined in red is chmod 777. (you can do this through your FTP client and right clicking selecting properties if you are on a lynux sever. I dont know about any other severs.

I am far from an expert but hope this helps someone.

Regards

Madotds

When I run this cron, after a few seconds there show these lines:

Code:

Automatic Database Backup for vBulletin 3.8 



Processing access : Total Rows = 0

Processing adminhelp : Total Rows = 1748

Processing administrator : Total Rows = 4

Processing adminlog : Total Rows = 5937

Processing adminmessage : Total Rows = 3

Processing adminutil : Total Rows = 3

Processing album : Total Rows = 130

Processing albumpicture : Total Rows = 933

Processing albumupdate : Total Rows = 0

Processing announcement : Total Rows = 12

Processing announcementread : Total Rows = 1061

Processing attachment : Total Rows = 753

Processing attachmentpermission : Total Rows = 0

Processing attachmenttype : Total Rows = 10

Processing attachmentviews : Total Rows = 0

Processing automediaembed : Total Rows = 0

Processing avatar : Total Rows = 0

Processing bbcode : Total Rows = 5

Processing bookmarksite : Total Rows = 4

Processing calendar : Total Rows = 1

Processing calendarcustomfield : Total Rows = 0

Processing calendarmoderator : Total Rows = 0

Processing calendarpermission : Total Rows = 0

Processing cpsession : Total Rows = 1

Processing credits_bank : Total Rows = 2

Processing credits_lottery : Total Rows = 0

Processing credits_transactions : Total Rows = 52

Processing cron : Total Rows = 19

Processing cronlog : Total Rows = 588

Processing customavatar : Total Rows = 825

Processing customprofilepic : Total Rows = 362

Processing datastore : Total Rows = 38

Processing deletionlog : Total Rows = 1362

Processing discussion : Total Rows = 5

Processing discussionread : Total Rows = 0

Processing editlog : Total Rows = 11242

Processing event : Total Rows = 1

Processing externalcache : Total Rows = 3

Processing faq : Total Rows = 42

Processing forum : Total Rows = 206

Processing forumpermission : Total Rows = 40

Processing forumprefixset : Total Rows = 17

Processing forumread : Total Rows = 0

Processing gb_cache : Total Rows = 1099

Processing gb_media : Total Rows = 1099

Processing groupmessage : Total Rows = 20

Processing groupmessage_hash : Total Rows = 20

Processing groupread : Total Rows = 0

Processing holiday : Total Rows = 0

Processing humanverify : Total Rows = 4

Processing hvanswer : Total Rows = 2

Processing hvquestion : Total Rows = 1

Processing icon : Total Rows = 16

Processing imagecategory : Total Rows = 4

Processing imagecategorypermission : Total Rows = 0

Processing infraction : Total Rows = 825

Processing infractionban : Total Rows = 2

Processing infractiongroup : Total Rows = 0

Processing infractionlevel : Total Rows = 8

Processing language : Total Rows = 2

Processing mailqueue : Total Rows = 0

Processing moderation : Total Rows = 95

Processing moderator : Total Rows = 67

Processing moderatorlog : Total Rows = 9199

Processing nhac_song : Total Rows = 19

Processing notice : Total Rows = 1

Processing noticecriteria : Total Rows = 1

Processing noticedismissed : Total Rows = 0

Processing passwordhistory : Total Rows = 22395

Processing paymentapi : Total Rows = 7

Processing paymentinfo : Total Rows = 38

Processing paymenttransaction : Total Rows = 16

Processing phrase : Total Rows = 13155

Processing phrasetype : Total Rows = 68

Processing picture : Total Rows = 933

Processing picturecomment : Total Rows = 139

Processing picturecomment_hash : Total Rows = 193

Processing plugin : Total Rows = 144

Processing pm : Total Rows = 32552

Processing pmreceipt : Total Rows = 9

Processing pmtext : Total Rows = 26650

Processing pmthrottle : Total Rows = 0

Processing podcast : Total Rows = 0

Processing podcastitem : Total Rows = 0

Processing poll : Total Rows = 61

Processing pollvote : Total Rows = 3716

Processing post : Total Rows = 146373

Processing post_thanks : Total Rows = 306367

Processing postedithistory : Total Rows = 0

Processing posthash : Total Rows = 0

Processing postindex : Total Rows = 1204613

So I think I havent backuped all tables?
Need your help, Paul!

I hade the same problem. But then the cron job automatically makes an backup all vb_ prefixes are backed up.

Quote:

Originally Posted by Kolbi (Post 1799915)

I hade the same problem. But then the cron job automatically makes an backup all vb_ prefixes are backed up.

I still cant backup.:confused:

How big is your database? (sorry for my english :) i?m german...)

Quote:

Originally Posted by Kolbi (Post 1801105)

How big is your database? (sorry for my english :) i?m german...)

about 600mb, i'm czech :)

How can i change the time/frequency the backups are made?

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01578 seconds Memory Usage 1,831KB 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_code_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)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: