vBulletin Cron Based Database Backup

[Paul M]

As of 23 Nov 2017 this modification has been withdrawn.

This is a cut down version based on a backup system written by Trigunflame for vb 3.0. It is a simple vBulletin cron trigged php system that does a dump of your database - either as one complete file, or as one file per table. Especially useful now that IB removed the old ACP backup option in vBulletin 4. Files can be (G)Zipped to save space.

All the options are located in the ACP in vBulletin Options >> vBulletin Automatic Backup

To install, download and unzip the files, and follow the instructions in the text file.


History:

v4.0.1 : 28-Dec-2009 : Initial release for vb 4.0.0 Gold.
v4.0.2 : 29-Dec-2009 : Added ability to block process larger tables.
v4.0.3 : 27-Jun-2010 : Added Gzip option.

v4.1.0 : 04-Dec-2010 : Updated for vBulletin 4.1.0.

v4.1.7.0 : 16-Oct-2011 : Updated for vBulletin 4.1.7.

v4.2.0.0 : 24-May-2012 : Updated for vBulletin 4.2.0.
v4.2.0.1 : 17-Mar-2013 : Removed vboptions from backup call..
v4.2.0.2 : 25-Nov-2013 : Fix php 5.3 deprecated warnings, added mysqldump backup.

[utahraves]

Woot woot. Why did they take it out in the first place? duh... i used it all the time.

[Floris]

I care for my site, so I do not trust apache/php/mysql limits from the browser. And use a shell to back it up. This way apache can be down, but I can still make a database. And after 15mb for example on most hosts I still get a complete sql dump.

But strange that they removed it. I guess they didn't add any value to backing up database or something. Good to see a vBulletin.org administrator show he cares about sites too and adding this as a plugin to version 4.

[dodgeboard.com]

Thanks Paul, for your work on this.

Q: How does this deal with PHP script timeouts? Will it work with a 200 mb database for example?

I know that MSD will use refreshes and resume routines to get around script timeouts for large databases...will this do the same?

TIA

[Alecsmith]

Installed very good wwork paul :)

[Paul M]

Q: How does this deal with PHP script timeouts? Will it work with a 200 mb database for example?
It sets the timeout to 1 hour (unless your php setup disallows this).

My database it well over 1GB, and i use this daily (it takes < 5 minutes to run the backup).

[Adem GEN?]

Thank you very much
Installed

[BlackJacket]

This was the last mod i have been waiting for. Thank you very much Paul. Your work is much appreciated.

[dodgeboard.com]

It sets the timeout to 1 hour (unless your php setup disallows this).

My database it well over 1GB, and i use this daily (it takes < 5 minutes to run the backup).


AWESOME! Great Work Paul. Always love your mods! <clicks install>

[Adem GEN?]

My bad English

Installed forum
AND
I wanted to make a backup manually
Can not write file error has
AND
Forum no files within the directory was deleted or I do not see all did not stay

Error occurred: 403 - no permission

[dodgeboard.com]

Things looked like they were going fine until....

Processing poll (72) : Processed 72 Rows in 0.006 seconds
Processing pollvote (2284) : Processed 2284 Rows in 0.176 seconds
Processing post (127205) : Processed 127205 Rows in 18.943 seconds
Processing postedithistory (2571) : Processed 2571 Rows in 0.629 seconds
Processing posthash (7) : Processed 7 Rows in 0.015 seconds
Processing postindex (2778108)

No errors...just froze.

After about an hour on postindex, I gave up. Apparantly, this doesn't work so well on Hostgator shared hosting.

It was worth a try. Thanks anyway Paul. I use many other mods you've created.

UNinstalling.

[JHUMON]

Thanks a lot.

[Bouncer222]

So how do you set the time interval for it to create a backup? And does it create only mysql or public_html (my forums directory) backups or both of them in the backups folder?

I would like to make it per week. How I do that?

[M3xital]

Thanks! Works great.

[KEKforce]

Things looked like they were going fine until....

Processing poll (72) : Processed 72 Rows in 0.006 seconds
Processing pollvote (2284) : Processed 2284 Rows in 0.176 seconds
Processing post (127205) : Processed 127205 Rows in 18.943 seconds
Processing postedithistory (2571) : Processed 2571 Rows in 0.629 seconds
Processing posthash (7) : Processed 7 Rows in 0.015 seconds
Processing postindex (2778108)

No errors...just froze.

After about an hour on postindex, I gave up. Apparantly, this doesn't work so well on Hostgator shared hosting.

It was worth a try. Thanks anyway Paul. I use many other mods you've created.

UNinstalling.

Got the same problem.....

[kisanjong]

Excellent - Thanks installed

Processed Database in 18.805 seconds

Backup Completed Successfully

Done

[phonexpo]

Processed Database in 20.765 seconds

Backup Completed Successfully
Done


Working well for me :)

Thanks Paul,

-Patrick

[Paul M]

No errors...just froze.

After about an hour on postindex, I gave up. Apparantly, this doesn't work so well on Hostgator shared hosting.

Hostgator probably timeout the script (The mod trys to set it to one hour, but some hosts disallow their timeout from being changed).

Given that it took 18.9 seconds to process about 127000 rows, then 2778108 is going to take about 20 times longer (over 6 minutes).

The only way I can think of getting round this is to process larger record counts in batches. It would have to be optional as it would probably slow down the backup, and not everyone would need it, but may help your issue. I will provide a beta version for people to test later.

[Edrondol]

Worked perfectly. Great work! I know my host does daily backups, but this prevents me from having to wait until they look at a trouble ticket, etc.

[kisanjong]

So how do you set the time interval for it to create a backup? And does it create only mysql or public_html (my forums directory) backups or both of them in the backups folder?

I would like to make it per week. How I do that?


goto Scheduled Tasks/Scheduled Task Manager in admincp and edit Automatic Database Backup for vBulletin settings.

[Anseur]

Just FYI Hostgators script kills anything longer than 30 seconds. (at least, that's what they told me in a support ticket about an unrelated matter)

might look at this if Paul's next version works ok for me with splitting it up.

[Delilahs]

cheers Paul.

Installed and working fine.

[Paul M]

Just FYI Hostgators script kills anything longer than 30 seconds. (at least, that's what they told me in a support ticket about an unrelated matter)

might look at this if Paul's next version works ok for me with splitting it up.

Try 4.0.2 (check the options).

This is all I can do, if this fails then tbh, all I can suggest is move to a decent host ;)

[utahraves]

I installed this and it slowed my server down more than anything I've ever used before; I actually ended up with database errors after using and had to take my server down for six hours to resolve. I didn't even get any of the "processing" status messages like others did... just completely frozen. I'll just stick with backing it up on the SQL side for now. Love your products though, Paul :) *uninstalled*

[Front Range 4x4]

*installed* Thanks Paul!

[Adem GEN?]

Hi,
My bad English

Create a backup directory for each mysql
As 3.8.x
3.8.4
108553

4.0.0
108554


Combine Files: No, No is selected, the necessary

Regards

[Paul M]

I installed this and it slowed my server down more than anything I've ever used before; I actually ended up with database errors after using and had to take my server down for six hours to resolve. I didn't even get any of the "processing" status messages like others did... just completely frozen. I'll just stick with backing it up on the SQL side for now. Love your products though, Paul :) *uninstalled*

This only runs once a day, at 6am. I dont see how simply installing it could possibly have the effect you describe.

[Paul M]

Hi,
My bad English

Create a backup directory for each mysql
As 3.8.x
3.8.4
108553

4.0.0
108554


Combine Files: No, No is selected, the necessary

Regards
If "No" is selected for the Combine option then it will create the folder (and individual files), that has not changed.

[Adem GEN?]

If "No" is selected for the Combine option then it will create the folder (and individual files), that has not changed.
Yes, Thank you very much

[Gleedo]

Thanks Paul :)

Clicks Installed

[linuxututs]

Just like to say Thanks For You releasing a 4.0 version of this GREAT utility.

Thanks,

[linuxututs]

I installed this and it slowed my server down more than anything I've ever used before; I actually ended up with database errors after using and had to take my server down for six hours to resolve. I didn't even get any of the "processing" status messages like others did... just completely frozen. I'll just stick with backing it up on the SQL side for now. Love your products though, Paul :) *uninstalled*

utomatic Database Backup for vBulletin
Processing access (No Data)
Processing action (18) : Processed 18 Rows in 0.181 Seconds
Processing ad (No Data)
Processing adcriteria (No Data)
Processing adminhelp (1748) : Processed 1748 Rows in 0.39 Seconds
Processing administrator (1) : Processed 1 Rows in 0.001 Seconds
Processing adminlog (16691) : Processed 16691 Rows in 3.505 Seconds
Processing adminmessage (2) : Processed 2 Rows in 0.077 Seconds
Processing adminutil (2) : Processed 2 Rows in 0.155 Seconds
Processing adv_links (2) : Processed 2 Rows in 0.092 Seconds
Processing adv_links_banners (No Data)
Processing adv_links_categories (16) : Processed 16 Rows in 0.03 Seconds
Processing adv_links_catids (2) : Processed 2 Rows in 0.161 Seconds
Processing adv_links_cfields (No Data)
Processing adv_links_cfields_entries (No Data)
Processing adv_links_deletionlog (No Data)
Processing adv_links_extcache (2) : Processed 2 Rows in 0.041 Seconds
Processing adv_links_favorites (No Data)
Processing adv_links_moderator (No Data)
Processing adv_links_permissions (No Data)
Processing adv_links_posts (No Data)
Processing adv_links_rate (1) : Processed 1 Rows in 0.059 Seconds
Processing adv_links_reports (1) : Processed 1 Rows in 0.158 Seconds
Processing adv_links_search (No Data)
Processing adv_links_subscribecat (No Data)
Processing adv_links_subscribelink (No Data)
Processing adv_modules (26) : Processed 26 Rows in 0.11 Seconds
Processing adv_pages (2) : Processed 2 Rows in 0.122 Seconds
Processing adv_pages_user (No Data)
Processing adv_setting (287) : Processed 287 Rows in 0.071 Seconds
Processing adv_settinggroup (16) : Processed 16 Rows in 1.268 Seconds
Processing album (No Data)
Processing albumupdate (No Data)
Processing announcement (2) : Processed 2 Rows in 0.053 Seconds
Processing announcementread (1) : Processed 1 Rows in 0.189 Seconds
Processing attachment (35) : Processed 35 Rows in 0.082 Seconds
Processing attachmentcategory (No Data)
Processing attachmentcategoryuser (35) : Processed 35 Rows in 0.762 Seconds
Processing attachmentpermission (1) : Processed 1 Rows in 0.277 Seconds
Processing attachmenttype (43) : Processed 43 Rows in 0.144 Seconds
Processing attachmentviews (16) : Processed 16 Rows in 0.053 Seconds
Processing avatar (50) : Processed 50 Rows in 0.146 Seconds
Processing bbcode (2) : Processed 2 Rows in 0.109 Seconds
Processing bbcode_video (7) : Processed 7 Rows in 0.322 Seconds
Processing block (No Data)
Processing blockconfig (No Data)
Processing blocktype (7) : Processed 7 Rows in 0.131 Seconds
Processing blog (No Data)
Processing blog_attachment (No Data)
Processing blog_attachmentviews (No Data)
Processing blog_category (No Data)
Processing blog_categorypermission (No Data)
Processing blog_categoryuser (No Data)
Processing blog_custom_block (No Data)
Processing blog_custom_block_parsed (No Data)
Processing blog_deletionlog (No Data)
Processing blog_editlog (No Data)
Processing blog_featured (No Data)
Processing blog_groupmembership (No Data)
Processing blog_grouppermission (No Data)
Processing blog_hash (No Data)
Processing blog_moderation (No Data)
Processing blog_moderator (No Data)
Processing blog_pinghistory (No Data)
Processing blog_rate (No Data)
Processing blog_read (No Data)
Processing blog_relationship (No Data)
Processing blog_search (No Data)
Processing blog_searchresult (No Data)
Processing blog_subscribeentry (No Data)
Processing blog_subscribeuser (No Data)
Processing blog_summarystats (No Data)
Processing blog_tachyentry (No Data)
Processing blog_text (No Data)
Processing blog_textparsed (No Data)
Processing blog_trackback (No Data)
Processing blog_trackbacklog (No Data)
Processing blog_user (No Data)
Processing blog_usercss (No Data)
Processing blog_usercsscache (No Data)
Processing blog_userread (No Data)
Processing blog_userstats (No Data)
Processing blog_views (No Data)
Processing blog_visitor (No Data)
Processing bookmarksite (4) : Processed 4 Rows in 0.062 Seconds
Processing cache (17) : Processed 17 Rows in 0.003 Seconds
Processing cacheevent (30) : Processed 30 Rows in 0.001 Seconds
Processing calendar (1) : Processed 1 Rows in 0.034 Seconds
Processing calendarcustomfield (No Data)
Processing calendarmoderator (No Data)
Processing calendarpermission (No Data)
Processing cms_article (21) : Processed 21 Rows in 0.026 Seconds
Processing cms_category (28) : Processed 28 Rows in 0.03 Seconds
Processing cms_grid (9) : Processed 9 Rows in 0.034 Seconds
Processing cms_layout (5) : Processed 5 Rows in 0.048 Seconds
Processing cms_layoutwidget (22) : Processed 22 Rows in 0.02 Seconds
Processing cms_navigation (3) : Processed 3 Rows in 0.001 Seconds
Processing cms_node (28) : Processed 28 Rows in 0.017 Seconds
Processing cms_nodecategory (48) : Processed 48 Rows in 0.023 Seconds
Processing cms_nodeconfig (35) : Processed 35 Rows in 0.019 Seconds
Processing cms_nodeinfo (28) : Processed 28 Rows in 0.023 Seconds
Processing cms_permissions (32) : Processed 32 Rows in 0.044 Seconds
Processing cms_rate (No Data)
Processing cms_sectionorder (14) : Processed 14 Rows in 0.001 Seconds
Processing cms_widget (19) : Processed 19 Rows in 0.112 Seconds
Processing cms_widgetconfig (96) : Processed 96 Rows in 0.028 Seconds
Processing cms_widgettype (13) : Processed 13 Rows in 0.001 Seconds
Processing contentpriority (No Data)
Processing contenttype (19) : Processed 19 Rows in 0.057 Seconds
Processing cpsession (1) : Processed 1 Rows in 0.025 Seconds
Processing cron (27) : Processed 27 Rows in 0.003 Seconds
Processing cronlog (2798) : Processed 2798 Rows in 0.102 Seconds
Processing customavatar (1) : Processed 1 Rows in 0.166 Seconds
Processing customprofilepic (No Data)
Processing datastore (64) : Processed 64 Rows in 0.116 Seconds
Processing deletionlog (No Data)
Processing discussion (No Data)
Processing discussionread (No Data)
Processing editlog (36) : Processed 36 Rows in 0.034 Seconds
Processing event (1) : Processed 1 Rows in 0.001 Seconds
Processing externalcache (2) : Processed 2 Rows in 0.011 Seconds
Processing faq (63) : Processed 63 Rows in 0.015 Seconds
Processing filedata (35) : Processed 35 Rows in 0.164 Seconds
Processing files (30) : Processed 30 Rows in 0.1 Seconds
Processing forum (1530) : Processed 1530 Rows in 0.279 Seconds
Processing forumpermission (44) : Processed 44 Rows in 0.06 Seconds
Processing forumprefixset (No Data)
Processing forumread (44) : Processed 44 Rows in 0.002 Seconds
Processing groupmessage (No Data)
Processing groupmessage_hash (No Data)
Processing groupread (No Data)
Processing holiday (No Data)
Processing humanverify (1) : Processed 1 Rows in 0.037 Seconds
Processing hvanswer (No Data)
Processing hvquestion (No Data)
Processing icon (14) : Processed 14 Rows in 0.001 Seconds
Processing imagecategory (5) : Processed 5 Rows in 0.016 Seconds
Processing imagecategorypermission (No Data)
Processing indexqueue (No Data)
Processing infraction (No Data)
Processing infractionban (No Data)
Processing infractiongroup (No Data)
Processing infractionlevel (4) : Processed 4 Rows in 0.001 Seconds
Processing language (1) : Processed 1 Rows in 0.045 Seconds
Processing mailqueue (No Data)
Processing moderation (No Data)
Processing moderator (1) : Processed 1 Rows in 0.064 Seconds
Processing moderatorlog (218) : Processed 218 Rows in 0.101 Seconds
Processing notice (1) : Processed 1 Rows in 0.053 Seconds
Processing noticecriteria (1) : Processed 1 Rows in 0.02 Seconds
Processing noticedismissed (No Data)
Processing package (3) : Processed 3 Rows in 0.001 Seconds
Processing passwordhistory (8) : Processed 8 Rows in 0.029 Seconds
Processing paymentapi (7) : Processed 7 Rows in 0.002 Seconds
Processing paymentinfo (No Data)
Processing paymenttransaction (No Data)
Processing peers (10) : Processed 10 Rows in 0.023 Seconds
Processing phrase (14319) : Processed 14319 Rows in 0.852 Seconds
Processing phrasetype (79) : Processed 79 Rows in 0.055 Seconds
Processing picturecomment (No Data)
Processing picturecomment_hash (No Data)
Processing picturelegacy (No Data)
Processing plugin (123) : Processed 123 Rows in 0.097 Seconds
Processing pm (45) : Processed 45 Rows in 0.061 Seconds
Processing pmreceipt (No Data)
Processing pmtext (33) : Processed 33 Rows in 0.086 Seconds
Processing pmthrottle (No Data)
Processing podcast (No Data)
Processing podcastitem (No Data)
Processing poll (3) : Processed 3 Rows in 0.048 Seconds
Processing pollvote (No Data)
Processing post (215) : Processed 215 Rows in 0.028 Seconds
Processing postedithistory (101) : Processed 101 Rows in 0.248 Seconds
Processing posthash (4) : Processed 4 Rows in 0.041 Seconds
Processing postindex (No Data)
Processing postlog (29) : Processed 29 Rows in 0.034 Seconds
Processing postparsed (394) : Processed 394 Rows in 0.149 Seconds
Processing prefix (No Data)
Processing prefixpermission (No Data)
Processing prefixset (No Data)
Processing product (6) : Processed 6 Rows in 0.029 Seconds
Processing productcode (34) : Processed 34 Rows in 0.078 Seconds
Processing productdependency (4) : Processed 4 Rows in 0.054 Seconds
Processing profileblockprivacy (No Data)
Processing profilefield (11) : Processed 11 Rows in 0.027 Seconds
Processing profilefieldcategory (No Data)
Processing profilevisitor (13) : Processed 13 Rows in 0.013 Seconds
Processing ranks (15) : Processed 15 Rows in 0.078 Seconds
Processing reminder (No Data)
Processing reputation (6) : Processed 6 Rows in 0.058 Seconds
Processing reputationlevel (15) : Processed 15 Rows in 0.074 Seconds
Processing route (5) : Processed 5 Rows in 0.034 Seconds
Processing rssfeed (1) : Processed 1 Rows in 0.001 Seconds
Processing rsslog (65) : Processed 65 Rows in 0.027 Seconds
Processing searchcore (1746) : Processed 1746 Rows in 0.229 Seconds
Processing searchcore_text (1746) : Processed 1746 Rows in 1.581 Seconds
Processing searchgroup (1749) : Processed 1749 Rows in 0.104 Seconds
Processing searchgroup_text (1749) : Processed 1749 Rows in 0.037 Seconds
Processing searchlog (191) : Processed 191 Rows in 0.148 Seconds
Processing session (11) : Processed 11 Rows in 0.025 Seconds
Processing setting (555) : Processed 555 Rows in 0.037 Seconds
Processing settinggroup (59) : Processed 59 Rows in 0.002 Seconds
Processing sigparsed (3) : Processed 3 Rows in 0.001 Seconds
Processing sigpic (1) : Processed 1 Rows in 0.025 Seconds
Processing smilie (54) : Processed 54 Rows in 0.107 Seconds
Processing socialgroup (No Data)
Processing socialgroupcategory (1) : Processed 1 Rows in 0.229 Seconds
Processing socialgroupicon (No Data)
Processing socialgroupmember (No Data)
Processing spamlog (No Data)
Processing stats (83) : Processed 83 Rows in 0.061 Seconds
Processing strikes (No Data)
Processing style (2) : Processed 2 Rows in 0.076 Seconds
Processing stylevar (449) : Processed 449 Rows in 0.083 Seconds
Processing stylevardfn (451) : Processed 451 Rows in 0.104 Seconds
Processing subscribediscussion (No Data)
Processing subscribeevent (No Data)
Processing subscribeforum (No Data)
Processing subscribegroup (No Data)
Processing subscribethread (No Data)
Processing subscription (No Data)
Processing subscriptionlog (No Data)
Processing subscriptionpermission (No Data)
Processing tachyforumcounter (No Data)
Processing tachyforumpost (No Data)
Processing tachythreadcounter (No Data)
Processing tachythreadpost (No Data)
Processing tag (252) : Processed 252 Rows in 0.008 Seconds
Processing tagcontent (1297) : Processed 1297 Rows in 0.067 Seconds
Processing tagsearch (36429) : Processed 36429 Rows in 0.782 Seconds
Processing template (1583) : Processed 1583 Rows in 1.182 Seconds
Processing templatehistory (6) : Processed 6 Rows in 0.028 Seconds
Processing templatemerge (No Data)
Processing thread (213) : Processed 213 Rows in 0.055 Seconds
Processing threadrate (4) : Processed 4 Rows in 0.054 Seconds
Processing threadread (12) : Processed 12 Rows in 0.001 Seconds
Processing threadredirect (No Data)
Processing threadviews (No Data)
Processing trackerhistory (94) : Processed 94 Rows in 0.097 Seconds
Processing umg_rating (No Data)
Processing upgradelog (40) : Processed 40 Rows in 0.066 Seconds
Processing user (9) : Processed 9 Rows in 0.027 Seconds
Processing useractivation (1) : Processed 1 Rows in 0.211 Seconds
Processing userban (No Data)
Processing userchangelog (12) : Processed 12 Rows in 0.009 Seconds
Processing usercss (No Data)
Processing usercsscache (No Data)
Processing userfield (9) : Processed 9 Rows in 0.011 Seconds
Processing usergroup (10) : Processed 10 Rows in 0.033 Seconds
Processing usergroupleader (No Data)
Processing usergrouprequest (No Data)
Processing userlist (3) : Processed 3 Rows in 0.001 Seconds
Processing usernote (No Data)
Processing userpromotion (No Data)
Processing usertextfield (9) : Processed 9 Rows in 0.001 Seconds
Processing usertitle (4) : Processed 4 Rows in 0.056 Seconds
Processing vbseo_blacklist (164) : Processed 164 Rows in 0.08 Seconds
Processing vbseo_linkback (3) : Processed 3 Rows in 0.041 Seconds
Processing vbseo_serviceupdate (No Data)
Processing vbstopforumspam (No Data)
Processing vbstopforumspam_log (1) : Processed 1 Rows in 0.051 Seconds
Processing vbstopforumspam_remotecache (1) : Processed 1 Rows in 0.059 Seconds
Processing visitormessage (6) : Processed 6 Rows in 0.001 Seconds
Processing visitormessage_hash (No Data)

Processed Database in 18.686 seconds

Backup Completed Successfully

Done

And I have over 1,600 forums built so far on my new site.
This is really a Great mod to have.

Thanks again,

[rajubd]

its stops in middle what could be the problem?
Processing vbaccess (No Data)
Processing vbaction (No Data)
Processing vbad (No Data)
Processing vbadcriteria (No Data)
Processing vbadminhelp (1666) : Processed 1666 Rows in 0.327 Seconds
Processing vbadministrator (1) : Processed 1 Rows in 0.008 Seconds
Processing vbadminlog (10582) : Processed 10582 Rows in 5.025 Seconds
Processing vbadminmessage (2) : Processed 2 Rows in 0.023 Seconds
Processing vbadminutil (2) : Processed 2 Rows in 0.019 Seconds
Processing vbalbum (10) : Processed 10 Rows in 0.049 Seconds
Processing vbalbumupdate (No Data)
Processing vbannouncement (4) : Processed 4 Rows in 0.034 Seconds
Processing vbannouncementread (663) : Processed 663 Rows in 0.226 Seconds
Processing vbattachment (7375) : Processed 7375 Rows in 10.626 Seconds
Processing vbattachmentcategory (1) : Processed 1 Rows in 0.014 Seconds
Processing vbattachmentcategoryuser (7383) : Processed 7383 Rows in 1.989 Seconds
Processing vbattachmentpermission (No Data)
Processing vbattachmenttype (15) : Processed 15 Rows in 0.005 Seconds
Processing vbattachmentviews (125) : Processed 125 Rows in 0.009 Seconds
Processing vbavatar (No Data)
Processing vbbbcode (No Data)
Processing vbbbcode_video (7) : Processed 7 Rows in 0.024 Seconds
Processing vbblock (4) : Processed 4 Rows in 0.039 Seconds
Processing vbblockconfig (20) : Processed 20 Rows in 0.086 Seconds
Processing vbblocktype (7) : Processed 7 Rows in 0.053 Seconds
Processing vbbookmarksite (4) : Processed 4 Rows in 0.008 Seconds
Processing vbcache (1) : Processed 1 Rows in 0.01 Seconds
Processing vbcacheevent (3) : Processed 3 Rows in 0.002 Seconds
Processing vbcalendar (1) : Processed 1 Rows in 0.08 Seconds
Processing vbcalendarcustomfield (No Data)
Processing vbcalendarmoderator (No Data)
Processing vbcalendarpermission (No Data)
Processing vbcontentpriority (No Data)
Processing vbcontenttype (14) : Processed 14 Rows in 0.103 Seconds
Processing vbcpsession (2) : Processed 2 Rows in 0.031 Seconds
Processing vbcron (19) : Processed 19 Rows in 0.049 Seconds
Processing vbcronlog (1437) : Processed 1437 Rows in 0.436 Seconds
Processing vbcustomavatar (160) : Processed 160 Rows in 0.279 Seconds
Processing vbcustomprofilepic (119) : Processed 119 Rows in 0.29 Seconds
Processing vbdatastore (35) : Processed 35 Rows in 0.033 Seconds
Processing vbdeletionlog (290) : Processed 290 Rows in 0.055 Seconds
Processing vbdiscussion (3) : Processed 3 Rows in 0.015 Seconds
Processing vbdiscussionread (No Data)
Processing vbeditlog (2970) : Processed 2970 Rows in 0.396 Seconds
Processing vbevent (No Data)
Processing vbexternalcache (29) : Processed 29 Rows in 0.641 Seconds
Processing vbfaq (42) : Processed 42 Rows in 0.015 Seconds
Processing vbfiledata (6997) : Processed 6997 Rows in 7.344 Seconds
Processing vbforum (37) : Processed 37 Rows in 0.201 Seconds
Processing vbforumpermission (7) : Processed 7 Rows in 0.01 Seconds
Processing vbforumprefixset (15) : Processed 15 Rows in 0.063 Seconds
Processing vbforumread (No Data)
Processing vbgroupmessage (19) : Processed 19 Rows in 0.033 Seconds
Processing vbgroupmessage_hash (16) : Processed 16 Rows in 0.021 Seconds
Processing vbgroupread (No Data)
Processing vbholiday (No Data)
Processing vbhumanverify (52) : Processed 52 Rows in 0.013 Seconds
Processing vbhvanswer (No Data)
Processing vbhvquestion (1) : Processed 1 Rows in 0.005 Seconds
Processing vbicon (20) : Processed 20 Rows in 0.012 Seconds
Processing vbimagecategory (3) : Processed 3 Rows in 0.404 Seconds
Processing vbimagecategorypermission (No Data)
Processing vbindexqueue (No Data)
Processing vbinfraction (24) : Processed 24 Rows in 0.02 Seconds
Processing vbinfractionban (No Data)
Processing vbinfractiongroup (No Data)
Processing vbinfractionlevel (4) : Processed 4 Rows in 0.021 Seconds
Processing vblanguage (1) : Processed 1 Rows in 0.069 Seconds
Processing vblinkback (No Data)
Processing vbmailqueue (No Data)
Processing vbmoderation (6) : Processed 6 Rows in 0.051 Seconds
Processing vbmoderator (262) : Processed 262 Rows in 0.082 Seconds
Processing vbmoderatorlog (12948) : Processed 12948 Rows in 16.08 Seconds
Processing vbnotice (1) : Processed 1 Rows in 0.014 Seconds
Processing vbnoticecriteria (1) : Processed 1 Rows in 0.005 Seconds
Processing vbnoticedismissed (No Data)
Processing vbpackage (1) : Processed 1 Rows in 0.013 Seconds
Processing vbpasswordhistory (24929) : Processed 24929 Rows in 7.912 Seconds
Processing vbpaymentapi (7) : Processed 7 Rows in 0.078 Seconds
Processing vbpaymentinfo (No Data)
Processing vbpaymenttransaction (No Data)
Processing vbphrase (12296) : Processed 12296 Rows in 7.999 Seconds
Processing vbphrasetype (70) : Processed 70 Rows in 0.041 Seconds
Processing vbpicturecomment (2) : Processed 2 Rows in 0.032 Seconds
Processing vbpicturecomment_hash (2) : Processed 2 Rows in 0.032 Seconds
Processing vbpicturelegacy (17) : Processed 17 Rows in 0.05 Seconds
Processing vbplugin (20) : Processed 20 Rows in 0.047 Seconds
Processing vbpm (2166) : Processed 2166 Rows in 0.463 Seconds
Processing vbpmreceipt (129) : Processed 129 Rows in 0.105 Seconds
Processing vbpmtext (1749) : Processed 1749 Rows in 1.542 Seconds
Processing vbpmthrottle (No Data)
Processing vbpodcast (No Data)
Processing vbpodcastitem (No Data)
Processing vbpoll (17) : Processed 17 Rows in 0.028 Seconds
Processing vbpollvote (327) : Processed 327 Rows in 0.076 Seconds
Processing vbpost (33673) : Processed 33673 Rows in 30.735 Seconds
Processing vbpostedithistory (2573) : Processed 2573 Rows in 1.517 Seconds
Processing vbposthash (4) : Processed 4 Rows in 0.004 Seconds
Processing vbpostindex (No Data)
Processing vbpostlog (2317) : Processed 2317 Rows in 0.375 Seconds
Processing vbpostparsed (7753) : Processed 7753 Rows in 10.75 Seconds
Processing vbprefix (26) : Processed 26 Rows in 0.006 Seconds
Processing vbprefixpermission (No Data)
Processing vbprefixset (6) : Processed 6 Rows in 0.088 Seconds
Processing vbproduct (8) : Processed 8 Rows in 0.053 Seconds
Processing vbproductcode (4) : Processed 4 Rows in 0.022 Seconds
Processing vbproductdependency (2) : Processed 2 Rows in 0.066 Seconds
Processing vbprofileblockprivacy (216) : Processed 216 Rows in 0.183 Seconds
Processing vbprofilefield (4) : Processed 4 Rows in 0.094 Seconds
Processing vbprofilefieldcategory (No Data)
Processing vbprofilevisitor (1501) : Processed 1501 Rows in 0.903 Seconds
Processing vbranks (No Data)
Processing vbreminder (No Data)
Processing vbreputation (4260) : Processed 4260 Rows in 1.236 Seconds
Processing vbreputationlevel (15) : Processed 15 Rows in 0.011 Seconds
Processing vbroute (1) : Processed 1 Rows in 0.009 Seconds
Processing vbrssfeed (No Data)
Processing vbrsslog (No Data)
Processing vbsearchcore (34729) : Processed 34729 Rows in 15.824 Seconds
Processing vbsearchcore_text (34749) : Processed 34749 Rows in 16.462 Seconds
Processing vbsearchgroup (14292) : Processed 14292 Rows in 5.327 Seconds
Processing vbsearchgroup_text (14299) : Processed 14299 Rows in 3.783 Seconds
Processing vbsearchlog (597) : Processed 597 Rows in 0.523 Seconds
Processing vbsession (1976) : Processed 1976 Rows in 0.872 Seconds
Processing vbsetting (455) : Processed 455 Rows in 0.286 Seconds
Processing vbsettinggroup (55) : Processed 55 Rows in 0.017 Seconds
Processing vbsigparsed (142) : Processed 142 Rows in 0.136 Seconds
Processing vbsigpic (21) : Processed 21 Rows in 0.044 Seconds
Processing vbsmilie (41) : Processed 41 Rows in 0.016 Seconds
Processing vbsocialgroup (5) : Processed 5 Rows in 0.006 Seconds
Processing vbsocialgroupcategory (1) : Processed 1 Rows in 0.023 Seconds
Processing vbsocialgroupicon (5) : Processed 5 Rows in 0.025 Seconds
Processing vbsocialgroupmember (32) : Processed 32 Rows in 0.017 Seconds
Processing vbspamlog (No Data)
Processing vbstats (256) : Processed 256 Rows in 0.058 Seconds
Processing vbstrikes (29) : Processed 29 Rows in 0.027 Seconds
Processing vbstyle (2) : Processed 2 Rows in 0.058 Seconds
Processing vbstylevar (631) : Processed 631 Rows in 0.118 Seconds
Processing vbstylevardfn (361) : Processed 361 Rows in 0.102 Seconds
Processing vbsubscribediscussion (No Data)
Processing vbsubscribeevent (No Data)
Processing vbsubscribeforum (10) : Processed 10 Rows in 0.01 Seconds
Processing vbsubscribegroup (1) : Processed 1 Rows in 0.009 Seconds
Processing vbsubscribethread (1982) : Processed 1982 Rows in 0.271 Seconds
Processing vbsubscription (No Data)
Processing vbsubscriptionlog (No Data)
Processing vbsubscriptionpermission (No Data)
Processing vbtachyforumcounter (No Data)
Processing vbtachyforumpost (No Data)
Processing vbtachythreadcounter (No Data)
Processing vbtachythreadpost (No Data)
Processing vbtag (12116) : Processed 12116 Rows in 3.427 Seconds
Processing vbtagcontent (64171) : Processed 64171 Rows in 12.266 Seconds
Processing vbtaggregate_temp_1245221760 (No Data)
Processing vbtagsearch (36236)

[voglermc]

15.6 secs! wow

[PPUS]

Been waiting for this too. Thanks for your work Paul!

[Veer]

Processed Database in 49.229 seconds (223 MB)

Backup Completed Successfully

Thanks.

[Dr.osamA]

installed

thanxx
________
MEDICAL MARIJUANA (http://mmjp.org)

[t2cervens]

thanks for the mod
I'm on hostgator
when I try to perform a full backup, all seems ok
but it stops to
.....
.....
Processing postindex (2241365)

nothing below

in the backup directory, I can see a 220 megs sql file

is it a full good backup ? I don't know... I think i should get a confirmation message ( like backup is ok ) ?

is there something I should modify ?

tia

[Paul M]

Turn on the block processing and see what happens.

[note2you]

i tries manual and found error

Automatic Database Backup for vBulletin
Backup Error : Could not write to destination file ( .../bkp/vbulletin_backup/2010-01-01/Forum-2010-01-01-Vb_access.sql )

how to fix it

[Paul M]

Check your permissions so that apache can write to the folder (and check that path, three dots seems wrong to me).

[kjpp]

Hi!

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

Warning: include_once() [function.include]: Failed opening '[path]/./includes/cron/cronbackup.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/admincp/cronadmin.php on line 113
What I do wrong?

Regards
kjpp

[Kat00]

Looks like a nice mod but what is the advantage of using this over a Cron in CPanel?

[Paul M]

Warning: include_once() [function.include]: Failed opening '[path]/./includes/cron/cronbackup.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/admincp/cronadmin.php on line 113
What I do wrong?

You have not uploaded all the files to the correct place, it cannot find cronbackup.php

[Paul M]

Looks like a nice mod but what is the advantage of using this over a Cron in CPanel?

How you do backups is mostly personal choice, if you prefer to use cpanel then do so :)

[kjpp]

You have not uploaded all the files to the correct place, it cannot find cronbackup.php

Yes, that Was the problem. Thank You

[t2cervens]

Turn on the block processing and see what happens.

ok

i did it with the default value 100 000 ... the progression was better but it freezezd again

setting it up to 150 000 ...and ok it did the job to the end
thanks

i just hope this backup is ok, just in case ;) ....

[Paul M]

Ok, it worked on a higher value ? That makes no sense ......

[capy]

guys I need a little help here.. I feel kinda stupid for asking but vbulletin and every thing it includes is new to me.. anyway, i have installed "Cron Based Database Backup". and I find the app in settings->options->vBulletin Automatic Backup in admincp. but what should I put in "Backups Path"? and where should I make the folder?? and what is an "relative path"? and setting the backups folder to 777 is not the brightest idea is it?

[Paul M]

Setting the folder to 777 is normally required to allow apache write access. The location is down to you, but outside of your web folder is generally best.

[capy]

ok. got it to work now. I used /backups/ in stead of backups/ . Thanks for the help:)

[meissenation]

Thanks Paul!

[firebrand4]

Hey I'm getting this error:
Backup Error : Could not write to destination file ( http://(website).com/backups/2010-01-06/Forum-2010-01-06-Access.sql )

I set the folder to be 777 and also tried this with various relative paths and keep getting the same error. Can someone tell me what settings I need to check? I'm running a dedicated VPS on Plesk. I'm a vB and Apache noob and don't know anything about server permissions. Thanks

[Paul M]

The path you have entered is completely invalid, you appear to have put in a web page address.

[Dream]

This removed the mod "member tracking" by you on install :/

[Paul M]

This removed the mod "member tracking" by you on install :/
Eeek, so it does - those pids shouldnt be there, removed and re-uploaded.

You can just re-import the Member Tracking XML and it should be fine.

[abdelghani68]

thanks for your works.

how to do the backup with this hack in uft8 language please ?

[Bouncer222]

I don't quiet understand how to use this mod, from my understanding, does it do only a mysql database backup or a file directory backup as well? What exactly does it do?

And how do I set it to do a backup every 1 week?

And finally... my backups folder is at www.brotherhoodofgamers.com/backups so the directory should be : ../backups/ yes?

in my FTP it shows up as /public_html/backups/

Please let me know, thanks.

[utahraves]

I decided to upgrade to 4.0.1 and reinstall this. Works fine now :)
However, it stated it "Processed Database in -9934.818 seconds"

[utahraves]

I don't quiet understand how to use this mod, from my understanding, does it do only a mysql database backup or a file directory backup as well? What exactly does it do?

And how do I set it to do a backup every 1 week?

And finally... my backups folder is at www.brotherhoodofgamers.com/backups (http://www.brotherhoodofgamers.com/backups) so the directory should be : ../backups/ yes?

in my FTP it shows up as /public_html/backups/

Please let me know, thanks.
http://www.brotherhoodofgamers.com/admincp/cronadmin.php?do=modify
Thats how you modify when the scheduled task goes...

I put my backups in the regular DOMAIN.COM/backups/ and i used ./backups/

[Hitterman]

Excellent Mod! I have installed :)

[Hitterman]

just use this in the backup,
../backup
This will make backups in your website root :)

[Bouncer222]

so is it ../backup ./backups/ or ../buckups/ which one?

[Paul M]

Whatever you want, the choice is yours.

[Bouncer222]

well if it's in www.brotherhoodofgamers.com/backups aka public_html/backups then can I put
./backups/ ?

[snerd]

Thanks! Small database, 18.5mb, took 1.738 seconds! :)

[Paul M]

well if it's in www.brotherhoodofgamers.com/backups aka public_html/backups then can I put
./backups/ ?
Impossible to say without knowing where your forum files are in relation to it.

[Bouncer222]

my forum files are in public_html folder , same directory my backups folder is in.

[radmoose]

Simple, direct, works as advertised.

I kinda doubted that this was going to do what I want nor work as I wanted.

Just say that my doubts were unfounded.

It exceeded my expectations and worked flawlessly.

Don't know why I had any doubts, as Paul M makes great plug-ins.

It's simple, but is something that all vBulletin admins should have installed.

[princeedward]

my forum files are in public_html folder , same directory my backups folder is in.hi...just try something like this...

././backups/

then make a test by

Go Scheduled Tasks > Scheduled Tasks Manager > Automatic Database Backup for vBulletin > Run Now...

it will run auto....if not....just change something else....hope it works for you....

;)

[radmoose]

Just a suggestion for everyone....

If at all possible, do NOT put the backups into a folder in your main HTML folder as that would make them by default readable by anyone.

You should at least password protect the folder as the SQL backups do contain personal information that should be secured.

If at all possible, I recommend having the backups go into a folder in your user or home directory that you can access via FTP, but not via HTTP.

Fortunately, this mod will let you choose exactly where you want it to write the backup.

[trilogy33]

Installed and working on vB4.01 :)
Processed Database in 16.069 seconds

Thank you!!

[rotor]

Installed working great on 4.0.1 also - great stuff - thx

Processed Database in 36.244 seconds

Backup Completed SuccessfullyDone

[Bouncer222]

K so it appears to be making a backup by the scheduled time.

Just one question, I have a suite version so I was wondering, although it probably doesnt matter if its suite or forum or maybe it does, dont know....

Does it make a backup of the full mysql database that the site uses or just like a portion like the forums only or something?

[Paul M]

It backs up any table in the database.

[Bob_R]

Does anyone know if this add-on is still a problem with a Hostgator account?

[Bouncer222]

I have hostgator and it seems to be working.

[Paul M]

Does anyone know if this add-on is still a problem with a Hostgator account?
Unless your database is small I would imagine Hostgator will always be a problem - because of their stupid timout settings.

[Bob_R]

Unless your database is small I would imagine Hostgator will always be a problem - because of their stupid timout settings.

What web hosts (shared) do you recommend?

[Paul M]

I dont do recommendations, there are plenty of posts on the subject at vb.com if your looking for one :)

[spagman]

Works Great on 4.0.1
*marked as installed

[Keldaria]

Installed... but currently disabled, I think I wanna take a few manual backups and compare with my normal backups before I trust it to handle my backups by itself... but a great backup from the looks of it

[Bob_R]

Should I delete the 3.x version of this and then install the new one for my 4.0.1 board?

Please advise. :)

[Paul M]

Yes. Delete the 3.x files and replace them with these, then import the product - it should delete the old product for you.

[Bob_R]

Thanks. Marked as Installed.

I just left the default settings in the AdminCP. It worked well for me before with vB 3.x series. I'll find out soon if I made the right decision.

[denman75]

cant install it ,getting this

XML Error: no element found at Line 568

[Paul M]

You have a corrupt xml file, I suggest you download and unzip it again.

[Keldaria]

not having any good luck.. my host seems to be killing the backup attempt before i can finish... block processing doesn't seem to do anything to help it, altho turning off the combine files feature allowed it to about double the ammount of tables it could backup before it stopped.

Uninstalled for now... I just wish there was a way to set it to backup say half the tables then take a 1 min rest and then backup the rest cause that would probibly avoid this problem but hey no worries, thanks for the mod tho

[evilTone]

works well
now if it only made sql.tar.gz files aswell . . .

[EricPSF]

wow...good stuff.
Thanks.

[ChopSuey]

Awesome paul, thanks again.

[Mistamike17]

Having issues:

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

I've tried every possible directory combination I can think of, but no dice. I've CHMOD'd and also still had no luck. Any ideas?

Forum files are in public_html/website/. I've tried ../backups/, ../../backups/, etc. All of them to no avail.

TIA for help.

[Paul M]

Have you actually created the backup directory you are trying to use ?

[ChopSuey]

/home/yourname/backups/

create a folder same directory as public_html

[Hondarydr]

Alright I got everything installed but when I click Run Now I get this error:
Backup Error : Could not write to destination file ( /public_html/forum/backup/Forum-01-25-2010-Full-Backup.sql )

I know it is not a good location for the file but I am just testing it. I also made that folder writable so I don't know what's going on.
Any suggestions?

[trilogy33]

Just out of curiosity, is it a good idea to "Lock Tables" when doing the backup?
I seem to remember we had that enabled on the old v3.x one.

[ChopSuey]

Alright I got everything installed but when I click Run Now I get this error:
Backup Error : Could not write to destination file ( /public_html/forum/backup/Forum-01-25-2010-Full-Backup.sql )

I know it is not a good location for the file but I am just testing it. I also made that folder writable so I don't know what's going on.
Any suggestions?

Wow its supposed to be like this
/home/username/backups
/home/username/public_html

Get it? Your making your backups public lol. :rolleyes:

[Paul M]

Just out of curiosity, is it a good idea to "Lock Tables" when doing the backup?
I seem to remember we had that enabled on the old v3.x one.
It depends, it means no tables can be updated while the backup is running, which is ideal - however, it also means your forum will not function until the backup has completed.

[Hondarydr]

Wow its supposed to be like this
/home/username/backups
/home/username/public_html

Get it? Your making your backups public lol. :rolleyes:

Sorry I'm a noob at this lol I still don't understand. Could you explain it a little more?
Thanks :o

EDIT: Never mind I got it all fixed, thanks :)

[trilogy33]

It depends, it means no tables can be updated while the backup is running, which is ideal - however, it also means your forum will not function until the backup has completed.

Yes thanks Paul. I'd noticed that happen on the older version.
No biggie, as the task is in the early hours, take just a few seconds and the notice is displayed.
That's cool ;)

[Allan]

Thank you, work on vB4.0.1 ;)

Compressed to .gz, it's possible ?

or

Compressed to .gz in the forder (but one file, not individual files)

[Paul M]

If you modify the code then I expect it would be possible.

[Allan]

If you modify the code then I expect it would be possible.
this is not where I wanted to come, but thank you ^^

[AZRainman]

Paul; Any chance of you designing this mod with an option to compress the sql files with gzip to save some server space?

[ChopSuey]

He said if you edit files it is possible....Hopefully he'll do that also.

[XxSparks]

Kay, so I figured it out, and installed it, and it's working, I run the Cron Job manually to test if it works, and it does, at the end I get this:


Processed Database in 23.385 seconds

Backup Completed Successfully

Done


After it's completely figured, then I go to my FTP, and the folder I set, and boom, blank, nothing there. What's the problem?

[Paul M]

You are looking in the wrong place - if its completed than its written the data to the path you specified.

[dcuellar]

I've installed this successfully but I want to make sure that what I did was correct.

There was one file saved as "Forum-February-14-Full-Backup.sql". Is that all I need? Is the date method I used sufficient? I basically only want to save one year's worth of files before it starts to overwrite them.

What are the advantages and disadvantages of selecting the first option? (To save as one file)
Is it safe to install to "../../backups"?

[Paul M]

As far as the database is concerned, yes, thats all you need.

As to one file or multiple files, it depends - its easier to restore one table if you have seperate files. If you need to restore the whole database, one file is easier (but in DOS its also easy to join all the single files into one big file anyway).

I dont quite understand your last question.

[kf4eok]

how do you restore a backup?
all I have ever used is mysqldumper.
thanks

[XxSparks]

I have this installed, but it seems like Cron Job isn't being run daily, could this have something to do with the forum being offline perhaps? Or should it run daily regardless?

[Paul M]

The vbulletin cron system relies on people visiting the forum.

[XxSparks]

ah, okay, thanks so much Paul! :)

[mrdexx]

Sorry if this is a newb question, but this program generates a .sql file, and then I take this file and import it within cpanel to restore the database through importing in phpwizard? (in the event of things going sideways etc.)

Basically just wondering if important/restoring the database using this mod is different than the backups done through exporting from phpmyadmin?

Thanks!

[Paul M]

I have no idea what phpwizard is.

[mrdexx]

Sorry I was exhausted when I wrote that, I meant to say does it generate the same files as if I had exported my database through phpmyadmin?

[Paul M]

All text based mysql exports are similar, whatever software creates them.

[Ark del KAOS]

Hi Paul!
I had a problem yesterday when I put back a sq backup made with this mod, and maybe you cant give me some advice about it.

I use a utf8 Spanish forum, because there's some symbols like the ? or accents who cant be showed properly without utf8.
The forum work perfect with the language option of charset tuned to utf8, etc
But yesterday I migrate the forum from a cluster server to a dedicated one, and when I put the system back the database shows all the special characters wrong.

I put it back uploading the backup with ftp, and the running this:
mysql -uUSER -p DATABASE < /../../../../../backup/db-100220-Full-Backup.sql
Well, It's the standard one ;) Nothing out of ordinary.

When I open the mysql with phpmyadmin, and examine the data itself, (ej: post) in the pagetext column I can read the info contained, but It's wrong with the same mistaken charset symbols.

The MySQL charset its UTF-8 Unicode (utf8)
And the collation its utf8_general_ci
But then there some of the tables collated in latin1_swedish_ci

I don't know anything more to play with, trying to recover it.
Could you give me some advice?

[Ark del KAOS]

.....You know when you get out of ideas, and make a post....and then, coming from anywhere, the one only thing you don't think off shows up, and save the day?
Its always the same XD
--default_character_set utf8
That did the trick, and save me from this mess XD
(I swear I try it, but It seems I misspelled the option some where in the process...? ?)

Well, anyway, thanks for all your hard work with so many good mods! ^ ^

[s0lidgr0und]

Trying now.

*crosses fingers*

Edit: Failure. Looks like HostGator is the issue.

[GrossKopf]

Guess I'm blind. I can't find the configuration options in the admin CP.

[mrdexx]

Got it working now! (In hostgator to boot)

/home/[username]/backups/

That way its not public (like if it were in public_html)

Thanks for the mod!

[s0lidgr0und]

Guess I'm blind. I can't find the configuration options in the admin CP.

AdminCP > Settings > Options > [scroll down to/near the bottom]

It's there.

[johnny713]

This is what I want. Few days ago I asked this in vbulletin.com, and they let me know vbulletin 4 has been removed this nice feature that I use all the time. I gotta install this for my forum. I hope it work fine. Thank you so much Paul.

Update: It works perfectly with 4.0.2. My database backup less then 16 seconds.

[Terminator1138]

I had an error when trying to do a backup..

Automatic Database Backup for vBulletin
Backup Error : Could not write to destination file ( /dbbackups/Forum-2010-03-01-Full-Backup.sql )

[s0lidgr0und]

Does that directory exist?

[Terminator1138]

yes I created that folder in /www/ directory where my forum is installed

[Markos]

Processed Database in 40.427 seconds

Backup Completed Successfully

Done

thanks Paul :)

[Terminator1138]

tried putting the folder I created in different areas, still same error ...

[princeedward]

tried putting the folder I created in different areas, still same error ...hi...why you just create that backup folder inside your root folder like inside public_html folder same as mine and this folder must be 777
then add this...

././AUTO-BACKUPS/

to your Acp > vb options > vBulletin Automatic Backup > Backups Path

hope this will solve your problem...if not ask more till the developer got mad and reply to you....

LOL

:p

best regards dude...

;) :up:

[Paul M]

././AUTO-BACKUPS/

Pretty sure Ive mentioned this before - but you dont need 2 lots of ./ if your are going to use a folder in that location then ./foldername is all you need. :)

[princeedward]

Pretty sure Ive mentioned this before - but you dont need 2 lots of ./ if your are going to use a folder in that location then ./foldername is all you need. :):p hehe...but its working like a charm on that way for me boss...anyway...he can try it both...

best regards...

;)

[sburns1992]

Is this available for version 3.8.X - Have done a search, but found nothing.

[princeedward]

Is this available for version 3.8.X - Have done a search, but found nothing.My God....this is available since this board is started :p ...simple and easy to find it....click developer username to view profile page or avatar...and look below for all his mod version.....then you will find it...

goodluck and best regards...

:p:up:

[elenh]

How about auto deleting old backups? Other if the hack is sets every day backup the files in the backup folder will be use a lot of space if not manual deleted.

In example set auto delete backups before 6 days.

[sburns1992]

My God....this is available since this board is started :p ...simple and easy to find it....click developer username to view profile page or avatar...and look below for all his mod version.....then you will find it...

goodluck and best regards...

:p:up:


Oh excellent :) Thanks.

[Paul M]

How about auto deleting old backups? Other if the hack is sets every day backup the files in the backup folder will be use a lot of space if not manual deleted.

In example set auto delete backups before 6 days.

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.

[Manoel J?nior]

I made a comparison with this mod and dumper.php, and stayed with my SQL:

Auto-Backup: 15MB
dumper: 6MB

[Terminator1138]

hi...why you just create that backup folder inside your root folder like inside public_html folder same as mine and this folder must be 777
then add this...

././AUTO-BACKUPS/

to your Acp > vb options > vBulletin Automatic Backup > Backups Path

hope this will solve your problem...if not ask more till the developer got mad and reply to you....

LOL

:p

best regards dude...

;) :up:
yep its set to 777 and I've tried both in public area and in user root protected, both did not work....

[ProFifaLeagues]

Working great and database backed up in less than 30 secs!
Cheers top work

[KissOfDeath]

Thank you very much, i'm not sure why they took this feature away, it's a must have

[Ragman68]

thank you Paul, this is a brilliant mod, just whay I have been looking for to backup my 896mb database, this is a must have for large databases

[Desibabu19]

Hi Paul,

Excellent piece. Installed. Thank you very much. I am using VB version 4.0.1.

Created 704 MB backup file.

Processed Database in 182.957 seconds

Backup Completed Successfully
Done

I created one backup file.

I am newbie. I have two questions.

1) If anything goes wrong and if I have to restore the datebase, how do I use this backup file to restore all tables ?

2) As you see it has taken around 3 mins to create backup for website. At any point of time there are about 150-200 users in my site. Is it recommendable to close the forums when the backup runs ? Or is it ok to leave the forums open during the backup ?

[mmacrypt]

Thank you very much. It's nice to have this running when I'm going to be away for a few day.

Processed Database in 109.96 seconds

Backup Completed Successfully

Done

Takes some pressure off. I look forward to checking it tomorrow morning and having a backup in place before I even start my day.

[Bob_R]

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.

Thanks bro.

Now, for the $64,000 question:

What if something goes wrong? How do you restore the backups?

Thanks!! :)

[SoulStealer]

Processed Database in 34.312 seconds

Backup Completed Successfully

Done


~thanks :)

[wampforum]

works great even for a complete noob like me - thanks

[hydn]

Will setting path to:E:\backup\ work?

I'm on windows server.

thx

[hydn]

Thanks bro.

Now, for the $64,000 question:

What if something goes wrong? How do you restore the backups?

Thanks!! :)

x2.

sorry. im really noob when it comes to backups. I usually use the mysql GUI in windows for restore. Does the combined backup file end with *.sql?

[aaronrand]

Processed Database in 7.167 seconds
Backup Completed Successfully
Done

Thanks :)

[Paul M]

Will setting path to:E:\backup\ work?

I'm on windows server.

thx
I cant tell you what paths will work on individual servers. Try it.

x2.

sorry. im really noob when it comes to backups. I usually use the mysql GUI in windows for restore. Does the combined backup file end with *.sql?
Yes, it creates .sql files.

[Bob_R]

Thanks bro.

Now, for the $64,000 question:

What if something goes wrong? How do you restore the backups?

Thanks!! :)

Need an answer please. :)

[MattLuria]

mysqldumper is what I would use.

[Paul M]

Need an answer please. :)
Im afraid I cannot provide details on how you would restore mysql on your server, it would depend on many factors like what rights and access you have. I suggest you refer to your host.

[Debbi]

Works beautifully. Gives me a secure feeling LOL. Thanks for this great add on.

[AndyP]

Damn you, HostGator!

No good for me either after trying various amounts for block processing.

[Paul M]

Sorry, the Hostgator timeout seems to be unalterable. I cant think of a an easy way to get round it (other than move to a less restrictive host).

[Fungsten]

:up:

I hated going to CPanel to backup!

[NiTRoN]

What about getting tables optimized before the backup is run. Would that be somehow better than just dumping tables?

[Paul M]

Better in what way ?

[The_Rascal]

Ok, apologies for asking this question again. but I am completely confused by the path requirements :$ ...

https://vborg.vbsupport.ru/external/2010/04/40.png

This is the path in my ftp program...
I have tried setting up a new folder structure - home/rascal/backups and entered that into the options for the plugin, but that didn't work either.

I'm not sure what the '.' represents in the paths...

https://vborg.vbsupport.ru/external/2010/04/41.png

Is that the right path for the path in the ftp screenie?

We are using a dedicated host, and have recently upgraded to 4.03...

Thanks for any help :)

[Paul M]

The path would, I believe, be ../db_backup/

[The_Rascal]

Sweet - Thanks Paul

That worked a treat - a bit annoying that I was so close, and yet so far :D

Backup completed in 62.073 secs

[Richard Evans]

The FTP user setup you are using may not be able to set the 777 permissions properly and isn't telling you that with any error message. I had that problem. I went to the hosting control panel and use the file manager application there instead of trying to do it in my FTP app, and set the permissions there,
It then worked!




Ok, apologies for asking this question again. but I am completely confused by the path requirements :$ ...

https://vborg.vbsupport.ru/external/2010/04/40.png

This is the path in my ftp program...
I have tried setting up a new folder structure - home/rascal/backups and entered that into the options for the plugin, but that didn't work either.

I'm not sure what the '.' represents in the paths...

https://vborg.vbsupport.ru/external/2010/04/41.png

Is that the right path for the path in the ftp screenie?

We are using a dedicated host, and have recently upgraded to 4.03...

Thanks for any help :)

[chicken604]

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

[Paul M]

Run the task in schedule manager.

[kmohamed]

as usual you never have screenshot lol
i am planing on using this mod however i am afraid if i am going to loss any data is that possible and what are the things i should be aware of

thanx again

[pjaco]

Thanks :)

[Paul M]

as usual you never have screenshot lol
Wrong.

All my vb4 mods have screenshots where it is relevant. You cant exactly screenshot a database backup.

[kmohamed]

Wrong.

All my vb4 mods have screenshots where it is relevant. You cant exactly screenshot a database backup.

not that i don?t like your mod i think they are the most efficient and worth-full however most of them you don?t have screen-shot and many user may notice that
-------
https://vborg.vbsupport.ru/showthread.php?t=201323
https://vborg.vbsupport.ru/showthread.php?t=199976
https://vborg.vbsupport.ru/showthread.php?t=231106
https://vborg.vbsupport.ru/showthread.php?t=231790
------
again you are a great coder and i appreciate every work you've done so far
thanx a million time

[Paul M]

Maybe you should read what I said :)

All my vb4 mods have screenshots where it is relevant

[RedDevil]

Nice:)

Processed Database in 21.61 seconds

Backup Completed SuccessfullyDone


49.36 mb

[kmohamed]

Maybe you should read what I said :)

ok you win lol installed great mod :)
thanx i hope it back-up everything :rolleyes:
i already lost my data once i can afford to lose it again :eek:
i trust you PauL ;)

[rwoscott]

Thanks Paul.
After I figured out the path bit, took 124 secs!!

Excellent.

[Sworm]

Hi paul,
the tables backup prefix must be the same of the database tables prefix?

Thanks

[Paul M]

Nope - its just a prefix thats added to the filenames when they are created - its not related to any table prefix.

[AliceHoward]

Installed and nominated, brilliant mod, thank you.

[BigDog56]

Ok, it seemed to work, but when I go to the file I created, it's empty.
Nevermind, it's there now, lol. Strange, it took a few minutes to show up. great mod! thank you!

[Blackbeard02]

Thank you for your work m8 Installed

[docvader]

Paul, I've been using various iterations of this mod over the past few years, with great success, and no problems.

Except one. I can't delete any of the backups. I have a few gigabytes of backups on my server....

I use a "backups" directory, (on shared hosting), which is OUTSIDE the PUBLIC HTML directory, which should help protect them from the devious little b...rds out there. But I guess I don't have permission to alter those files, as they were created by vbulletin (ie, the server). Any suggestions as to how to delete these files? I've tried changing their permissions using CPanel, to no avail.

Would be nice if you had an addition to this mod, whereby one could manage the backups that were created.

Thanks!

[Paul M]

Speak to your host, you should have permission to delete files on your own account.

[hubba]

Strange. A "full-" backup from 22.5.2010 has 229 MB, from 23.5.2010 has about 200 KB???????

[Paul M]

200k is clearly wrong.

[Fungsten]

Strange. A "full-" backup from 22.5.2010 has 229 MB, from 23.5.2010 has about 200 KB???????

That would happen to me occasionally in 3.8.; not with this product. So I just restarted the backup then I got the full download.

[Boofo]

hi...just try something like this...

././backups/

then make a test by

Go Scheduled Tasks > Scheduled Tasks Manager > Automatic Database Backup for vBulletin > Run Now...

it will run auto....if not....just change something else....hope it works for you....

;)
I left the setting at the default and made the backups directory in the same folder that contains public_html, not in the public_html folder. Safest place for it.

[hubba]

If I start it manually it works perfect with about 280 MB. If it starts automated at night it stopps after a few 100 KB. No idea...

[BiZiMDiYaR]

WOww... 781 MB, in below time.. Nice.. ;) Daily backups :)

Thanks !!!


Processed Database in 136.093 seconds


Just 1 thing, so strange I tried to setup the backup outside the http folder, but everytime I got a couldn't write error, however that folder was 777... Strange, any idea on this. ?

For example, I want the backups to be in /home/forum/backup/daily/

And the permissions are chmod 777 for the daily folder, but still problems writing...

Thanks.

[Paul M]

Most likely you have open_basdir restrictions in place, esp if you use Plesk.

[SuperJETT]

Thank you Paul, especially your patience to all of us.

I was using this prior to 4.0 but after reinstalling the new version after 4.0 it was only creating directories, but no files. It was due to having Repair Tables checked, so after taking care of that then enabling block processing, I'm up and running again.

Processed Database in 363.451 seconds
Backup Completed SuccessfullyDone

Great product.

[MattLuria]

Paul, can I use this to FTP the backup to another server after it was done?

[Paul M]

Nope. This cannot do that, its purely backup.

[dune3000]

Ok .. this is set as AUTO? if yes how I can change ex for daily backups?
or there is any buttons for making backup now ?

[Paul M]

You can manually run it at any time in the scheduled task manager - just like any other vb cron job. I dont understand the rest of your post.

[JHUMON]

thanks

[mikem164]

Hey guys, getting this error, any ideas? thank you!

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 19324267 bytes) in /home/erandddd/public_html/vipcoding/includes/class_core.php on line 725

[MixMakers]

I have a fairly large forum and the backup seems to always freeze @:

--- Processed 18300000 Rows

Database is over 2 gigs when it freezes. Any idea as to why this happens?

[your24hourstore]

read something about large files back there <----------

v4.0.2 : 29-Dec-2009 : Added ability to block process larger tables.

so it must do larger tables :>

[MixMakers]

read something about large files back there <----------

v4.0.2 : 29-Dec-2009 : Added ability to block process larger tables.

so it must do larger tables :>

Yeah, I enabled the block but still the same results :\ Always freezes at the same point.

[Paul M]

Sounds like a server / file system issue.

[jeffinj]

Peace of mind of after 393 secs of backup execution.
This is a great mod Paul!! Thank you.

[your24hourstore]

I have a fairly large forum and the backup seems to always freeze @:

--- Processed 18300000 Rows

Database is over 2 gigs when it freezes. Any idea as to why this happens?

when was the last time you repair or optmizes the tables in maintenance?

[your24hourstore]

Peace of mind of after 393 secs of backup execution.
This is a great mod Paul!! Thank you.

this is the most important mod in here i would think, i wish it would gzip it so i didnt have to :>

[pltillman]

I get this error when trying to run the cron job manually.

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

I will admit that I'm new to vbulletin and don't yet fully understand all the intricacies regarding plugins and how they are ran. With that said I did try manually creating a backups directory and chmod 777 to make sure it was writable. I tried placing it in the following directories and each time I got the error.

\
\community - subdomain that vbulletin is installed in
\community\includes

I also wish there were additional options such as emailing the backup file (under a given size of course) or the ability to specify a save location.

Any help is greatly appreciated.

patrick

[Paul M]

E-mailing will never be an option.

You can already specify the save location in the options. The default which the error shows you are using) is ../../backups/

This is a folder called backups, two levels above your forum folder.

e.g.

/var/www/sitename/httpdocs/community = your forum location
/var/www/sitename/backups/ = default backups location

[pltillman]

Thanks Paul. This was literally the first mod I've played with so I just realized I had been going to the Scheduled Task Manager to edit the options, but now I've found the 'real' options under Settings. I updated the save location and it works like a charm. Thanks again!

Oh.. and may I ask why emailing will 'never' be an option?

Thanks
patrick

[Paul M]

E-mailing copies of your database is a huge security risk. Most databases will also be far larger than any e-mail system can handle.

[xenxo blanco]

I had an error when trying to do a backup..

Fatal error: Maximum execution time of 30 seconds exceeded in /var/www/vhosts/spmi.com/httpdocs/includes/mysqlbackup.php on line 402

[Paul M]

You need to speak to your host about that, they are limiting the run time in php.

[Speedy1505]

A corresponding entry is on the moderator options vorhanden.Ist it possible to extend this hack to a TAR compression?

In places the backups are still very large.

many thanks

[Paul M]

Gziping the files will be an option in the next release, im testing it atm.

[Fulmega]

Hi Paul or whoever can help me.
I have a problem, but the hack starts but when it comes to the table postindex stops.
I tried to turn up the block size and later increased to 600 000 but always the result is the same, it stops at postindex.

I can do to solve this?

Regards

Edit:
I've uploaded to 2000000 rows and continues to give the same result.

[Paul M]

Almost certainly some kind of server timeout.

[Hippy]

thanks again for this auto back up mod. works good

I have a question tho.
If I back up the DB via control pannel
the DB is 40+ megs smaller than if I use the auto backup.

can anyone explain why.
thanks

[Paul M]

Backups are just textfiles, the size simply depends on what is included, and how.

[Boofo]

After installing the new version, it says "Templates Merged Successfully". Is it supposed to say that?

[Ozymandyus]

Thanks for the update, Paul. Gzip support is a welcome addition.

[Paul M]

After installing the new version, it says "Templates Merged Successfully". Is it supposed to say that?
Thats a message from the vb product installation system, somewhat bizarre as this actually has no templates.

[Boofo]

Thats a message from the vb product installation system, somewhat bizarre as this actually has no templates.
Exactly what I thought but it did it both times I overwrote it. I did it a second time to make sure I was seeing what I was seeing. It must have something to do with 4.0.4 as I didn't notice it on the first install of this mod with 4.0.3.

[lodos0677]

XML Hata: not well-formed (invalid token) Satır 1 why. ı am use vbulletın ver 4.0.4

[Paul M]

You need to provide more information than that - what are you doing ?

[hayatt2000]

Hi,
I have 4.0.4 and use UTF8.
My forums language id Arabic.

Attached is a screen shot of the database that was generated by "vBulletin Cron Based Database Backup"

When I take the backup via phpmyadmin, the text does not look funny like that!

Any help is appreciated.

Thanks.

[Paul M]

Have you actually tried to restore it ?

[hayatt2000]

Have you actually tried to restore it ?

Emmm, when I restored it via phpmyadmin it looks fine!
Not sure how that is possible, but it worked.
Wow, that's great. Thanks. :)

[DAMINK]

Great mod. Should be a feature in VB i would have thought but either way great stuff.
Tested and working perfectly. And i am hosted at hostgator too. Although i am the reseller so not sure if thats why i have success and others have not.
But yea very good mod mate.

[Gero50]

This looks nice but where exactly do I upload the files. The install instructions only say "upload to the server." Though I am unsure where in the vbulltin files to upload it.

[Paul M]

If you unzip the files it should be obvious from the folder names.

[saviorkickb]

where is run backup button vbulletin admincp?

[stained]

admincp => scheduled task manager

[Dragonsys]

Version 4.0.3 onwards has a Gzip option added (which will only work if your server supports it).

What does the server need in order to support this?

[Paul M]

Gzip installed. :)

[Dragonsys]

Gzip installed. :)

well, gzip is installed on my server, but this mod does not gzip the backups.

[Paul M]

Unfortunately, I cannot help you with server issues. The mod will issue the command to gzip them, if the server fails to do this then you need to speak to your host to investigate why. An easy test would be to connect via SSH, navigate to the folder and type gzip <filename>.

[SublimeBoa]

Never installed it. The more I got into reading about it, and members comments, I just decided it's not what I was looking for, even though I downloaded it first.

Some things are just too advanced for us simple minded folks. :D

[BlackJacket]

Never installed it. The more I got into reading about it, and members comments, I just decided it's not what I was looking for, even though I downloaded it first.

Some things are just too advanced for us simple minded folks. :D

This mod is TOO easy to setup. It really is not difficult at all.

[SublimeBoa]

This mod is TOO easy to setup. It really is not difficult at all.

This is probably true for most. But, I ain't really into this stuff. I "unhijacked" my friends forum for him, and got it to a new server so the control freak that was holding it hostage wouldn't have access or control anymore. Then it was dumped in my lap making me the new web master. I really didn't want it, or the weeks I've spent online crash coursing myself in how VBulletin, FTP and MySQL work. I have no schooling or training in this field at all, and that makes all the difference. ;)

So, my brain hurts too much to think anymore at the moment. HA HA HA Maybe after a while, I'll try it out. For now, I just don't have the interest to mess with it.

[Gero50]

Thanks a lot Mr. M for this hack. Now it can help a lot.

[Dragonsys]

This is probably true for most. But, I ain't really into this stuff. I "unhijacked" my friends forum for him, and got it to a new server so the control freak that was holding it hostage wouldn't have access or control anymore. Then it was dumped in my lap making me the new web master. I really didn't want it, or the weeks I've spent online crash coursing myself in how VBulletin, FTP and MySQL work. I have no schooling or training in this field at all, and that makes all the difference. ;)

So, my brain hurts too much to think anymore at the moment. HA HA HA Maybe after a while, I'll try it out. For now, I just don't have the interest to mess with it.

TBH you should find a reliable webmaster then, one which will not hold the site hostage for whatever reason ;)
Make it easier on yourself, since you don't want to deal with it. If you want help finding one, let me know.

[SublimeBoa]

TBH you should find a reliable webmaster then, one which will not hold the site hostage for whatever reason ;)
Make it easier on yourself, since you don't want to deal with it. If you want help finding one, let me know.

Thanks for the offer. Not totally my decision though since I don't hold the license, but I'll definitely keep it in mind if it gets too rough for me. The guys had a series of questionable people with the key to the door. One after another. That's why he came to me, because we're friends. I ain't a complete "computard", but I could tell right away, this stuff ain't for beginners. LOL

Thanks again for the offer. I'll keep it in mind. :up:

[Blue91]

Paul. I had the 3.8 version of this working on my two sites. I upgraded only one of my sites over to VB4 a few months back and updated this mod with it. I noticed today that the backups created for my 3.8 forum save into their own "day of the week" sub-folder (Monday, Tuesday, etc.) within the /backups directory. However, the backups on the 4.0 forum save directly into the /backups folder instead of into a sub-folder.

Can you help explain the possible reason for this and how I can fix it? It's not a huge issue but I'm just curious why it's different between the two versions.

Thanks in advance.

[Paul M]

Do you combine all the table files into one ?

If so then they wont go into a sub folder - as its not necessary for just one file. I really cant remember when that changed, but I can vaguely remember doing it.

[Blue91]

Yes, I do. That's fine. I'm guessing it changed between 3 and 4 since my 3.8 install uses folders and the 4.x doesnt, :). No problem. I just had to change the directory in my scheduled task code that downloads a copy of the DB from my server to my home PC once a week.

Thanks for the quick reply and continued support of great mods.

[gchristo]

seems to run, and leaves a backup in the correct folder, but I do not get the backup complete or done, it ends here
Processing searchgroup (24905)
Actually just looked and that is the last folder that it saved as well. Am I missing a setting somewhere?

[Paul M]

Sounds like its probably being timed out.

[bfdzio]

Question, I haven't had a chance to make a backup forum for testing so I don't know how good my backups are...so I am wondering about this:
My cpanel says that my database is 760mb. The backups come in at about 680mb. Is this normal?

[Paul M]

Yes, they are two different things.

[Robru]

Hello Paul,

Can You give me an advise, what I must do with this mention? Put a higher mem in php?

Fatal error: Allowed memory size of 16777216 bytes exhausted (tried to allocate 4458722 bytes) in /var/www/forum/includes/mysqlbackup.php on line 436

Thanks!

[Dragonsys]

Hello Paul,

Can You give me an advise, what I must do with this mention? Put a higher mem in php?



Thanks!

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.

[gchristo]

Sounds like its probably being timed out.
I set this
Set to yes to enable processing of larger tables in blocks. You may need this if your host timesout the backup on large tables.

still only goes to search and stops, what should i be changing?
Thanks for your help as well

[Paul M]

There is nothing else you can change - some hosts simply prevent the timeout being changed.

[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