Administrative and Maintenance Tools - vB Database Backup (Lite)

As of 24 Nov 2017 this modification has been withdrawn.

Note: I did not write the original version, but rather have modified & adapted it.

When vb 3.5 first came out I was using this backup system on my vb 3.0 - and having nothing better to use - I converted it to work on vb 3.5 (here) and since then I have cut it down and adapted it, first for vb 3.6, 3.7 and now for vb3.8.

The original version was by Trigunflame and the rights to the code were bought by Zoints (David Chapman) in January 2007. Later in 2007 David gave me permission to release my adaptation.

I have stripped out much of the extra stuff that I do not use (or indeed, could not get to work). This is a simple (Lite) version that does a php based dump of your database either as one file, or one file per table.

As of version 3.8.002, most of the options have moved to the ACP in vBulletin Options >> vBulletin Automatic Backup

Notes:
* I will not be adding anything new to this modification.
* This is a Lite version to allow people to use the basic backup functionality on 3.8.


History:

v3.8.001 : First version for vB 3.8.
v3.8.002 : Moved most of options to ACP.
v3.8.003 : Moved more options to ACP.
v3.8.004 : Gzip option backported from vb4 version.
v3.8.005 : Split option backported from vb4 version, close option removed.
v3.8.006 : Fix php 5.3 deprecated warning.

[ITDarasgah]

After delete that table and Run manual its work and stop after this is this is complete or not

PHP Code:

Automatic Database Backup for vBulletin
Processing access (265) : Processed 265 Rows in 0.004 seconds
Processing action (No Row Data)
Processing adminhelp (1694) : Processed 1694 Rows in 0.037 seconds
Processing administrator (7) : Processed 7 Rows in 0.001 seconds
Processing adminlog (59227) : Processed 59227 Rows in 1.355 seconds
Processing adminmessage (No Row Data)
Processing adminutil (2) : Processed 2 Rows in 0 seconds
Processing album (4) : Processed 4 Rows in 0 seconds
Processing albumpicture (17) : Processed 17 Rows in 0.001 seconds
Processing albumupdate (No Row Data)
Processing announcement (2) : Processed 2 Rows in 0 seconds
Processing announcementread (154) : Processed 154 Rows in 0.002 seconds
Processing attachment (53150) : Processed 53150 Rows in 2.231 seconds
Processing attachmentcategory (No Row Data)
Processing attachmentcategoryuser (15217) : Processed 15217 Rows in 0.274 seconds
Processing attachmentpermission (25) : Processed 25 Rows in 0.001 seconds
Processing attachmenttype (18) : Processed 18 Rows in 0.001 seconds
Processing attachmentviews (No Row Data)
Processing avatar (No Row Data)
Processing bbcode (1) : Processed 1 Rows in 0 seconds
Processing bbcode_video (7) : Processed 7 Rows in 0 seconds
Processing bookmarksite (4) : Processed 4 Rows in 0 seconds
Processing cache (1) : Processed 1 Rows in 0 seconds
Processing cacheevent (3) : Processed 3 Rows in 0 seconds
Processing calendar (1) : Processed 1 Rows in 0 seconds
Processing calendarcustomfield (No Row Data)
Processing calendarmoderator (No Row Data)
Processing calendarpermission (No Row Data)
Processing contentpriority (No Row Data)
Processing contenttype (14) : Processed 14 Rows in 0.001 seconds
Processing cpsession (1) : Processed 1 Rows in 0.003 seconds
Processing cron (19) : Processed 19 Rows in 0.002 seconds
Processing cronlog (15391) : Processed 15391 Rows in 0.295 seconds
Processing customavatar (738) : Processed 738 Rows in 0.023 seconds
Processing customprofilepic (449) : Processed 449 Rows in 0.011 seconds
Processing cyb_logintouser (1) : Processed 1 Rows in 0 seconds
Processing datastore (32) : Processed 32 Rows in 0.018 seconds
Processing deletionlog (3683) : Processed 3683 Rows in 0.089 seconds
Processing discussion (No Row Data)
Processing discussionread (No Row Data)
Processing editlog (4353) : Processed 4353 Rows in 0.094 seconds
Processing event (5) : Processed 5 Rows in 0.001 seconds
Processing externalcache (No Row Data)
Processing faq (43) : Processed 43 Rows in 0.001 seconds
Processing filedata (14183) : Processed 14183 Rows in 0.59 seconds
Processing forum (193) : Processed 193 Rows in 0.019 seconds
Processing forumpermission (386) : Processed 386 Rows in 0.006 seconds
Processing forumprefixset (192) : Processed 192 Rows in 0.002 seconds
Processing forumread (No Row Data)
Processing groupmessage (No Row Data)
Processing groupmessage_hash (6) : Processed 6 Rows in 0 seconds
Processing groupread (No Row Data)
Processing holiday (No Row Data)
Processing humanverify (4) : Processed 4 Rows in 0.001 seconds
Processing hvanswer (No Row Data)
Processing hvquestion (1) : Processed 1 Rows in 0 seconds
Processing icon (36) : Processed 36 Rows in 0.001 seconds
Processing imagecategory (3) : Processed 3 Rows in 0 seconds
Processing imagecategorypermission (No Row Data)
Processing infraction (168) : Processed 168 Rows in 0.007 seconds
Processing infractionban (1) : Processed 1 Rows in 0 seconds
Processing infractiongroup (No Row Data)
Processing infractionlevel (4) : Processed 4 Rows in 0 seconds
Processing language (1) : Processed 1 Rows in 0.008 seconds
Processing mailqueue (No Row Data)
Processing memberviews (No Row Data)
Processing membervisits (No Row Data)
Processing moderation (74) : Processed 74 Rows in 0.001 seconds
Processing moderator (171) : Processed 171 Rows in 0.004 seconds
Processing moderatorlog (82662) : Processed 82662 Rows in 4.363 seconds
Processing notice (9) : Processed 9 Rows in 0.001 seconds
Processing noticecriteria (14) : Processed 14 Rows in 0.001 seconds
Processing noticedismissed (776) : Processed 776 Rows in 0.009 seconds
Processing package (1) : Processed 1 Rows in 0 seconds
Processing passwordhistory (25487) : Processed 25487 Rows in 0.367 seconds
Processing paymentapi (7) : Processed 7 Rows in 0.001 seconds
Processing paymentinfo (No Row Data)
Processing paymenttransaction (No Row Data)
Processing phrase (11999) : Processed 11999 Rows in 0.37 seconds
Processing phrasetype (67) : Processed 67 Rows in 0.002 seconds
Processing picture (17) : Processed 17 Rows in 0.005 seconds
Processing picturecomment (No Row Data)
Processing picturecomment_hash (No Row Data)
Processing picturelegacy (17) : Processed 17 Rows in 0.001 seconds
Processing plugin (251) : Processed 251 Rows in 0.01 seconds
Processing pm (300027) : Processed 300027 Rows in 6.285 seconds
Processing pmreceipt (14) : Processed 14 Rows in 0.001 seconds
Processing pmtext (15087) : Processed 15087 Rows in 0.695 seconds
Processing pmthrottle (No Row Data)
Processing podcast (No Row Data)
Processing podcastitem (No Row Data)
Processing poll (129) : Processed 129 Rows in 0.005 seconds
Processing pollvote (3190) : Processed 3190 Rows in 0.065 seconds
Processing post (726386) : Processed 726386 Rows in 38.915 seconds
Processing post_thanks (123861) : Processed 123861 Rows in 2.35 seconds
Processing postedithistory (9949) : Processed 9949 Rows in 0.421 seconds
Processing posthash (8) : Processed 8 Rows in 0.001 seconds
Processing postindex (9087571) 


and please guide me how can set for daily backup on 2:00 AM

[Paul M]

No thats not complete. Processing 9 million records will take a long while, your browser may well time out.

Installing the mod creates the necessary [vb] scheduled task. You just need to alter the time of it.

[ITDarasgah]

Originally Posted by Paul M

No thats not complete. Processing 9 million records will take a long while, your browser may well time out.

Installing the mod creates the necessary [vb] scheduled task. You just need to alter the time of it.

Thanks for reply
I did not find that mod You can identify or give me the link

[Paul M]

What mod ?

[ITDarasgah]

Originally Posted by Paul M

No thats not complete. Processing 9 million records will take a long while, your browser may well time out.

Installing the mod creates the necessary [vb]

I am saying about that..

[snowlion]

Originally Posted by SHER

I am saying about that..

He is talking about this mod

[Paul M]

Originally Posted by SHER

I am saying about that..

Originally Posted by snowlion

He is talking about this mod

Yep.

[ITDarasgah]

Originally Posted by snowlion

He is talking about this mod

Originally Posted by Paul M

Yep.

Then give me an Advice about the time out, What should I do?

[Paul M]

TBH, I suggest you switch to using the mysql full text search, and empty out the old search tables (of which postindex is one).

[ITDarasgah]

Originally Posted by Paul M

TBH, I suggest you switch to using the mysql full text search, and empty out the old search tables (of which postindex is one).

Thank you

but how , Unfortunately I am not programmer can tell you in detail I am thankful to you.

I'm sorry to waste your time