vBulletin Cron Based Database Backup

[Robru]

if you can use php.ini create one in your admincp and make the amount of mem = 8MB and increase by 4 (12, 16, 20, etc) until you stop getting this message.
Thanks for your advise, a higher Mem increase to 16 do the trick, it works well now :)

[oddmud]

Thanks this is great, I wasn't backing up at all until now. LOL!!!

[dmlysiak]

I have a problem when I go to the forum page is displayed to me


Processing access (No Row Data)<br />Processing action (No Row Data)<br />Processing ad (No Row Data)<br />Processing adcriteria (No Row Data)<br />Processing adminhelp (1670) : Processed 1670 Rows in 0.053 Seconds <br />Processing administrator (5) : Processed 5 Rows in 0.001 Seconds <br />Processing adminlog (7161) : Processed 7161 Rows in 0.228 Seconds <br />Processing adminmessage (1) : Processed 1 Rows in 0.001 Seconds <br />Processing adminutil (2) : Processed 2 Rows in 0 Seconds <br />Processing album (No Row Data)<br />Processing albumupdate (No Row Data)<br />Processing announcement (No Row Data)<br />Processing announcementread (No Row Data)<br />Processing attachment (No Row Data)<br />Processing attachmentcategory (No Row Data)<br />Processing attachmentcategoryuser (No Row Data)<br />Processing attachmentpermission (No Row Data)<br />Processing attachmenttype (11) : Processed 11 Rows in 0.001 Seconds <br />Processing attachmentviews (No Row Data)<br />Processing avatar (No Row Data)<br />Processing bbcode (1) : Processed 1 Rows in 0 Seconds <br />Processing bbcode_video (7) : Processed 7 Rows in 0.001 Seconds <br />Processing block (2) : Processed 2 Rows in 0.001 Seconds <br />Processing blockconfig (5) : Processed 5 Rows in 0 Seconds <br />Processing blocktype (5) : Processed 5 Rows in 0.001 Seconds <br />Processing bookmarksite (4) : Processed 4 Rows in 0.001 Seconds <br />Processing cache (6) : Processed 6 Rows in 0.001 Seconds <br />Processing cacheevent (3) : Processed 3 Rows in 0 Seconds <br />Processing calendar (1) : Processed 1 Rows in 0 Seconds <br />Processing calendarcustomfield (No Row Data)<br />Processing calendarmoderator (No Row Data)<br />Processing calendarpermission (No Row Data)<br />Processing contentpriority (No Row Data)<br />Processing contenttype (14) : Processed 14 Rows in 0.001 Seconds <br />Processing cpsession (2) : Processed 2 Rows in 0 Seconds <br />Processing cron (21) : Processed 21 Rows in 0.001 Seconds <br />Processing cronlog (242) : Processed 242 Rows in 0.007 Seconds <br />Processing customavatar (3) : Processed 3 Rows in 0.001 Seconds <br />Processing customprofilepic (2) : Processed 2 Rows in 0 Seconds <br />Processing datastore (35) : Processed 35 Rows in 0.008 Seconds <br />Processing deletionlog (No Row Data)<br />Processing discussion (No Row Data)<br />Processing discussionread (No Row Data)<br />Processing editlog (1) : Processed 1 Rows in 0 Seconds <br />Processing event (No Row Data)<br />Processing externalcache (1) : Processed 1 Rows in 0.002 Seconds <br />Processing faq (42) : Processed 42 Rows in 0.002 Seconds <br />Processing filedata (No Row Data)<br />Processing forum (153) : Processed 153 Rows in 0.017 Seconds <br />Processing forumpermission (14) : Processed 14 Rows in 0.001 Seconds <br />Processing forumprefixset (1) : Processed 1 Rows in 0 Seconds <br />Processing forumread (No Row Data)<br />Processing groupmessage (No Row Data)<br />Processing groupmessage_hash (No Row Data)<br />Processing groupread (No Row Data)<br />Processing holiday (No Row Data)<br />Processing humanverify (No Row Data)<br />Processing hvanswer (No Row Data)<br />Processing hvquestion (No Row Data)<br />Processing icon (14) : Processed 14 Rows in 0.001 Seconds <br />Processing imagecategory (3) : Processed 3 Rows in 0.001 Seconds <br />Processing imagecategorypermission (No Row Data)<br />Processing indexqueue (10) : Processed 10 Rows in 0.001 Seconds <br />Processing infraction (5) : Processed 5 Rows in 0.001 Seconds <br />Processing infractionban (2) : Processed 2 Rows in 0 Seconds <br />Processing infractiongroup (No Row Data)<br />Processing infractionlevel (7) : Processed 7 Rows in 0.001 Seconds <br />Processing language (2) : Processed 2 Rows in 0.033 Seconds <br />Processing linkback (No Row Data)<br />Processing mailqueue (No Row Data)<br />Processing moderation (No Row Data)<br />Processing moderator (2) : Processed 2 Rows in 0 Seconds <br />Processing moderatorlog (261) : Processed 261 Rows in 0.016 Seconds <br />Processing notice (3) : Processed 3 Rows in 0.001 Seconds <br />Processing noticecriteria (4) : Processed 4 Rows in 0 Seconds <br />Processing noticedismissed (1) : Processed 1 Rows in 0 Seconds <br />Processing package (1) : Processed 1 Rows in 0 Seconds <br />Processing passwordhistory (67) : Processed 67 Rows in 0.002 Seconds <br />Processing paymentapi (7) : Processed 7 Rows in 0.001 Seconds <br />Processing paymentinfo (No Row Data)<br />Processing paymenttransaction (No Row Data)<br />Processing phrase (16909) : Processed 16909 Rows in 0.683 Seconds <br />Processing phrasetype (72) : Processed 72 Rows in 0.003 Seconds <br />Processing picturecomment (No Row Data)<br />Processing picturecomment_hash (No Row Data)<br />Processing picturelegacy (No Row Data)<br />Processing plugin (82) : Processed 82 Rows in 0.004 Seconds <br />Processing pm (18) : Processed 18 Rows in 0.001 Seconds <br />Processing pmreceipt (2) : Processed 2 Rows in 0.001 Seconds <br />Processing pmtext (16) : Processed 16 Rows in 0.001 Seconds <br />Processing pmthrottle (No Row Data)<br />Processing podcast (No Row Data)<br />Processing podcastitem (No Row Data)<br />Processing poll (No Row Data)<br />Processing pollvote (No Row Data)<br />Processing post (71) : Processed 71 Rows in 0.009 Seconds <br />Processing postedithistory (2) : Processed 2 Rows in 0.001 Seconds <br />Processing posthash (4) : Processed 4 Rows in 0.008 Seconds <br />Processing postlog (16) : Processed 16 Rows in 0.001 Seconds <br />Processing postparsed (39) : Processed 39 Rows in 0.005 Seconds <br />Processing prefix (10) : Processed 10 Rows in 0.001 Seconds <br />Processing prefixpermission (No Row Data)<br />Processing prefixset (1) : Processed 1 Rows in 0 Seconds <br />Processing product (5) : Processed 5 Rows in 0.001 Seconds <br />Processing productcode (11) : Processed 11 Rows in 0.001 Seconds <br />Processing productdependency (1) : Processed 1 Rows in 0 Seconds <br />Processing profileblockprivacy (No Row Data)<br />Processing profilefield (4) : Processed 4 Rows in 0.001 Seconds <br />Processing profilefieldcategory (No Row Data)<br />Processing profilevisitor (64) : Processed 64 Rows in 0.002 Seconds <br />Processing ranks (5) : Processed 5 Rows in 0.001 Seconds <br />Processing reminder (No Row Data)<br />Processing reputation (1) : Processed 1 Rows in 0 Seconds <br />Processing reputationlevel (15) : Processed 15 Rows in 0.001 Seconds <br />Processing route (No Row Data)<br />Processing rssfeed (No Row Data)<br />Processing rsslog (No Row Data)<br />Processing searchcore (224) : Processed 224 Rows in 0.009 Seconds <br />Processing searchcore_text (242) : Processed 242 Rows in 0.01 Seconds <br />Processing searchgroup (220) : Processed 220 Rows in 0.007 Seconds <br />Processing searchgroup_text (234) : Processed 234 Rows in 0.005 Seconds <br />Processing searchlog (17) : Processed 17 Rows in 0.002 Seconds <br />Processing session (5) : Processed 5 Rows in 0.001 Seconds <br />Processing setting (470) : Processed 470 Rows in 0.022 Seconds <br />Processing settinggroup (55) : Processed 55 Rows in 0.002 Seconds <br />Processing sigparsed (No Row Data)<br />Processing sigpic (No Row Data)<br />Processing smilie (11) : Processed 11 Rows in 0.001 Seconds <br />Processing socialgroup (No Row Data)<br />Processing socialgroupcategory (1) : Processed 1 Rows in 0 Seconds <br />Processing socialgroupicon (No Row Data)<br />Processing socialgroupmember (No Row Data)<br />Processing spamlog (No Row Data)<br />Processing stats (75) : Processed 75 Rows in 0.002 Seconds <br />Processing strikes (No Row Data)<br />Processing style (2) : Processed 2 Rows in 0.006 Seconds <br />Processing stylevar (715) : Processed 715 Rows in 0.02 Seconds <br />Processing stylevardfn (441) : Processed 441 Rows in 0.019 Seconds <br />Processing subscribediscussion (No Row Data)<br />Processing subscribeevent (No Row Data)<br />Processing subscribeforum (1) : Processed 1 Rows in 0 Seconds <br />Processing subscribegroup (No Row Data)<br />Processing subscribethread (No Row Data)<br />Processing subscription (No Row Data)<br />Processing subscriptionlog (No Row Data)<br />Processing subscriptionpermission (No Row Data)<br />Processing tachyforumcounter (No Row Data)<br />Processing tachyforumpost (No Row Data)<br />Processing tachythreadcounter (No Row Data)<br />Processing tachythreadpost (No Row Data)<br />Processing tag (37) : Processed 37 Rows in 0.001 Seconds <br />Processing tagcontent (64) : Processed 64 Rows in 0.002 Seconds <br />Processing tagsearch (49) : Processed 49 Rows in 0.001 Seconds <br />Processing template (1456) : Processed 1456 Rows in 0.283 Seconds <br />Processing templatehistory (2) : Processed 2 Rows in 0.001 Seconds <br />Processing templatemerge (1) : Processed 1 Rows in 0 Seconds <br />Processing thread (67) : Processed 67 Rows in 0.008 Seconds <br />Processing thread_serviceupdate (No Row Data)<br />Processing threadrate (No Row Data)<br />Processing threadread (No Row Data)<br />Processing threadredirect (No Row Data)<br />Processing threadviews (10) : Processed 10 Rows in 0 Seconds <br />Processing upgradelog (10) : Processed 10 Rows in 0.001 Seconds <br />Processing user (40) : Processed 40 Rows in 0.009 Seconds <br />Processing useractivation (2) : Processed 2 Rows in 0.001 Seconds <br />Processing userban (No Row Data)<br />Processing userchangelog (69) : Processed 69 Rows in 0.003 Seconds <br />Processing usercss (No Row Data)<br />Processing usercsscache (No Row Data)<br />Processing userfield (40) : Processed 40 Rows in 0.001 Seconds <br />Processing usergroup (11) : Processed 11 Rows in 0.002 Seconds <br />Processing usergroupleader (No Row Data)<br />Processing usergrouprequest (No Row Data)<br />Processing userlist (19) : Processed 19 Rows in 0.001 Seconds <br />Processing usernote (No Row Data)<br />Processing userpromotion (No Row Data)<br />Processing usertextfield (40) : Processed 40 Rows in 0.001 Seconds <br />Processing usertitle (No Row Data)<br />Processing vbseo_blacklist (1) : Processed 1 Rows in 0 Seconds <br />Processing vbseo_linkback (1) : Processed 1 Rows in 0 Seconds <br />Processing vbseo_serviceupdate (139) : Processed 139 Rows in 0.003 Seconds <br />Processing visitormessage (2) : Processed 2 Rows in 0.001 Seconds <br />Processing visitormessage_hash (No Row Data)<br /><br />Processed Database in 1.537 seconds<br /><br /><i>[Compressing Combined File]</i> : Processed File Compression in 0.964 seconds<br /><br />Backup Completed Successfully


vb 4.0.5
happens at 23.00 hours, when the cron to do backups
* 23 * * * Automatic Database Backup for vBulletin

who help me?

[sas forum]

I installed, chose my folder and then ran the task manager and got an email showing me a DB error. After processing all the tables the page said:

Processed Database in 170.889 seconds

[Compressing Combined File] : Processed File Compression in 27.256 seconds

Backup Completed Successfully

And then:

Database error in vBulletin 4.0.5:

Database error in vBulletin 4.0.5:

Invalid SQL:

INSERT INTO cronlog
(varname, dateline, description, type)
VALUES
('cbu_crontask',
#########,
'Backup Completed Successfully',
0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, July 28th 2010 @ 07:51:13 PM
Error Date : Wednesday, July 28th 2010 @ 07:54:32 PM
Script : http://www.website.com/forum/admincp/cronadmin.php?do=runcron&cronid=20
Referrer : http://www.website.com/forum/admincp/cronadmin.php?do=modify
IP Address : ##.###.###.##
Username : username
Classname : vB_Database
MySQL Version :



From what I could tell, the file did not save in the specified folder either.

Any help would be great. This looks like a welcome addition to my site. Thanks for the work put into this.

[Paul M]

The file must have saved somewhere, otherwise you would not get the timing messages.

The database error means vbulletin failed to insert the completed ok message in the cronlog - the actual error suggests the database connection of the session running the task timed out.

[Bigstack]

How do I manually run this? (To test if it's working)

go into Scheduled Task Manager and hit run now

[GONUMBER6]

Installed. When I click 'run now' nothing happens tho. It just sits there and does not do anything? :(

I created a folder for backups like this, and this is how I entered it in the cron job. Do I need to add httpdocs, 2 dots, one dot? ./forums/backups/

This is the full path it is in (below),so please direct me? thx :)

englishbulldognews.com/httpdocs/forums/backups/

I am sure it is just an error in how I have entered the folder path, but I do not want to mess with it too much before I mess up my forum LOL

[Paul M]

If it does nothing at all you have some sort of installation issue i would guess, it will always attempt to run, even if it then gives an error.

[GONUMBER6]

hmmm, that is strange. I uplaoded the files, but I will reupload again tomorrow and see what happens. thx

Yes, all it says when I hit 'run now' is 'Automatic database backup for vbulletin.'

But nothing else happens....

[GoTTi]

will this work with 3.8.x?

[GoTTi]

geting error

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

[GONUMBER6]

Yes, I missed installing 1 file. Works like a charm, and took 17 seconds!

Thank you SOOO much, nominated for MOTM.

[begin]

Installed . Thank you !

[cherylferraro]

This is a great time saver. Thanks for sharing it.

[onehost]

Paul,

I just want to say, this backup does not mean much sitting on the server
if the server crashes and they can not retrieve their own backup for
some reason, how about an email option to send us an email attachment
of the database when it is finished running?

very nice though...

Processed Database in 1.714 seconds
Backup Completed Successfully

Yes it would be great if you added an email option, as I have been manually saving the DB
daily to my drive, but relying on the server to hold the backup could be risky if
anything actually happens to the server...maybe multi backup...one saved
in backup, and the other emailed...that would be sweet.

I do have a question, when I did a manual backup of mysql vb it was
only 1,800kb but when the autoback run, it is 13,000+KB....
what am i missing here?

[onehost]

I do not think this is working correctly, ever since I installed it, it seems to be
making the same backup over and over with the same KB, and instead
of creating a new backup file, it just over-writes the one that was there
before. I always backup using a different name just incase there are
errors produced in the first, so I always have a new file name for a
new backup...

[Paul M]

It works correctly, but I cannot comment on how you have set it up on your server.

If your are creating the same filename each time then yes, it will overwrite any previous copy with the same name, that would need a very strange date setting.

[Krusty1231]

Works for me on 4.0.6.

Processed Database in 3.74 seconds

Backup Completed Successfully
Done

Thank you for this.

[Taurus MFF]

works beautifully, simple installation, gzip is a huge plus!

thanks for the great add on Paul, installed and motm vote!

[FASEOFMARS]

well i have installed this "automatic" backup system..

but how do i tell it when to make a backup??? im not seeing them options..

[FASEOFMARS]

it says all the options are in vbulletin options > vbulletin automatic backup...

but i see no option to backup the database! just the backup path ect..

how do i initiate the backup?

[ProFifaLeagues]

Its done each day by a cron job mate

[FASEOFMARS]

k ill see how it goes then.. thanks...

[FASEOFMARS]

im hearing mentions of a "run now" button?

[FASEOFMARS]

and comments like these:

"Processed Database in 3.74 seconds

Backup Completed Successfully
Done"

were would it display this information???

[FASEOFMARS]

nevermind i found it in scheduled tasks....

[FASEOFMARS]

right i have another question..

i need to allow write access to the backup directory..

but if i allow read & write access to everyone it could compromise the site...

any idea's on a safe way to allow write access for apache?

[Paul M]

Either find out what userid apache is using and just allow it access (not sure how easy that is in linux), or use a directory outside of the web root, so only you have access via ftp.

[Jaxel]

Okay... I got several questions...

When I "Run Now", it takes 237 seconds, thats a little under 4 minutes. During this time, is my forum closed? The old version of this mod would close my forum, and I liked that. I would like to have my tables locked while this is running; but if the forum is not closed, then that would create an issue...

Next, the file it created was 415mb in size... according to PhpMyAdmin, my database is 490mb in size; why is there a difference? I am not using GZIP. If I use GZIP, it brings the file down to 108mb... wow...

If I enable "Repair Tables" option, it adds a whopping 12 minutes to the backup process! Is there a reason why repair and optimize would take this long? Is there a reason NOT to auto repair and optimize with each backup? Usually doing an R&P will remove 100mb of overhead from the database. (I backup once a week)

And is there a reason NOT to use blocked backups? It just seems like a great "in case shit happens" feature.

[Paul M]

1. No, this does not close the forum. That option was removed as it was unreliable (on re-opening).

2. Database size and backup size are completely different things. Gzip will reduce the size greatly.

3. You do not normally need to use those options, in fact, if you did repairs daily it could possibly be detremental.

4. There is no reason not to use them if you prefer it - on most systems it will make very little difference.

[parks72]

thank you..............

[ComoEstaEso-com]

Hello,
Installed, and everything working fine.

I would like to change the run-time from 6:00am to something earlier... like 3:00am.
I realize it is a cron job, yet I can't see it under my host's server Control Panel.
Where would I go about to change the run time of this cron job?

Much appreciated the help! :)

[Paul M]

Its a vbulletin cron - i.e. in the vb scheduled tasks (in your ACP).

[Canis Firebrand]

Perfect! Thanks. Installed and just ran a manual backup before letting Cron do its thing.

46 seconds to back up my database completely and into individual files.

[ComoEstaEso-com]

Its a vbulletin cron - i.e. in the vb scheduled tasks (in your ACP).

Beautiful.
Thank you very much... I didn't know that was there.
I changed the time... much appreciated your work in this and all your other mods. :)
Thanks!!

[eglyntine]

Installed and Nominated. Thanks again Paul for a wonderful mod. :)

[MonsterDK]

Hi,

Is this compatible with vb forums 4.0.6?

Thanks

[Paul M]

As it says ;

vB Version: 4.0.x

[CheeSie]

In triguns version you could close the forum while this was running.. Could this be implemented again?
Or somehow lower the load xD cause everytime this runs my whole server becomes unresponsive for like the 10 minutes it takes to perform the backup and then like 5 minutes afterwards also.. :(

[Paul M]

In triguns version you could close the forum while this was running.. Could this be implemented again?
Sorry but no, that wont be re-added. It was too unreliable, often leaving the forum closed after a backup.

[Nephalim]

Shhhh weeeeet! I feel all soft and comfy-like now :p

[bandare]

Working great on my 4.06 thanks :)

[kf4eok]

Seems to work great on 4.0.7
Thanks

[der_darkon]

I can?t get this to work. :(

When i start the backup manually all i get is this error-message:

Warnung: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backups/ct-2010-09-20-Full-Backup.sql) is not within the allowed path(s): ([path]:/tmp) in [path]/includes/mysqlbackup.php (Zeile 110)

Warnung: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backups/ct-2010-09-20-Full-Backup.sql.gz) is not within the allowed path(s): ([path]:/tmp) in [path]/includes/mysqlbackup.php (Zeile 110)

Warnung: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backups/ct-2010-09-20-Full-Backup.sql) is not within the allowed path(s): ([path]:/tmp) in [path]/includes/mysqlbackup.php (Zeile 76)

Warnung: file_exists() [function.file-exists]: open_basedir restriction in effect. File(../backups/ct-2010-09-20-Full-Backup.sql) is not within the allowed path(s): ([path]:/tmp) in [path]/includes/mysqlbackup.php (Zeile 86)
Backup Error : Could not write to destination file ( ../backups/ct-2010-09-20-Full-Backup.sql )

The file does NOT exist, the backups-folder is empty

[Hippy]

der_darkon
did you set chmod for the backup folder you make to 777 \ and set the Backups Path in the admincp otions for vBulletin Automatic Backup

Hi,

Is this compatible with vb forums 4.0.6?

Thanks


yes

[Paul M]

I can?t get this to work. :(

When i start the backup manually all i get is this error-message:



The file does NOT exist, the backups-folder is empty
The error messages clearly tell you what is wrong - you have open_basdir restrictions in place on your server. If you dont know what that means then you need to consult your host.

[der_darkon]

OK.. basicly this means, that this AddOn is of no use for a lot of users....

What´s the problem with it?
The vB 3.8X version works fine on the same server.

[Paul M]

OK.. basicly this means, that this AddOn is of no use for a lot of users.
No, it does not mean that.

What?s the problem with it?
There is no problem with it, as I already told you, those errors are your server set-up. You have restrictions in place preventing you saving to the location you have set.

[der_darkon]

I don´t get it.
The older version for 3.8.X is working fine on the same server with the same restrictions.

What has changed, that the version for 4.X won´t work?

[Paul M]

Nothing has changed, I suggest you make sure you are actually using the same backup path.

[3loomShia]

Your awesome. I can not worry less.

Thanks heaps, Mate.

:)

[Parture]

Why can't we just use the Backup Wizard with CPANEL 2 Accelerated to do a backup of all files and the database?

In the manual for vBulletin it says to select drop tables. That is the only thing that is not selected in standard setup of mysql. When I use the backup wizard it doesn't give you the option to select anything any options to back.

Is that ok?

[Paul M]

I dont know anything about cpanel, I dont use it.

Dropping tables doesnt sound a very good plan - you do know that means deleting the table ?

[Parture]

Ya I know what drop table means. In the manual it says when backing up...

http://www.vbulletin.com/docs/html/

In the second area, called SQL Options, make sure you have the following boxes checked:
Structure
Add 'drop table'
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
Data

When I go into my SQL all of these are selected already except for Add 'drop table' that is: Add DROP TABLE / VIEW / PROCEDURE / FUNCTION

If this is not selected when backing up is that ok? If that's ok then I think I am ok to use CPANEL 2 Accelerated 2 and don't have to use any of the various other methods for backing up like Shell/SSH and other methods.

If not, I think I should export my database from php admin so I can select this box that is not currently selected.

If my thinking is right let me know. That CPANEL 2 built in backup method is really easy.

[Paul M]

Ah, that means add a drop command to the backup itself - yes you should normally do that as it makes restores work better.

If you want to use cpanel or php admin to manually run backups then go ahead, its your choice. I prefer to just let vb do it all automatically each night, without any need for me to do anything. :)

[Parture]

That's interesting, maybe I will try it your way, seems easier.

I still don't understand SSH and Shell and Telnet and and Keys and all that.

I noticed SSH and Telnet don't give you the option to Add 'drop table' either. Does your cron? If not then the only way to check off that box is to do it in phpadmin and export from php admin.

And last dumb question: why are there so many options? Why do we need to use Putty? Why can't we just use the Telnet or SSH in CPANEL 2 Accelerated?

I get that Shell Telnet and SSH are better (even though I don't really understand), because there are no timeouts, and maybe that's why vBulletin got rid of backups through vBulletin control panel.

[Paul M]

Yes this adds a Drop Table command to backups.

The rest of your questions have no relevance to this modification.

[Parture]

Sorry.

[Parture]

Should we backup all tables to one big file? Lock tables and do a repair before backing up?

[onehost]

My board crashed about a month ago, and I was using this hack and had some backups made that the mod created, the forum restore never could use them to restore, as it could not read them, so I had to rely on my manual backups of the sql that I was doing...I am glad I did not put 100% faith in this...not saying it does not work, it just did not restore for me when I tried...so I do not know how many of you have actually used this backup to restore, as most users just backup, and never have to restore...dont be lazy, never hurts to keep manual backups as well.

[Paul M]

I have used the backups a number of times, so I have no idea what your issue was (since you dont actually give any clue, I cant even guess).

[onehost]

I have used the backups a number of times, so I have no idea what your issue was (since you dont actually give any clue, I cant even guess).

The only clue that I can give you is when I tried to restore your backup, everything
was disorted, everything was out of place...I tried 3 different backups that
your mod created, same result, I restored my manual backup, everything was fine.

[TeknoSounds]

The only clue that I can give you is when I tried to restore your backup, everything
was disorted, everything was out of place...I tried 3 different backups that
your mod created, same result, I restored my manual backup, everything was fine.

this is of pretty big concern, would you provide Paul a copy of your backup to look at to see what the differences are?
Or I could if we don't hear back or onehost doesn't want to...

[CheeSie]

Any idea why this makes my server become unresponsive?
Whenever it runs a loooooot of new mysql process gets created and the same happens with apache..
Is there some way to limit the script to not use all system resources or something.. cause it's really annoying :(
(But anyway I love the script as it's reaaaaaaaly useful!)

[d-red]

where does it get saved to? what folder?

[Paul M]

Wherever you set it.

[Desibabu19]

Paul,

I have been using this hack for last 6 months.
I have database corruption. I am trying to restore from the backup created yesterday.
I have database connection error. I am not sure how I should fix it.

The only recent backups I have are taken using this hack. All other backups are more than 6 months old. I have a busy forum with more than 30,000 members.

Please suggest a solution ?

[Paul M]

A solution to what exactly ?

What do you mean by "database corruption" ?

Also, I cannot tell you how to fix mysql conection errors on your server, you need to speak to your host. That is a server/mysql issue, not a vbulletin or database problem.

[Desibabu19]

Paul,

For a moment I was wondering if there was a problem with this hack. Sorry about it.

Everything is fine. Couple of tables got corrupted. I don't know how.
So the last backup was not good. Backup taken a day before was good.

Thanks for your hack. Backup created by your hack was good and we used that restore everything.

[dcuellar]

Paul,
I recently received an e-mail from my host telling me that I can not use the database for storing files. The files they pointed out to me were some database backups that had been done a while ago, which is fine because I want to replace them every week. What date format should I use so that every week I have a new set of backups replacing the old ones? Would 'D' work?

[Paul M]

Use a lowercase "L". :)

[dcuellar]

Great. Thank you!

[Outbackmark]

Paul I don't know if it's just me but I am missing the Admin CP files for the Mod, I only get the forum and includes/cron files, no cronadmin.php for the admincp. Maybe the zip file has thrown a woopsie!!

[Paul M]

There is no cronadmin.php file, what makes you think there would be ?

[Outbackmark]

Because the mod is trying to find it when I run it and it's not there LOL Maybe its in the VB files and got missed on the upload, I shall look.

OK fixed......call it a dumb moment!!

[ttran]

Hi guys, newbie question
I've installed and run this mod at my test forum. Everything goes well till I do the restore over FTP.
After backup, I test with posting new thread in the forum and then I go to FTP restore my backup. Restore only restore the data of couple days ago (which makes sense to me) and all of sudden the mod I've installed in ACP also gone too.
What happen guys?
By the way, I'm using godaddy hosting and when I select file to restore it only has 1 file is: system.(mydomain)test.sql
Am I doing this right guys?
Thanks...

[Paul M]

That doesnt look like a file this created.

[samiro]

its not work with VB4.1

[PPUS]

its not work with VB4.1

I am running 4.1 PL2 and it is working as usual. Worked for all 4.1 versions actually.

[sivaganeshk]

I am running 4.1 PL2 and it is working as usual. Worked for all 4.1 versions actually.

where to change the setting ?
I don't see the Auto backup option inACP :(

[PPUS]

where to change the setting ?
I don't see the Auto backup option inACP :(

Admin cp>> settings>> options>> vbulletin automatic backup

It is towards the bottom of your options.

[sivaganeshk]

Admin cp>> settings>> options>> vbulletin automatic backup

It is towards the bottom of your options.

Thanks .. xD

I used "Yes" for combine files and the default path ../../backups/

Is it ok, right ?

[Paul M]

Yes is fine if thats what you want.

The path is entirely dependant on your server set-up and personal choice.

[sivaganeshk]

Yes is fine if thats what you want.

The path is entirely dependant on your server set-up and personal choice.

where i can file "../../backup " in FTP ?
and I want to save in to custom folder in root directory , what should I specify?

[anthracite]

Installed plugin and I get this error:

Backup Error : Could not write to destination file ( ../../backups/2010-12-17/Forum-2010-12-17-Access.sql )

Previous version worked fine. Our server has just been changed. Could this possibly be the reason for this in any way. They tell me that I have all rights to the forum folder though.

We are using vBulletin 4.0.3

EDIT:

OK working. I had the path wrong.

[fxbattleground]

I've changed the name of my admin and mod directories for security, and it seems to have caused this mod to fail - see error message below.

Warning: include_once([path]/./includes/cron/cronbackup.php) [function.include-once]: failed to open stream: No such file or directory in [path]/xxSECURENAMExx/cronadmin.php on line 113

Warning: include_once() [function.include]: Failed opening '[path]/./includes/cron/cronbackup.php' for inclusion (include_path='.:/usr/local/php5/lib/php') in [path]/xxSECURENAMExx/cronadmin.php on line 113

--

I've looked in the cronbackup.php file, but don't see an obvious fix - i'm not good enough to make it work if it's not obvious - any help is appreciated.

--

Version 4.0.8 Patch Level 2

[tattooz]

If I have this run daily, will it replace the file created and only save 1 or will it make a new file each time?

[Paul M]

I've looked in the cronbackup.php file, but don't see an obvious fix - i'm not good enough to make it work if it's not obvious - any help is appreciated.

Thats because the error isnt being generated by cronbackup.php. :)

What its actually saying is that cronadmin.php (the admin panel code for scheduled tasks) cannot see the file.

Are you sure that cronbackup.php still exists in the /includes/cron/ folder on your server - because that error is basically saying it doesnt !

[Paul M]

If I have this run daily, will it replace the file created and only save 1 or will it make a new file each time?
That depends on the format you use for the timestamp (which names the files).

[fxbattleground]

thanks Paul - which directory exactly should each file go into?

cronbackup.php?

The instructions don't say specifically, but judging from the error string, the admin directory?

I'll send you a Dr. Pepper when we get it going?

EDIT: Got it going - whew, I need a Dr. Pepper!

[CRDeveloper]

I've been using this mod since you made it hehe, but for some reason my backups haven't been successfully created, they just hang at some point:

Scheduled Task Manager
Automatic Database Backup for vBulletin
Processing 404_actions (No Row Data)
Processing vbulletin_access (121) : Processed 121 Rows in 0.004 Seconds
Processing vbulletin_action (No Row Data)
Processing vbulletin_ad (10) : Processed 10 Rows in 0.001 Seconds
Processing vbulletin_adcriteria (7) : Processed 7 Rows in 0.001 Seconds
Processing vbulletin_adminhelp (1670) : Processed 1670 Rows in 0.081 Seconds
Processing vbulletin_administrator (5) : Processed 5 Rows in 0.001 Seconds
Processing vbulletin_adminlog (20401) : Processed 20401 Rows in 0.982 Seconds
Processing vbulletin_adminmessage (No Row Data)
Processing vbulletin_adminutil (3) : Processed 3 Rows in 0 Seconds
Processing vbulletin_album (52) : Processed 52 Rows in 0.004 Seconds
Processing vbulletin_albumupdate (10) : Processed 10 Rows in 0.001 Seconds
Processing vbulletin_announcement (3) : Processed 3 Rows in 0.001 Seconds
Processing vbulletin_announcementread (No Row Data)
Processing vbulletin_apiclient (No Row Data)
Processing vbulletin_apilog (No Row Data)
Processing vbulletin_attachment (18246) : Processed 18246 Rows in 1.609 Seconds
Processing vbulletin_attachmentcategory (6) : Processed 6 Rows in 0.001 Seconds
Processing vbulletin_attachmentcategoryuser (7050) : Processed 7050 Rows in 0.308 Seconds
Processing vbulletin_attachmentpermission (No Row Data)
Processing vbulletin_attachmenttype (12) : Processed 12 Rows in 0.001 Seconds
Processing vbulletin_attachmentviews (7) : Processed 7 Rows in 0.001 Seconds
Processing vbulletin_avatar (No Row Data)
Processing vbulletin_bbcode (18) : Processed 18 Rows in 0.002 Seconds
Processing vbulletin_bbcode_video (7) : Processed 7 Rows in 0.001 Seconds
Processing vbulletin_block (1) : Processed 1 Rows in 0.001 Seconds
Processing vbulletin_blockconfig (3) : Processed 3 Rows in 0.001 Seconds
Processing vbulletin_blocktype (6) : Processed 6 Rows in 0.001 Seconds
Processing vbulletin_bookmarksite (4) : Processed 4 Rows in 0.001 Seconds
Processing vbulletin_cache (1) : Processed 1 Rows in 0.001 Seconds
Processing vbulletin_cacheevent (3) : Processed 3 Rows in 0.001 Seconds
Processing vbulletin_calendar (1) : Processed 1 Rows in 0.001 Seconds
Processing vbulletin_calendarcustomfield (No Row Data)
Processing vbulletin_calendarmoderator (No Row Data)
Processing vbulletin_calendarpermission (No Row Data)
Processing vbulletin_contentpriority (No Row Data)
Processing vbulletin_contenttype (14) : Processed 14 Rows in 0.002 Seconds
Processing vbulletin_cpsession (3) : Processed 3 Rows in 0.001 Seconds
Processing vbulletin_cron (25) : Processed 25 Rows in 0.003 Seconds
Processing vbulletin_cronlog (816) : Processed 816 Rows in 0.035 Seconds
Processing vbulletin_customavatar (573) : Processed 573 Rows in 0.236 Seconds
Processing vbulletin_customprofile (28) : Processed 28 Rows in 0.007 Seconds
Processing vbulletin_customprofilepic (259) : Processed 259 Rows in 0.085 Seconds
Processing vbulletin_datastore (35) : Processed 35 Rows in 0.025 Seconds
Processing vbulletin_dbquery (No Row Data)
Processing vbulletin_dbtech_status_criteria (1) : Processed 1 Rows in 0.001 Seconds
Processing vbulletin_dbtech_status_moods (No Row Data)
Processing vbulletin_dbtech_status_statuslog (295) : Processed 295 Rows in 0.015 Seconds
Processing vbulletin_deletionlog (109) : Processed 109 Rows in 0.006 Seconds
Processing vbulletin_discussion (17) : Processed 17 Rows in 0.002 Seconds
Processing vbulletin_discussionread (58) : Processed 58 Rows in 0.003 Seconds
Processing vbulletin_editlog (435) : Processed 435 Rows in 0.021 Seconds
Processing vbulletin_evbs_sstabs (5) : Processed 5 Rows in 0.001 Seconds
Processing vbulletin_evbs_sstabs_childs (17) : Processed 17 Rows in 0.002 Seconds
Processing vbulletin_event (6) : Processed 6 Rows in 0.001 Seconds
Processing vbulletin_externalcache (11) : Processed 11 Rows in 0.006 Seconds
Processing vbulletin_faq (42) : Processed 42 Rows in 0.003 Seconds
Processing vbulletin_filedata (17771) : Processed 17771 Rows in 1.673 Seconds
Processing vbulletin_formbits (23) : Processed 23 Rows in 0.004 Seconds
Processing vbulletin_formresults (64) : Processed 64 Rows in 0.005 Seconds
Processing vbulletin_forms (4) : Processed 4 Rows in 0.002 Seconds
Processing vbulletin_forum (148) : Processed 148 Rows in 0.028 Seconds
Processing vbulletin_forumpermission (31) : Processed 31 Rows in 0.002 Seconds
Processing vbulletin_forumprefixset (No Row Data)
Processing vbulletin_forumread (1165) : Processed 1165 Rows in 0.036 Seconds
Processing vbulletin_groupmessage (139) : Processed 139 Rows in 0.011 Seconds
Processing vbulletin_groupmessage_hash (No Row Data)
Processing vbulletin_groupread (43) : Processed 43 Rows in 0.002 Seconds
Processing vbulletin_guest (6479) : Processed 6479 Rows in 0.361 Seconds
Processing vbulletin_guestviews (49659) : Processed 49659 Rows in 1.981 Seconds
Processing vbulletin_holiday (No Row Data)
Processing vbulletin_humanverify (6) : Processed 6 Rows in 0.001 Seconds
Processing vbulletin_hvanswer (No Row Data)
Processing vbulletin_hvquestion (No Row Data)
Processing vbulletin_icon (14) : Processed 14 Rows in 0.001 Seconds
Processing vbulletin_imagecategory (3) : Processed 3 Rows in 0 Seconds
Processing vbulletin_imagecategorypermission (No Row Data)
Processing vbulletin_impexerror (No Row Data)
Processing vbulletin_indexqueue (No Row Data)
Processing vbulletin_infraction (3) : Processed 3 Rows in 0.001 Seconds
Processing vbulletin_infractionban (No Row Data)
Processing vbulletin_infractiongroup (No Row Data)
Processing vbulletin_infractionlevel (4) : Processed 4 Rows in 0.001 Seconds
Processing vbulletin_language (2) : Processed 2 Rows in 0.033 Seconds
Processing vbulletin_lgv (1) : Processed 1 Rows in 0.001 Seconds
Processing vbulletin_mailqueue (No Row Data)
Processing vbulletin_moderation (64) : Processed 64 Rows in 0.002 Seconds
Processing vbulletin_moderator (24) : Processed 24 Rows in 0.001 Seconds
Processing vbulletin_moderatorlog (7268) : Processed 7268 Rows in 1.032 Seconds
Processing vbulletin_notice (4) : Processed 4 Rows in 0.001 Seconds
Processing vbulletin_noticecriteria (4) : Processed 4 Rows in 0.001 Seconds
Processing vbulletin_noticedismissed (144) : Processed 144 Rows in 0.005 Seconds
Processing vbulletin_package (1) : Processed 1 Rows in 0.001 Seconds
Processing vbulletin_passwordhistory (4078) : Processed 4078 Rows in 0.127 Seconds
Processing vbulletin_paymentapi (7) : Processed 7 Rows in 0.001 Seconds
Processing vbulletin_paymentinfo (No Row Data)
Processing vbulletin_paymenttransaction (No Row Data)
Processing vbulletin_phrase (23788) : Processed 23788 Rows in 1.615 Seconds
Processing vbulletin_phrasetype (73) : Processed 73 Rows in 0.005 Seconds
Processing vbulletin_picturecomment (30) : Processed 30 Rows in 0.003 Seconds
Processing vbulletin_picturecomment_hash (No Row Data)
Processing vbulletin_picturelegacy (No Row Data)
Processing vbulletin_plugin (172) : Processed 172 Rows in 0.022 Seconds
Processing vbulletin_pm (183017)
--- Processed 100000 Rows
# Processed 183017 Rows in 9.244 Seconds
Processing vbulletin_pmreceipt (119) : Processed 119 Rows in 0.008 Seconds
Processing vbulletin_pmtext (102486)
--- Processed 100000 Rows
# Processed 102486 Rows in 10.07 Seconds
Processing vbulletin_pmthrottle (No Row Data)
Processing vbulletin_podcast (No Row Data)
Processing vbulletin_podcastitem (No Row Data)
Processing vbulletin_poll (84) : Processed 84 Rows in 0.027 Seconds
Processing vbulletin_pollvote (4209) : Processed 4209 Rows in 0.232 Seconds
Processing vbulletin_post (1178671)
--- Processed 100000 Rows
--- Processed 200000 Rows
--- Processed 300000 Rows
--- Processed 400000 Rows
--- Processed 500000 Rows
--- Processed 600000 Rows
--- Processed 700000 Rows
--- Processed 800000 Rows
--- Processed 900000 Rows
--- Processed 1000000 Rows
--- Processed 1100000 Rows
# Processed 1178671 Rows in 165.453 Seconds
Processing vbulletin_post_thanks (634) : Processed 634 Rows in 0.049 Seconds
Processing vbulletin_postedithistory (977) : Processed 977 Rows in 0.281 Seconds
Processing vbulletin_posthash (2) : Processed 2 Rows in 0.011 Seconds
Processing vbulletin_postlog (2672) : Processed 2672 Rows in 0.169 Seconds
Processing vbulletin_postparsed (4062) : Processed 4062 Rows in 0.557 Seconds
Processing vbulletin_prefix (No Row Data)
Processing vbulletin_prefixpermission (No Row Data)
Processing vbulletin_prefixset (No Row Data)
Processing vbulletin_product (45) : Processed 45 Rows in 0.013 Seconds
Processing vbulletin_productcode (70) : Processed 70 Rows in 0.048 Seconds
Processing vbulletin_productdependency (14) : Processed 14 Rows in 0.001 Seconds
Processing vbulletin_profileblockprivacy (72) : Processed 72 Rows in 0.011 Seconds
Processing vbulletin_profilefield (6) : Processed 6 Rows in 0.008 Seconds
Processing vbulletin_profilefieldcategory (No Row Data)
Processing vbulletin_profilevisitor (3346) : Processed 3346 Rows in 0.185 Seconds
Processing vbulletin_quotedatanew (342) : Processed 342 Rows in 0.031 Seconds
Processing vbulletin_ranks (3) : Processed 3 Rows in 0.017 Seconds
Processing vbulletin_rbs_banners (2) : Processed 2 Rows in 0.01 Seconds
Processing vbulletin_rbs_hits (No Row Data)
Processing vbulletin_reminder (No Row Data)
Processing vbulletin_reputation (No Row Data)
Processing vbulletin_reputationlevel (15) : Processed 15 Rows in 0.01 Seconds
Processing vbulletin_route (No Row Data)
Processing vbulletin_rssfeed (No Row Data)
Processing vbulletin_rsslog (No Row Data)
Processing vbulletin_searchcore (355564)
--- Processed 100000 Rows
--- Processed 200000 Rows
--- Processed 300000 Rows
# Processed 355564 Rows in 25.604 Seconds
Processing vbulletin_searchcore_text (355564)
--- Processed 100000 Rows
--- Processed 200000 Rows
--- Processed 300000 Rows
# Processed 355564 Rows in 17.746 Seconds
Processing vbulletin_searchgroup (67995) : Processed 67995 Rows in 3.285 Seconds
Processing vbulletin_searchgroup_text (68013) : Processed 68013 Rows in 2.482 Seconds
Processing vbulletin_searchlog (5) : Processed 5 Rows in 0.024 Seconds
Processing vbulletin_seoqueries_data (148014)
--- Processed 100000 Rows
# Processed 148014 Rows in 6.227 Seconds
Processing vbulletin_seoqueries_filtered_terms (73) : Processed 73 Rows in 0.019 Seconds
Processing vbulletin_seoqueries_terms (139519)
--- Processed 100000 Rows
# Processed 139519 Rows in 5.037 Seconds
Processing vbulletin_seoqueries_terms_stats (12460) : Processed 12460 Rows in 0.651 Seconds
Processing vbulletin_session (371) : Processed 371 Rows in 0.042 Seconds
Processing vbulletin_setting (839) : Processed 839 Rows in 0.068 Seconds
Processing vbulletin_settinggroup (86) : Processed 86 Rows in 0.016 Seconds
Processing vbulletin_sigparsed (439) : Processed 439 Rows in 0.071 Seconds
Processing vbulletin_sigpic (37) : Processed 37 Rows in 0.121 Seconds
Processing vbulletin_smilie (151) : Processed 151 Rows in 0.126 Seconds
Processing vbulletin_socialgroup (12) : Processed 12 Rows in 0.035 Seconds
Processing vbulletin_socialgroupcategory (8) : Processed 8 Rows in 0.011 Seconds
Processing vbulletin_socialgroupicon (12) : Processed 12 Rows in 0.034 Seconds
Processing vbulletin_socialgroupmember (153) : Processed 153 Rows in 0.01 Seconds
Processing vbulletin_spamlog (7) : Processed 7 Rows in 0.011 Seconds
Processing vbulletin_stats (2788) : Processed 2788 Rows in 0.149 Seconds
Processing vbulletin_strikes (No Row Data)
Processing vbulletin_style (2) : Processed 2 Rows in 0.052 Seconds
Processing vbulletin_stylevar (623) : Processed 623 Rows in 0.057 Seconds
Processing vbulletin_stylevardfn (473) : Processed 473 Rows in 0.055 Seconds
Processing vbulletin_subscribediscussion (No Row Data)
Processing vbulletin_subscribeevent (No Row Data)
Processing vbulletin_subscribeforum (14) : Processed 14 Rows in 0.001 Seconds
Processing vbulletin_subscribegroup (1) : Processed 1 Rows in 0.008 Seconds
Processing vbulletin_subscribethread (20646) : Processed 20646 Rows in 1.125 Seconds
Processing vbulletin_subscription (No Row Data)
Processing vbulletin_subscriptionlog (No Row Data)
Processing vbulletin_subscriptionpermission (No Row Data)
Processing vbulletin_tachyforumcounter (No Row Data)
Processing vbulletin_tachyforumpost (No Row Data)
Processing vbulletin_tachythreadcounter (No Row Data)
Processing vbulletin_tachythreadpost (No Row Data)
Processing vbulletin_tag (438) : Processed 438 Rows in 0.07 Seconds
Processing vbulletin_tagcontent (575) : Processed 575 Rows in 0.026 Seconds
Processing vbulletin_tagsearch (3490) : Processed 3490 Rows in 0.123 Seconds
Processing vbulletin_template (1663) : Processed 1663 Rows in 1.267 Seconds
Processing vbulletin_templatehistory (10) : Processed 10 Rows in 0.037 Seconds
Processing vbulletin_templatemerge (No Row Data)
Processing vbulletin_thread (67468) : Processed 67468 Rows in 12.255 Seconds
Processing vbulletin_threadrate (161) : Processed 161 Rows in 0.033 Seconds
Processing vbulletin_threadread (21267) : Processed 21267 Rows in 0.68 Seconds
Processing vbulletin_threadredirect (1) : Processed 1 Rows in 0.019 Seconds
Processing vbulletin_threadviews (No Row Data)
Processing vbulletin_upgradelog (14) : Processed 14 Rows in 0.025 Seconds
Processing vbulletin_user (29032)
Any idea why?

My backups were bigger than 3GB, but, i moved the attachments to file system. Last backup is about 950Mbs but incomplete!

[haidm]

Where can I alter the timing of the cron job to suit?

[Paul M]

Where can I alter the timing of the cron job to suit?
ACP > Scheduled Tasks.

[Paul M]

I've been using this mod since you made it hehe, but for some reason my backups haven't been successfully created, they just hang at some point:

My backups were bigger than 3GB, but, i moved the attachments to file system. Last backup is about 950Mbs but incomplete!
I cant answer questions on individual servers as I have no access to them - most likely your host has set php timeouts you cannot override.

[Trek]

Paul,

I've been running this for a long time on one site I admin without a problem (vb 4.06), I just installed it on another site (vb 4.08) and when I attempt to save the settings from AdminCP-> Settions->Options, I get the following error:

You don't have permission to access /forum/admincp/options.php on this server.

It's only when I try and save the setting with this mod in view though. If I select another mod specifically, it'll save fine. If I select this one specifically (or the full list of settings options), I get this error. Any suggestions on what to do?

Thanks!

[Paul M]

Thats a server issue, probably something like mod security. You need to speak to your host.

[ShackMaster]

Hi Paul...

I have read every post and tried every combo of paths known to mankind.... but I cannot get it to work. I have our forums in public_html on a dedicated server with gzip. I have a backups folder with 777 permissions in the same home directory as the public_html folder... and have verified and reuploaded the cronbackup.php to the /includes/cron/ folder. I still get an error... here is the latest path I set... (assuming I need the same path in the Options setting and in the Scheduled Tasks setting)...

Automatic Database Backup for vBulletin

Warning: include_once([path]/../backups) [function.include-once]: failed to open stream: Success in [path]/admincp/cronadmin.php on line 113

Warning: include_once() [function.include]: Failed opening '[path]/../backups' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/admincp/cronadmin.php on line 113

Done

Your help is appreciated!

[Paul M]

You dont change anything in the Scheduled Task settings, otherwise you will break it.

[ShackMaster]

Why didn't ya just say so then... :huh:

[CRDeveloper]

You dont change anything in the Scheduled Task settings, otherwise you will break it.

If we changed, how to get it back??

[ShackMaster]

The same way you changed it... change it back.

Oh... you mean what should it be? ./includes/cron/cronbackup.php

[hasidoo]

Thank you so much for this one!
Works perfectly on my site..
Nominated it for MOTM..
Keep up the good work!!:up::)

[davidg]

Processed Database in 5.743 seconds

Backup Completed Successfully

Done

worked fine for me to thanks paul

[sweetpotato]

Work like a charm for me. I use this and restore database by SysPex Dumper and it runs very well.

I will set automatically backup one a week.

Thank you for the nice mod

[begin]

Thanks! Works great.

[atacann1977]

have vbulletin 4.1, it suite.Habe instaled but it comes backup error.
where is the error. have done the include file in httpdocs / forum / include file and the crone in htppdocs / forum include / cron. Can you make it through shows how it works or it does not work with my vbulletin.
thank you

[Paul M]

Umm, sorry, not really sure what you are trying to say.

[atacann1977]

Please show me the install as picture.
have vbulletin 4.1 suite. I have install´s but it say: Backup Error : Could not write to destination file ( ../forum/buc/2011-01-30/Forum-2011-01-30-Access.sql )

[Paul M]

Please show me the install as picture.

Sorry, thats not going to happen.



have vbulletin 4.1 suite. I have install?s but it say: Backup Error : Could not write to destination file ( ../forum/buc/2011-01-30/Forum-2011-01-30-Access.sql )
That means the folder you are trying to write to either doesnt exist, or doesnt have the right permissions (or your webserver doesnt have permission to write to it).

[zelnik]

Hi Paul,

Just a quick question. Been reading the post over at vb.com about vb4.1.2 and it seems they have removed the file "includes/adminfunctions_backup.php" is this likely to cause any problems when one installs 4.1.2 and deletes? this file?

Link: http://www.vbulletin.com/forum/showthread.php/372733-vBulletin.com-is-now-powered-by-vBulletin-4.1.2

[Paul M]

This mod has no reliance on that file.

[washingtonboise]

After reading a few pages of posts, I recommend setting the default installation path to ././backups and adding instructions to create that directory and CHMOD it 777.

That will ease things up a bit for those who are less technically inclined.

Excellent mod. One suggestion: Allow a config option for deleting old files that are 'X backups old'. This would allow for limitation of disk space usage.

[upperme]

I am new to vBulletin, so please forgive my ignorance, but I am learning. Are you saying we should not ADD a Scheduled Task? If that is the case, then where should I adjust the cron timing to initiate the backups?
You dont change anything in the Scheduled Task settings, otherwise you will break it.

[strudinox]

Just FYI, make sure that open_basedir is disabled or it will not work. ;)

[3loomShia]

I already have the old version of this installed. Now, I just had to overwrite the old ones.
Worked fine for me. Thanks heaps, Paul. This mod is a savior.

[Arkham]

Thanks, Paul!! I couldn't SSH into the server today (my dev install which I haven't used for ages), so this mod came in handy! After I figured out where to run it manually, worked like a charm.

One thing though... The first time I ran it I had it set to backup individual tables, but I then set it to single-file backup. I'm looking in the directory and don't see a single-file that I can identify as the complete backup.

Am I missing something? (I re-ran it manually, so is there a chance that since nothing was really changed since the piece-meal backup, it didn't bother running again?)

Thx.

[Paul M]

It will always do a backup if you run it.

Not sure I understand the rest of the question, are you saying you couldnt see the created file ?

Where were you looking ?

[Arkham]

It will always do a backup if you run it.

Not sure I understand the rest of the question, are you saying you couldnt see the created file ?

Where were you looking ?

I was looking in the same backup folder that I found the individual backup files (before I configured it to backup to a single file). I don't see the new single-file backup, only the multiple smaller files from my first backup job.

Apart from the configurable prefix, what should the single-file backup be named? <prefix>-date.sql?

[Paul M]

Im not sure you are looking in the correct place - single files will go in the root of the configured backup folder - multiple file backups create an extra folder that single file backups dont.

[Arkham]

Im not sure you are looking in the correct place - single files will go in the root of the configured backup folder - multiple file backups create an extra folder that single file backups dont.

Ah, maybe I configured it incorrectly. All the single files went into the /backups directory specified in on the admincp config page. I'll double check when I get back in there.

Thx!

[solohdes]

I installed the hack but I don't have write permissions. I know that I have to give write permissions with apache but I'm newbie in this, can you say me how to do step by setp? Thanks. I have Centos 5 (OS) with kloxo (CP).

[Paul M]

You change the permissions on your chosen backup folder to 777.

[prandah]

thanks paul this mod very help me

[F1-Gears]

I receive this error mensaje in vB4.1.2

Backup Error : Could not write to destination file ( ../../backups/Forum-2011-03-20-Full-Backup.sql )

Backups directory is full writeable (777)

Does someone knows how can I repair it?

Thanks

[mmacrypt]

Updated and I'll know if it's working in the morning. Thank you Paul, you do great stuff.

[Paul M]

I receive this error mensaje in vB4.1.2



Backups directory is full writeable (777)

Does someone knows how can I repair it?

Thanks
Your php probably has other restrictions in place.

[Phaedrus]

Wow. I upgrade, run this... and my dbase is now more than twice the size it was before the upgrade. Whooooo. That's large.

This is one of the hacks that I refuse to upgrade until I see it... Thanks Paul.

[JHC]

Excellent mod Paul. Works flawlessly. Is there anyway to make the mod so I can delete backup files after say 5 backups? So there are never more than 5 at a given time. If not, that's fine, I'll just log in from time to time and delete them. Thanks again!!

[JHC]

You can simply change the date format of the files (in the settings), and make use of the fact that this will replace (delete) any existing file(s) with the same name. On my live site I use the l (lowercase L), which means my files use the day of the week (Monday, Tuesday etc) - so I only ever have 7 backups.

Nevermind my question. Searched through and found this. Exactly what I needed. You da man!

[MAdotcom]

Thank you so much! Installed

[Donkon]

doesnt work man. When i press on run now in schedualed tasks, nothing happens, all i get is Done. Message and no backups in my folders. Please help im on 4.1.2

[Paul M]

There isnt really much I can do without ftp and admin access.

[HMBeaty]

Works great for me on 4.1.2 :D Thanks again Paul

[Bob_R]

My backup use to take about 1 1/2 - 2 minutes. The last 4 or 5 days they've taken 5-6 minutes.

Any explanation for this? Is it the hack/mod or my server/my site.

And what do I need to do?

Thanks!! :)

[Paul M]

There is no way I can possibly know whats happening on your server. ;)

If its working then you dont need to do anything.

[F1-Gears]

Your php probably has other restrictions in place.

Can I do something to repair it?

before I upgraded to 4.1.2 I used v4.0.1 of this mod and worked quite well. Later I upgraded the mod too and doesn?t goes.

Thanks

[Paul M]

There are no changes in the mod between v4.0.1 and v4.1.0 of the mod that would cause that - either you are using a different path to before, or something has changed on your server.

[m411b]

when I do a backup manually I get the Backup Error : Could not write to destination file even though my backup directory is 777 and the path is correct. I also get a 1kb file placed in the backup directory after doing a manual backup. A file being placed there tells me my path is correct and it is writable.

So whats going on? What am I doing wrong?

[Paul M]

Sorry, I have no idea. I cannot comment on the setup [and oddities] of individual servers.

[m411b]

Sorry, I have no idea. I cannot comment on the setup [and oddities] of individual servers.

Can you give me any ideas on what would cause that at server level?

[Paul M]

Actually no. I cannot think of any permission set-up that would allow you to create a file but not write to it (unless its a windows server ?).

[m411b]

Negative. It's Linux. I have re-cursed permissions to all files and sub-directories as well and still a no-go. I'm lost!

[m411b]

OK, well thanx for the "Support".
Marked "Uninstalled"....

[barmen_1982]

Sending E-mail address you specify a backup I would have more super

[F1-Gears]

There are no changes in the mod between v4.0.1 and v4.1.0 of the mod that would cause that - either you are using a different path to before, or something has changed on your server.


Thanks again for your answer :up:, only had changed the vBulletin version :( (an the mod version)

[Paul M]

OK, well thanx for the "Support".
Marked "Uninstalled"....
No idea if your trying to be sarcastic or not, but if you're expecting replies at 4am in the morning you are going to be unlucky.

[Boofo]

It sounded like he thought he was punishing you by clicking un-install. I get those all the time.

[HMBeaty]

Here's a strange one for you lol. Not sure what I missed if I even missed anything, but the only backup that was made so far was the one I did to test the setup to make sure it works. The folder has been set 777 and directory is set correctly, but seems the scheduled task itself is not running. See the images attached. Am I missing something?

[Paul M]

Am I missing something?
I dont think so. Are any of your schedules tasks running ?

[HMBeaty]

I dont think so. Are any of your schedules tasks running ?
The "Automatic Database Backup" was the only one that was listed when I checked the "Scheduled Task Log" and my "Scheduled Task Manager" looks like this (image attached), which I'm not sure why some dates say 2003, 2009, etc. Maybe this is another vBulletin bug...

[HMBeaty]

It wouldn't be because my forums are turned off would it?

[HMBeaty]

Well, that solved that lol. Thanks Paul
Tasks wont run with the forum closed.

Also, we do not provide support for third party code as a whole. If that specific task is causing a problem the next step would be to disable it.


All the best,
Zachery Woods
Support Team, vBulletin

[StudentCreche]

How do I use this then...? Could someone please guide me...?

[Staxed]

would it be too much trouble to add a second file format option to this mod?

I want to do daily table backups, one file for each table, as well as a weekly full database backup to a single file.

At the moment, every sunday I just switch the settings to produce one file, manually run the cron, and change it back. Just thought I'd see if I could get a more automated process added into it.

No worries if it's too much trouble though, thanks.

[giaguaro]

hi i installed it, by i am not able to set the time for running it.
Would you please help me?
Thanks a lot

[HMBeaty]

hi i installed it, by i am not able to set the time for running it.
Would you please help me?
Thanks a lot
What do you mean you aren't able to set the time?

Go to AdminCP > Scheduled Tasks > Scheduled Task Manager > and Edit the settings for Automatic Database Backup for vBulletin

[giaguaro]

thanks a lot. I am a beginner and i didnt know the Scheduled tasks options

[Paul M]

would it be too much trouble to add a second file format option to this mod?
Im afraid it would be a bit of work to do that.

[Staxed]

Im afraid it would be a bit of work to do that.

no worries then, i'll just do it how i've been doing it, just thought I'd ask :D

[Stefan118]

Thank you very much!
Creating a backup is the one thing i allways forget.

My database of over 1.5 Gb was backed up in 750.745 seconds... that is almost 13 minutes.

[Vick98]

Backup Error : Could not write to destination file

What would be the path to the backup folder? Should I create a new folder and change the permission to writable or is there an existing folder I need to use? Thank you in advance.

[StudentCreche]

How do I use this then...? Could someone please guide me...?

Bump...

[Stefan118]

How do I use this then...? Could someone please guide me...?
Bump...

If you read the Auto-backup.txt file, you will be able to setup the correct settings.
I installed this program yesterday in about 10 minutes.

What part of the setup don't you understand?

[Paul M]

Backup Error : Could not write to destination file

What would be the path to the backup folder? Should I create a new folder and change the permission to writable or is there an existing folder I need to use? Thank you in advance.
You create your own and set the path in the settings.

[Vick98]

You create your own and set the path in the settings.

Thank you for the reply.

[Vick98]

Could someone give me an example of what the file path should look like when setting up the settings?

[TeknoSounds]

If on a windows box it'll be something like c:\path_to_your_backup\directory_you_created\
linux would be something more like /html/www/my_website/backup
If you're on a shared host it'll look like the linux one.

[Phaedrus]

no worries then, i'll just do it how i've been doing it, just thought I'd ask :D

Couldn't you just manually create a second Cron task for that one specific run?

[Phaedrus]

Could someone give me an example of what the file path should look like when setting up the settings?

Yeah, my Linux box it is ../backupfilename/

This puts it above the public_html so the public has no access to it.

[Vick98]

Yeah, my Linux box it is ../backupfilename/

This puts it above the public_html so the public has no access to it.

I don't know why I am having issues with this. it should be simple, I know. I am using ../backupfiles/ for the setting and have the file permission 777 but am still getting an error message...

Automatic Database Backup for vBulletin

Backup Error : Could not write to destination file ( ../backupfiles/Forum-2011-04-11-Full-Backup.sql )

[Phaedrus]

I don't know why I am having issues with this. it should be simple, I know. I am using ../backupfiles/ for the setting and have the file permission 777 but am still getting an error message...

Automatic Database Backup for vBulletin

Backup Error : Could not write to destination file ( ../backupfiles/Forum-2011-04-11-Full-Backup.sql )

Where did you create your backupfiles file?

[Vick98]

Where did you create your backupfiles file?

I created a new directory above the public_html

[StudentCreche]

Processed Database in 2.694 seconds! Wooo!

[Vick98]

Processed Database in 2.694 seconds! Wooo!

I would like to do the same but an having issues. :)

[StudentCreche]

I would like to do the same but an having issues. :)

What do you need help with mate?

[Paul M]

I created a new directory above the public_html
Then your path is probably wrong, try ../../backupfiles/

[Vick98]

Then your path is probably wrong, try ../../backupfiles/

That worked. I really appreciate your support. Again, thank you.

[Phaedrus]

I created a new directory above the public_html

f'get it, you go tit answered.

[Phaedrus]

Processed Database in 2.694 seconds! Wooo!

LOL. Wow, back in the day.

[Trusster]

Backup Error : Could not write to destination file tried to add all write permission "777" to the folder but didn't help.

Fixed it :) thanks for the mod

[shuuk]

i want to make a everyday at 20:00 autobackup..
how can i do that?

please can anyone show me that in a pic?

[TeknoSounds]

change Stunde to 20... unless your server time is offset, then you'll need to adjust for that.

[Stefan118]

Every week I let this mod make a backup of the database, and every week I get this error in my mailbox:

Database error in vBulletin 4.1.3:

Invalid SQL:

INSERT INTO papegaaienforum_cronlog
(varname, dateline, description, type)
VALUES
('cbu_crontask',
1304219014,
'Backup Completed Successfully',
0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, May 1st 2011 @ 05:03:34 AM
Error Date : Sunday, May 1st 2011 @ 05:20:46 AM
Script : http://www.papegaaienforum.nl/cron.php?rand=1304219014
Referrer : http://www.papegaaienforum.nl/search.php?searchid=81263
IP Address : 94.211.138.61
Username : Niet Geregistreerd
Classname : vB_Database
MySQL Version :


What can I do about it exept for disabling this mod?

[Paul M]

What can I do about it exept for disabling this mod?
You can just ignore it. Its only the logging of the cron run after backup completion.

I would guess your mysql timeout is quite small and its timing out before the log command can be run (are you using the gzip option ?).

[Stefan118]

Ok, thank you.

Yes, I do use that, because the database is about 1.5 Gb. (350Mb with gzip)

[Paul M]

Thats why then - the Gzip is taking longer than your mysql timeout.

[Gamelobby]

Then your path is probably wrong, try ../../backupfiles/

So this should work correctly, or should i make a new folder.?
example.com/folder/_db_backups



*edit*


I created this folder example.com/folder/backupfiles but still get the error.?
Backup Error : Could not write to destination file

I beleive it is write-able... see image.

[CharlieDelta]

Installed and works like a charm!
Thanks Paul!!

[Paul M]

So this should work correctly, or should i make a new folder.?
example.com/folder/_db_backups



*edit*


I created this folder example.com/folder/backupfiles but still get the error.?


I beleive it is write-able... see image.
I cannot really answer server specific questions as few servers are exactly the same.

[Gamelobby]

Server specific..!?

I know you obviously don't know what my folders are named, but i'm asking if anything looks wrong to you as far as folder structure & if it looks writable (see image)

I'm just trying to get it to work, like everyone else.
Thanks

[Paul M]

There is generally more involved than just the folder settings (which themselves are fine). Things like open_basdir can restrict what areas apache can write too. Its also not possible from your post to see where the folder is in relation to your vb installation. Like I said, most peoples set-ups are slightly different.

[Gamelobby]

I see.. yea i guess my example could be misleading. Mine is set outside the Forums
example.com/Notforumsfolder/backupfiles

Any suggestions what i could try that could be not allowing it to write/work.?

Thanks

[TeknoSounds]

do you have access to your logs? could check there to see if the job is throwing something in there that could be an indication.

As for my site I have it set up as:
BU folder location
mysite.com/backups

settings in acp:
../backups/

running on linux.

[Gamelobby]

do you have access to your logs? could check there to see if the job is throwing something in there that could be an indication.

As for my site I have it set up as:
BU folder location
mysite.com/backups

settings in acp:
../backups/

running on linux.
Where, which logs.?


Wait, am i literally supposed to use dots.?
.../backups

Because if so, that is probably the issue. lol

[Paul M]

Yes, the dots are important (two dots, not three, and a slash)

../ means up one folder level.

[prandah]

hello paul

i used this on my server
i use xen memroy 1GB

but yesterday when i run this
i get error
here is my error ?

Database error in vBulletin 4.1.2:

Invalid SQL:

INSERT INTO pacus_5777101_kyocronlog
(varname, dateline, description, type)
VALUES
('cbu_crontask',
1305144575,
'Backup Completed Successfully',
0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, May 11th 2011 @ 04:09:35 PM
Error Date : Wednesday, May 11th 2011 @ 04:11:36 PM
Script : http://www.ditusuk.com/tempik/cronadmin.php?do=runcron&cronid=40
Referrer : http://www.ditusuk.com/tempik/cronadmin.php?do=modify
IP Address : 123.456.789
Username : Admin
Classname : vB_Database
MySQL Version :


what should i do ?

[marianoblesa]

This is where you put?

<!-- $Header: F:\CVS/4.x/Auto-backup/Auto-backup.txt,v 1.3 2010/12/04 22:52:33 Pem Exp $ -->

[Paul M]

what should i do ?
Read back a few posts - your mysql timeout is low, so the connection is timing out, probably because you are gzipping the file.

[Paul M]

This is where you put?

<!-- $Header: F:\CVS/4.x/Auto-backup/Auto-backup.txt,v 1.3 2010/12/04 22:52:33 Pem Exp $ -->
I dont know what you are asking.

[prandah]

Read back a few posts - your mysql timeout is low, so the connection is timing out, probably because you are gzipping the file.

so do I have to rebuild Gzip again?
or whether the database could still be in use ( can be dump )? because there is an error log?

[TeknoSounds]

I think the easiest solution is to up the mysql connection timeout...

[Paul M]

I think the easiest solution is to up the mysql connection timeout...
Thats the only solution, other than not using the gzip option of course.

Just to be clear, its not affecting the backups, just the final logging that it worked ok.

[prandah]

so it said fine for download then for dump again ?

[MarceloS]

Hi, thanks for the excellent product.

In my case, I had normal backups in last server, vb4.0.6. Now new server, vb 4.1. Manual backups work, but the file is not created.

So I get no error messages, but also no backup file on my directory. Permission is 777, and I get no permission error message.

Any ideas?

[prandah]

Hi, thanks for the excellent product.

In my case, I had normal backups in last server, vb4.0.6. Now new server, vb 4.1. Manual backups work, but the file is not created.

So I get no error messages, but also no backup file on my directory. Permission is 777, and I get no permission error message.

Any ideas?

haha same with me :)
but on my case i login to my cpanel via https://domain.com:2083 it's fine
bakup file on there :). but when i trying login via http://domain.com:2082 my database not on there :)

or if you owner server check it via ssh :)

[mishb68]

You change the permissions on your chosen backup folder to 777.

Thanks so much for this mod, it's unbelievably helpful. I got it working without any problems and I'm not great at this.

I only have one question, isn't setting the permissions to 777 just asking for your database to be accessible to anyone especially if you have your backup folder called something obvious like "backupfolder" or similar?

Update:
I changed my backup folder name to something not guessable, but also changed my permissions to 733, ran the backup and it worked fine. After changing the permissions I navigated to forum/*backupfile name* and got a 403 error (which is fine) but the backup is on the server.

[prandah]

Thanks so much for this mod, it's unbelievably helpful. I got it working without any problems and I'm not great at this.

I only have one question, isn't setting the permissions to 777 just asking for your database to be accessible to anyone especially if you have your backup folder called something obvious like "backupfolder" or similar?

Update:
I changed my backup folder name to something not guessable, but also changed my permissions to 733, ran the backup and it worked fine. After changing the permissions I navigated to forum/*backupfile name* and got a 403 error (which is fine) but the backup is on the server.

AFAIK you can change permission backup name to 644 :D

[steve1966]

Hi thank you for this modification is it better to Combine Files into one backup file or not combine?

thank you

ps i have nominated and rated

[Paul M]

There is no correct answer to that question - do whatever you prefer.

[steve1966]

There is no correct answer to that question - do whatever you prefer.

Thank you

[raagaswaram]

side goes slow while backup running can anything be done?.got a dedi server with 8gb ram too.504 Gateway Time-out nginx

[Paul M]

Set it ti run at a quiet time of day.

[Brandon Sheley]

thanks, updated and it's running fine

although vb.org is running slowwwwwwwwwwwwwwwwwwwwww

[rajubd]

is there any option close forum before taking backup

[Paul M]

Nope.

[MarceloS]

Hi Paul, how are you doing?

Mod is working, but not the gzip part.

My server support guy tested the command and it works.

So when I run the cron job I get this

Processed Database in 235.783 seconds
[Compressing Combined File] : Processed File Compression in 0.022 seconds
Backup Completed Successfully


But the backup folder has only the sql files, no gzip.

Any idea? Thanks

[Paul M]

Sorry, but the issue is server related.

The time of 0.022 seconds suggests the command is failing pretty much instantly. I'd guess at maybe permissions, but Im afraid there is no real way for me to know.

[deverill2010]

Mod installed and working perfectly with gzip. Thanks! I am one who forgets to back up their database.. doh!

So gratefully needed :)

[sivaganeshk]

Where does it store the db by default (../../backups/ ) ?

[Aexo]

edit it with ../backups/ if you forum is in www.yourdomain.com/forum or backups/ if your forum is in www.yourdomain.com/

If your option is (../../backups/ ), your data base backup will store in /backups, out of public_html folder.

Create an empty file called index.html in backups folder.

[sivaganeshk]

@Aexo : Thanks for the quick reply. using backups/ for domain.com
How long does it take to create a first db ??
I made 777 permission for backups folder, is it right ?

[sivaganeshk]

24 hour passed.. still din have any back up .
https://vborg.vbsupport.ru/external/2011/06/32.png

[prandah]

@sivaganeshk check your schedule task :D

[Pionex]

Backup Error : Could not write to destination file ( ../../backups/2011-06-17/Forum-2011-06-17-Access.sql )

Did I skip a step?

[Paul M]

Yes, the step where you create your backup folder, give it the correct permissions, and point the system to it in the settings. :)

[Pionex]

lol, just ignore my posts, I didn't deserve a response on that one :D
I was just rushing everything, and completely forgot about that :)

[chocolate angel]

Thank you SO MUCH for this mod :)

[sivaganeshk]

In case I hav to restore the db, how to do that??
Import all the backup file - one by one?

[MonkYZ]

Thank you for this mod! It's great, but it's missing a must have feature: auto-delete older backups. I just realised i forgot about the /backups folder, and when i looked inside, a month of backups took over 20GB of space!!!

Is it possible to add an option to autodelete files older than... x days? Or just keep x days files. It would save us a lot of time & space! Thanks in advance!

[dmm2020]

I did something different with this. I set my path as /home/accountname/.htbackups/

Reason for the ht prefix is in Apache that folder is hidden.

I also don't have to play around with ../../ etc to get it right.

edit it with ../backups/ if you forum is in www.yourdomain.com/forum or backups/ if your forum is in www.yourdomain.com/

If your option is (../../backups/ ), your data base backup will store in /backups, out of public_html folder.

Create an empty file called index.html in backups folder.

[smartkidbk5]

nvm. i got it. Nice mod :)

[wan4all]

Very nice mod! Thanks!

Got it working after some research. It did not properly copy the mysqlbackup.php file to the includes folder :( But after forcing it to do so, it worked out fine!

Should be nice to administer and set the option to just keep a chosen amount of backups and automatically get rid of obsolete ones, to save serverspace.

[dlewisr]

Took a while to work out the directory, (not tech savy), but I got there. Great mod Paul as usual, marked installed and rated excellent. 9 secs to do the backup.

Thank you

[MonkYZ]

Something got really really wrong... It's not creating the .gz files anymore. It only does sql files (over 2GB each). How can i fix this?

[nacaruncr]

how I can save my backup in gzip??

[MonkYZ]

how I can save my backup in gzip??
In Control Panel - Settings - Options - vBulletin Automatic Backup - you have an option to tick for GZip Files. Unfortunatelly, for me it doesn't work anymore...

[Paul M]

Then you have a server issue. Speak to your host.

[MonkYZ]

Then you have a server issue. Speak to your host.
It's a dedicated server... so i can't talk to my host. I've checked the logs, and i see no errors. Nothing changed since last time Automatic Backup worked. Plus, i do my daily backups using .tar .gz and they work... so gzip is definatelly working.

Or maybe you can tell me where/what to look for that Automatic Backups depends on... Thanks!

[Paul M]

It simply issues a gzip command on the file, so all it depends on is the server doing what it is asked.

[nacaruncr]

Is here where I have to put the extension .gzip or where?
Files Prefix
Backup files prefix, this is applied to all files.

Here I have My-we.gzip... is it ok?

[nacaruncr]

Please, can someone help me?

[HMBeaty]

Is here where I have to put the extension .gzip or where?


Here I have My-we.gzip... is it ok?
No, that's for the prefix.

If you want to enable gzip compression, check this:

AdminCP > Settings > Options > vBulletin Automatic Backup - GZip Files

Make sure that option is set to "Yes"

[nacaruncr]

uhmmm... I have a oldest version XD lol XD thanks men ;)

[dellow]

on safe mod on i get this error :

Fatal error: Maximum execution time of 180 seconds exceeded in /home/xx/public_html/majlis/includes/mysqlbackup.php on line 442

execution time out now 180 and it is dump 1.71 BG then stop and give the above error.

my database size is 2.65 GB

any idia how to get it work with safe mod ON ?

Thank you

[TeknoSounds]

Increase max execution time in your php.ini

[LoveStream]

Hello.

After restore from backup files, the charset went broken.
How could I set the charset for the backup.

:)

[marianoblesa]

Hello

<!-- $Header: F:\CVS/4.x/Auto-backup/Auto-backup.txt,v 1.3 2010/12/04 22:52:33 Pem Exp $ -->

This code must be put somewhere.

Thanks.

[Miihawk]

How can I save the backup on a different server, using ftp ?

[DevOne5555]

How can I save the backup on a different server, using ftp ?

To do an automated remote backup is a little beyond the scope of this script I think. That would require third-party server software (e.g. rsync); if memory serves, you need a set of passwordless ssh keys on both ends so the servers can connect automatically. rsync was really designed for backing up tape drives though, not 1 or 2 files. Cpanel has its own automated remote backup function which works over ftp, but it will only back up user accounts. Most web hosting plans offer some kind of automated backup service.

[washingtonboise]

My sql database is five gigabytes.
It appears that this mod can not support large databases.

This times out when ran manually (even if configured to do just 1,000 records at a time), it also fails when ran automatically via cron.