Administrative and Maintenance Tools - vB Database Backup

This modification is no longer available or supported.

Note: Because I did not write the original version, but rather have modified & adapted it, support of this modification may be limited

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 and now for vb3.7.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. 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.

Notes:
* I will not add anything new to this, or spend vast amounts of time supporting it.
* This is a Lite version to allow people to use the basic backup functionality on 3.7.


History:

v3.7.001 : First version for vB 3.7.

[PAKIDIL]

hello please check is this is correct

// File Saving Information
$backup['DATE'] = '2008-AUG-11'; // Backup file date format (See http://uk.php.net/date)
$backup['PREFIX'] = 'Forum-'; // Backup file prefix, applied to all files
$backup['DUMP_PATH'] = 'home/abd/backups'; // Path to backups folder, must have a trailing slash

where abd is my account id

and does this '2008-AUG-11' we have to set it manually every time we wants to make auto backup

waiting for ur reply
thanks

[Paul M]

No, its not correct - read the comments for each setting (e.g. you use the php date format for that setting - hence the nice link to their site).

[PAKIDIL]

// File Saving Information
$backup['DATE'] = '2008-01-01'; // Backup file date format (See http://uk.php.net/date)
$backup['PREFIX'] = 'Forum-'; // Backup file prefix, applied to all files
$backup['DUMP_PATH'] = 'home/abd/backups'; // Path to backups folder, must have a trailing slash
now check please and also tell me one thing that i have to set it manually to make backup file and upload the file ? thanks

[Jaxel]

Got the following error when running this cronjob...

Database error in vBulletin 3.7.2:

Invalid SQL:

			REPLACE INTO datastore
				(title, data, unserialize)
			VALUES
				('options', 'a:478:{s:15:\"templateversion\";s:5:\"3.7.2\";s:19:\"subscriptionmethods\";i:1;s:10:\"attachfile\";s:1:\"2\";s:7:\"hv_type\";s:9:\"Recaptcha\";s:22:\"hv_recaptcha_publickey\";s:40:\"6LeRuAIAAAAAAFA7It7n9_Ptw85R3IDRoUS2Nli1\";s:23:\"hv_recaptcha_privatekey\";s:40:\"6LeRuAIAAAAAAIXrcWKTgfZUo4x6QMRwqpHEwwSN\";s:18:\"hv_recaptcha_theme\";s:5:\"clean\";s:12:\"regimagetype\";s:5:\"GDttf\";s:10:\"attachpath\";s:13:\"./attachments\";s:14:\"regimageoption\";i:13;s:13:\"usefileavatar\";i:1;s:10:\"avatarpath\";s:15:\"./customavatars\";s:9:\"avatarurl\";s:13:\"customavatars\";s:14:\"profilepicpath\";s:19:\"./customprofilepics\";s:13:\"profilepicurl\";s:17:\"customprofilepics\";s:10:\"sigpicpath\";s:15:\"./signaturepics\";s:9:\"sigpicurl\";s:13:\"signaturepics\";s:14:\"fulltextsearch\";i:1;s:13:\"album_dataloc\";s:14:\"fs_directthumb\";s:13:\"album_picpath\";s:14:\"./customalbums\";s:15:\"album_thumbpath\";s:21:\"./customalbums/thumbs\";s:14:\"album_thumburl\";s:20:\"/customalbums/thumbs\";s:8:\"bbactive\";s:1:\"1\";s:14:\"bbclosedreason\";s:111:\"<p>Sorry, the board is unavailable at the moment while we add new features.</p>\r\n<p>We will be back soon...</p>\";s:7:\"bbtitle\";s:7:\"8WayRun\";s:5:\"bburl\";s:22:\"http://www.8wayrun.com\";s:9:\"hometitle\";s:7:\"8WayRun\";s:7:\"homeurl\";s:22:\"http://www.8wayrun.com\";s:13:\"contactuslink\";s:15:\"sendmessage.php\";s:13:\"contactustype\";i:1;s:16:\"contactusoptions\";s:35:\"Site Feedback\r\nRegistration Problem\";s:14:\"webmasteremail\";s:23:\"jaxel@crookedjester.com\";s:10:\"privacyurl\";s:0:\"\";s:13:\"copyrighttext\";s:49:\"Copyright ?2000 - 2008, Jelsoft Enterprises Ltd.\";s:11:\"companyname\";s:0:\"\";s:9:\"faxnumber\";s:0:\"\";s:7:\"address\";s:0:\"\";s:8:\"keywords\";s:638:\"soul calibur 4, soul calibur 3, soul calibur 2, soul calibur, soul edge, soul blade, Abyss, Abelia, Aeon Calcos, Algol, Amy, Angol Fear, Arthur, Ashlotte, Assassin, Astaroth, Aurelia, Berserker, Cassandra, Cervantes, Charade, Chester, Demuth, Edge Master, Girardot, Greed, Han-myeong, Hilde, Hualin, Hwang, Inferno, Ivy, Kamikirimusi, Kilik, Li Long, Lizardman, Luna, Lynette, Maxi, Miser, Mitsurugi, Necrid, Night Terror, Nightmare, Olcadan, Raphael, Revenant, Rock, Scheherazade, Seong Mi-na, Seong Mina, Setsuka, Shura, Siegfried, Sophitia, Strife, Taki, Talim, Tira, Valeria, Voldo, Xianghua, Yoshimitsu, Yun-seong, Yunsung, Zasalamel\";s:11:\"description\";s:62:\"A Tournament Competitive Community for the Soul Calibur series\";s:12:\"useforumjump\";i:1;s:12:\"pagenavpages\";i:10;s:8:\"pagenavs\";s:18:\"10 50 100 500 1000\";s:12:\"enableaccess\";i:0;s:15:\"addtemplatename\";i:1;s:15:\"usestrikesystem\";i:1;s:12:\"forumleaders\";i:1;s:16:\"allowedreferrers\";s:12:\".8wayrun.com\";s:13:\"threadmarking\";s:1:\"0\";s:12:\"markinglimit\";i:10;s:12:\"disable_ajax\";i:0;s:21:\"enable_inlinemod_auth\";i:1;s:9:\"imagetype\";s:2:\"GD\";s:10:\"magickpath\";s:0:\"\";s:20:\"hvcheck_registration\";i:1;s:12:\"hvcheck_post\";i:1;s:14:\"hvcheck_search\";i:1;s:17:\"hvcheck_contactus\";i:1;s:8:\"yestoday\";i:2;s:10:\"timeoffset\";i:-5;s:8:\"dstonoff\";i:0;s:10:\"dateformat\";s:5:\"m-d-Y\";s:10:\"timeformat\";s:5:\"h:i A\";s:20:\"registereddateformat\";s:3:\"M Y\";s:10:\"calformat1\";s:6:\"F j, Y\";s:10:\"calformat2\";s:3:\"F j\";s:13:\"logdateformat\";s:11:\"H:i, jS M Y\";s:13:\"cookietimeout\";i:1800;s:10:\"cookiepath\";s:1:\"/\";s:12:\"cookiedomain\";s:12:\".8wayrun.com\";s:10:\"gzipoutput\";i:1;s:9:\"gziplevel\";i:1;s:10:\"addheaders\";i:0;s:10:\"ie8render7\";i:1;s:14:\"nocacheheaders\";i:0;s:17:\"useheaderredirect\";i:1;s:12:\"allowphpinfo\";i:0;s:11:\"cachemaxage\";i:7;s:15:\"threadviewslive\";i:1;s:19:\"attachmentviewslive\";i:1;s:9:\"loadlimit\";i:0;s:10:\"safeupload\";i:0;s:7:\"tmppath\";s:4:\"/tmp\";s:13:\"copypostindex\";i:1;s:7:\"ipcheck\";i:1;s:9:\"remoteyui\";i:1;s:10:\"languageid\";i:1;s:7:\"styleid\";i:3;s:17:\"allowchangestyles\";i:1;s:11:\"cleargifurl\";s:9:\"clear.gif\";s:14:\"storecssasfile\";i:0;s:9:\"usepopups\";i:1;s:13:\"legacypostbit\";i:0;s:11:\"showimicons\";i:1;s:12:\"skypeweb_gfx\";i:1;s:12:\"enablecensor\";i:0;s:10:\"censorchar\";s:1:\"*\";s:11:\"censorwords\";s:0:\"\";s:15:\"blankasciistrip\";s:0:\"\";s:11:\"enableemail\";i:1;s:13:\"displayemails\";i:1;s:11:\"secureemail\";i:1;s:14:\"emailfloodtime\";i:60;s:12:\"usemailqueue\";i:1;s:12:\"emailsendnum\";i:10;s:11:\"bounceemail\";s:0:\"\";s:13:\"needfromemail\";i:0;s:8:\"use_smtp\";i:0;s:9:\"smtp_host\";s:0:\"\";s:9:\"smtp_port\";i:25;s:9:\"smtp_user\";s:0:\"\";s:9:\"smtp_pass\";s:0:\"\";s:8:\"smtp_tls\";i:0;s:17:\"allowregistration\";i:1;s:8:\"usecoppa\";i:0;s:10:\"checkcoppa\";i:0;s:18:\"moderatenewmembers\";i:0;s:11:\"welcomemail\";i:1;s:9:\"welcomepm\";s:1:\"1\";s:12:\"newuseremail\";s:0:\"\";s:14:\"allowmultiregs\";i:0;s:11:\"verifyemail\";i:1;s:18:\"requireuniqueemail\";i:1;s:13:\"minuserlength\";i:3;s:13:\"maxuserlength\";i:16;s:16:\"illegalusernames\";s:5:\"Jaxel\";s:13:\"usernameregex\";s:20:\"^((\\w)|[\\-\\=\\.\\@])+$\";s:11:\"usereferrer\";i:1;s:17:\"defaultregoptions\";i:13075133;s:18:\"usernamereusedelay\";i:365;s:9:\"uiforumid\";i:0;s:9:\"uimessage\";i:1;s:9:\"rpforumid\";i:0;s:8:\"rpuserid\";s:1:\"0\";s:7:\"rpemail\";i:1;s:6:\"socnet\";i:31;s:11:\"reqbirthday\";i:0;s:10:\"ctMaxChars\";i:25;s:13:\"ctCensorWords\";s:38:\"admin forum moderator vbulletin leader\";s:11:\"ctCensorMod\";i:1;s:18:\"minifriends_amount\";i:6;s:16:\"friends_per_page\";i:10;s:18:\"profilemaxvisitors\";i:10;s:15:\"profilelastpost\";i:0;s:18:\"softlinebreakchars\";i:90;s:10:\"ignoremods\";i:0;s:21:\"usercss_allowed_fonts\";s:446:\"arial|Arial, Helvetica, sans-serif\r\ntimes_new_roman|\'Times New Roman\', Times, serif\r\ncourier_new|\'Courier New\', Courier, monospace\r\ngeorgia|Georgia, \'Times New Roman\', Times, serif\r\nverdana|Verdana, Arial, Helvetica, sans-serif\r\ntahoma|Tahoma, Verdana, Arial, Helvetica, sans-serif\r\ngeneva|Geneva, Arial, Helvetica, sans-serif\r\ntrebuchet_ms|\'Trebuchet MS\', Arial, Helvetica, sans-serif\r\ncomic_sans_ms|\'Comic Sans MS\', Arial, Helvetica, sans-serif\";s:26:\"usercss_allowed_font_sizes\";s:39:\"small|small\r\nmedium|medium\r\nlarge|large\";s:29:\"usercss_allowed_border_widths\";s:32:\"small|1px\r\nmedium|2px\r\nlarge|3px\";s:23:\"usercss_allowed_padding\";s:80:\"none|0px\r\ntiny|1px\r\nsmall|2px\r\nmedium|3px\r\nlarge|6px\r\nhuge|10px\r\ngargantuan|20px\";s:14:\"albums_perpage\";i:10;s:22:\"album_pictures_perpage\";i:25;s:20:\"profile_album_amount\";i:5;s:26:\"albums_pictures_moderation\";i:0;s:15:\"album_thumbsize\";i:160;s:23:\"album_captionpreviewlen\";i:150;s:18:\"album_uploadamount\";i:5;s:21:\"album_maxpicsperalbum\";i:0;s:10:\"pc_enabled\";i:1;s:13:\"pc_moderation\";i:0;s:10:\"pc_perpage\";i:10;s:13:\"pc_maxperpage\";i:50;s:17:\"pc_allowed_bbcode\";i:1091;s:11:\"vm_maxchars\";i:1000;s:10:\"vm_perpage\";i:10;s:13:\"vm_maxperpage\";i:50;s:13:\"vm_moderation\";i:0;s:17:\"vm_allowed_bbcode\";i:1091;s:16:\"sg_name_maxchars\";i:50;s:17:\"social_moderation\";i:0;s:24:\"sg_allow_owner_mod_queue\";i:0;s:25:\"socnet_groups_msg_enabled\";i:1;s:21:\"sg_allow_join_to_view\";i:0;s:28:\"socnet_groups_albums_enabled\";i:1;s:17:\"sg_allowed_bbcode\";i:1091;s:27:\"sg_allow_delete_empty_group\";i:1;s:13:\"avatarenabled\";i:1;s:14:\"numavatarswide\";i:5;s:17:\"numavatarsperpage\";i:30;s:17:\"profilepicenabled\";i:1;s:16:\"reputationenable\";i:0;s:17:\"reputationdefault\";i:10;s:19:\"reputationundefined\";s:16:\"is off the scale\";s:13:\"showuserrates\";i:5;s:10:\"adminpower\";i:10;s:7:\"rdpower\";i:365;s:7:\"pcpower\";i:1000;s:7:\"kppower\";i:100;s:17:\"minreputationpost\";i:50;s:18:\"minreputationcount\";i:10;s:19:\"maxreputationperday\";i:10;s:16:\"reputationrepeat\";i:20;s:13:\"unallowvbcode\";i:1;s:14:\"unallowsmilies\";i:1;s:10:\"unallowimg\";i:1;s:11:\"unallowhtml\";i:0;s:16:\"enablememberlist\";i:1;s:15:\"memberlistposts\";i:0;s:16:\"memberlistfields\";i:1759;s:17:\"memberlistperpage\";i:50;s:22:\"usememberlistadvsearch\";i:1;s:13:\"enablebanning\";i:1;s:5:\"banip\";s:0:\"\";s:8:\"banemail\";s:0:\"\";s:18:\"aggressiveemailban\";i:0;s:20:\"allowkeepbannedemail\";i:1;s:12:\"globalignore\";s:0:\"\";s:14:\"allowedbbcodes\";i:1023;s:12:\"codemaxlines\";i:30;s:11:\"allowbbcode\";i:1;s:12:\"allowsmilies\";i:1;s:16:\"allowbbimagecode\";i:0;s:9:\"allowhtml\";i:0;s:10:\"quickreply\";i:1;s:9:\"quickedit\";i:1;s:10:\"multiquote\";s:1:\"1\";s:7:\"mqlimit\";i:0;s:12:\"postminchars\";i:10;s:12:\"postmaxchars\";i:0;s:13:\"titlemaxchars\";i:70;s:16:\"ignorequotechars\";i:1;s:10:\"quotetitle\";i:1;s:9:\"maximages\";i:0;s:12:\"stopshouting\";i:5;s:14:\"floodchecktime\";i:30;s:20:\"editthreadtitlelimit\";i:5;s:14:\"addpolltimeout\";i:0;s:13:\"edittimelimit\";i:0;s:14:\"noeditedbytime\";i:10;s:5:\"logip\";i:1;s:15:\"postedithistory\";i:1;s:11:\"editormodes\";s:45:\"a:3:{s:2:\"fe\";i:2;s:2:\"qr\";i:2;s:2:\"qe\";i:2;}\";s:7:\"smtotal\";i:8;s:9:\"smcolumns\";i:2;s:15:\"wysiwyg_smtotal\";i:15;s:16:\"attachtotalspace\";i:0;s:11:\"attachlimit\";i:5;s:14:\"attachboxcount\";i:1;s:14:\"attachurlcount\";i:1;s:14:\"allowattachdel\";i:1;s:20:\"allowclosedattachdel\";i:0;s:15:\"allowduplicates\";i:1;s:12:\"attachresize\";i:1;s:18:\"viewattachedimages\";i:1;s:12:\"attachthumbs\";i:1;s:16:\"attachthumbssize\";i:100;s:12:\"thumbquality\";i:75;s:9:\"attachrow\";i:5;s:10:\"thumbcolor\";s:7:\"#000000\";s:15:\"lightboxenabled\";i:1;s:14:\"maxpolloptions\";i:10;s:13:\"maxpolllength\";i:100;s:14:\"updatelastpost\";i:0;s:9:\"showvotes\";i:1;s:10:\"votechange\";i:0;s:14:\"enablesearches\";i:1;s:15:\"searchfloodtime\";i:0;s:13:\"searchperpage\";i:25;s:10:\"maxresults\";i:500;s:15:\"minsearchlength\";i:4;s:19:\"similarthreadsearch\";i:0;s:13:\"searchsharing\";i:1;s:22:\"similarthreadthreshold\";d:3.5;s:8:\"badwords\";s:0:\"\";s:9:\"goodwords\";s:14:\"vb vbb php sql\";s:15:\"maxsearchlength\";i:20;s:14:\"allowwildcards\";i:1;s:15:\"multimatchscore\";i:15;s:9:\"datescore\";i:15;s:16:\"threadtitlescore\";i:5;s:14:\"posttitlescore\";i:5;s:10:\"replyscore\";d:0.1000000000000000055511151231257827021181583404541015625;s:9:\"replyfunc\";s:4:\"none\";s:9:\"viewscore\";d:0.01000000000000000020816681711721685132943093776702880859375;s:8:\"viewfunc\";s:4:\"none\";s:9:\"ratescore\";d:0.5;s:8:\"ratefunc\";s:4:\"none\";s:13:\"threadtagging\";i:0;s:9:\"tagminlen\";i:3;s:9:\"tagmaxlen\";i:25;s:11:\"tagbadwords\";s:0:\"\";s:12:\"taggoodwords\";s:0:\"\";s:12:\"tagdelimiter\";s:0:\"\";s:12:\"tagmaxthread\";i:25;s:13:\"tagmaxstarter\";i:5;s:10:\"tagmaxuser\";i:2;s:13:\"tagforcelower\";i:1;s:13:\"tagcloud_tags\";i:70;s:15:\"tagcloud_levels\";i:5;s:18:\"tagcloud_cachetime\";i:30;s:21:\"tagcloud_usagehistory\";i:365;s:18:\"tagcloud_usergroup\";i:2;s:20:\"tagcloud_searchcloud\";i:1;s:22:\"tagcloud_searchhistory\";i:30;s:9:\"forumhome\";s:6:\"forums\";s:15:\"displayloggedin\";i:1;s:13:\"showbirthdays\";i:1;s:10:\"showevents\";i:1;s:12:\"showholidays\";i:1;s:13:\"showeventtype\";i:0;s:16:\"activememberdays\";i:30;s:19:\"activememberoptions\";i:3;s:14:\"forumhomedepth\";i:2;s:17:\"forumdisplaydepth\";i:2;s:13:\"subforumdepth\";i:0;s:20:\"showforumdescription\";i:1;s:17:\"showprivateforums\";s:1:\"0\";s:9:\"showlocks\";i:0;s:15:\"lastthreadchars\";i:50;s:19:\"showmoderatorcolumn\";i:0;s:18:\"showprefixlastpost\";i:0;s:13:\"nav_forumdesc\";i:0;s:14:\"showforumusers\";i:0;s:10:\"maxthreads\";i:20;s:12:\"showstickies\";i:1;s:8:\"showdots\";i:1;s:13:\"usehotthreads\";i:1;s:14:\"hotnumberviews\";i:150;s:14:\"hotnumberposts\";i:15;s:11:\"linktopages\";i:1;s:12:\"maxmultipage\";i:3;s:13:\"threadpreview\";i:150;s:11:\"oneannounce\";i:1;s:15:\"showthreadusers\";i:0;s:8:\"maxposts\";i:20;s:12:\"usermaxposts\";s:14:\"20, 30, 40, 50\";s:11:\"showdeficon\";s:45:\"http://www.8wayrun.com/images/icons/icon1.gif\";s:8:\"wordwrap\";i:0;s:11:\"threadvoted\";i:0;s:16:\"threadsubscribed\";i:1;s:18:\"showsimilarthreads\";i:0;s:12:\"postelements\";i:7;s:15:\"socialbookmarks\";i:0;s:17:\"allowthreadedmode\";i:1;s:12:\"threadedmode\";i:0;s:18:\"threaded_listdepth\";i:5;s:17:\"threaded_maxcache\";i:40;s:18:\"threaded_trimtitle\";i:30;s:9:\"enablepms\";i:1;s:10:\"checknewpm\";i:1;s:10:\"pmmaxchars\";i:0;s:11:\"pmfloodtime\";i:60;s:9:\"pmperpage\";i:50;s:12:\"pmmaxperpage\";i:100;s:14:\"privallowicons\";i:1;s:15:\"privallowbbcode\";i:1;s:16:\"privallowsmilies\";i:1;s:20:\"privallowbbimagecode\";i:1;s:13:\"privallowhtml\";i:0;s:9:\"WOLenable\";i:1;s:10:\"WOLrefresh\";i:60;s:9:\"WOLguests\";i:1;s:10:\"WOLresolve\";i:0;s:13:\"enablespiders\";i:0;s:14:\"archiveenabled\";i:1;s:18:\"archive_threadtype\";i:1;s:22:\"archive_threadsperpage\";i:250;s:20:\"archive_postsperpage\";i:250;s:13:\"cpstylefolder\";s:18:\"vBulletin_3_Silver\";s:19:\"timeoutcontrolpanel\";i:0;s:15:\"adminquickstats\";i:0;s:18:\"cp_collapse_forums\";i:0;s:18:\"cp_usereditcolumns\";i:2;s:10:\"externaljs\";i:0;s:11:\"externalrss\";i:0;s:10:\"rsspodcast\";i:1;s:11:\"externalxml\";i:0;s:14:\"externalcutoff\";i:30;s:13:\"externalcache\";i:60;s:13:\"externalcount\";i:15;s:16:\"errorlogdatabase\";s:0:\"\";s:16:\"errorlogsecurity\";s:0:\"\";s:11:\"errorlogphp\";s:0:\"\";s:13:\"errorlogemail\";s:0:\"\";s:15:\"errorlogmaxsize\";i:1048576;s:17:\"disableerroremail\";i:0;s:11:\"enablehooks\";i:1;s:12:\"paymentemail\";s:23:\"jaxel@crookedjester.com\";s:15:\"vb_antispam_key\";s:0:\"\";s:17:\"vb_antispam_posts\";i:0;s:6:\"ipinfo\";i:60;s:13:\"ipinfo_groups\";s:5:\"5,6,7\";s:15:\"uac_notifyadmin\";i:1;s:8:\"gosterx1\";i:1;s:8:\"gosterx2\";i:0;s:8:\"gosterx3\";i:0;s:9:\"pemdata37\";s:900:\"a:3:{s:12:\"paulm_fci_37\";a:8:{s:9:\"productid\";s:12:\"paulm_fci_37\";s:5:\"title\";s:21:\"Flashchat Integration\";s:11:\"description\";s:42:\"Integration of Flashchat and vBulletin 3.7\";s:7:\"version\";s:7:\"3.7.005\";s:6:\"active\";s:1:\"1\";s:3:\"url\";s:0:\"\";s:15:\"versioncheckurl\";s:0:\"\";s:3:\"cvs\";s:4:\"3.15\";}s:12:\"paulm_wic_37\";a:8:{s:9:\"productid\";s:12:\"paulm_wic_37\";s:5:\"title\";s:31:\"Members who are using Flashchat\";s:11:\"description\";s:56:\"Display members who are currently chatting in Flashchat.\";s:7:\"version\";s:7:\"3.7.002\";s:6:\"active\";s:1:\"1\";s:3:\"url\";s:0:\"\";s:15:\"versioncheckurl\";s:0:\"\";s:3:\"cvs\";s:3:\"3.9\";}s:12:\"paulm_wvt_37\";a:8:{s:9:\"productid\";s:12:\"paulm_wvt_37\";s:5:\"title\";s:24:\"Members who have Visited\";s:11:\"description\";s:43:\"Display members who have visited the forum.\";s:7:\"version\";s:7:\"3.7.003\";s:6:\"active\";s:1:\"1\";s:3:\"url\";s:0:\"\";s:15:\"versioncheckurl\";s:0:\"\";s:3:\"cvs\";s:4:\"3.14\";}}\";s:7:\"wicmost\";i:1;s:6:\"wicall\";i:1;s:7:\"wicgrpz\";i:0;s:7:\"wicgrps\";s:1:\"0\";s:8:\"chatlang\";s:2:\"en\";s:6:\"wiccol\";i:0;s:10:\"chatfolder\";s:4:\"chat\";s:6:\"fcpath\";s:0:\"\";s:3:\"wic\";i:1;s:6:\"fcroom\";i:1;s:8:\"fcheight\";i:600;s:6:\"fclink\";i:2;s:10:\"enable_wic\";i:1;s:12:\"template_wic\";s:9:\"FORUMHOME\";s:8:\"text_wic\";s:28:\"<!-- end logged-in users -->\";s:5:\"wicao\";i:1;s:9:\"wicaogrps\";s:1:\"0\";s:22:\"wicao_forumhome_enable\";i:1;s:25:\"wicao_forumdisplay_enable\";i:1;s:23:\"wicao_showthread_enable\";i:0;s:24:\"wicao_whoisonline_enable\";i:1;s:20:\"wicao_profile_enable\";i:1;s:12:\"enable_wicao\";i:1;s:10:\"text_wicao\";s:7:\"$navbar\";s:22:\"automediaembed_disable\";i:0;s:20:\"automediaembed_limit\";i:50;s:22:\"automediaembed_resolve\";i:1;s:23:\"automediaembed_forumids\";s:0:\"\";s:25:\"automediaembed_usergroups\";s:0:\"\";s:19:\"automediaembed_open\";s:431:\"<div align=\"center\">\r\n<table class=\"tborder\" cellpadding=\"6\" cellspacing=\"1\" border=\"0\" width=\"400\" style=\"margin:10px 0\">\r\n<thead>\r\n        <tr>\r\n                <td class=\"thead\" colspan=\"2\" style=\"text-align:center\">\r\n                        <a href=\"$url\" title=\"$title\" target=\"_blank\">$title</a>\r\n                </td>\r\n        </tr>\r\n</thead>\r\n<tbody>\r\n        <tr>\r\n                <td class=\"panelsurround\" align=\"center\">\";s:20:\"automediaembed_close\";s:46:\"</td>\r\n        </tr>\r\n</tbody>\r\n</table></div>\";s:26:\"ncode_imageresizer_enabled\";i:1;s:30:\"ncode_imageresizer_defaultmode\";s:8:\"floatbox\";s:30:\"ncode_imageresizer_warnbgcolor\";s:7:\"#FFFFE1\";s:31:\"ncode_imageresizer_warntxtcolor\";s:7:\"#000000\";s:34:\"ncode_imageresizer_warnbordercolor\";s:7:\"#CCCFFF\";s:32:\"ncode_imageresizer_hsoutlinetype\";s:13:\"rounded-black\";s:27:\"ncode_imageresizer_maxwidth\";i:500;s:28:\"ncode_imageresizer_maxheight\";i:0;s:35:\"ncode_imageresizer_resizesignatures\";i:0;s:31:\"ncode_imageresizer_maxwidthsigs\";i:0;s:32:\"ncode_imageresizer_maxheightsigs\";s:1:\"0\";s:35:\"ncode_imageresizer_sigsexcludgroups\";s:1:\"0\";s:25:\"ncode_imageresizer_albums\";s:1:\"1\";s:33:\"ncode_imageresizer_maxwidthalbums\";s:3:\"900\";s:34:\"ncode_imageresizer_maxheightalbums\";s:1:\"0\";s:26:\"ncode_imageresizer_attachs\";s:1:\"1\";s:38:\"ncode_imageresizer_resizebbcodeimglink\";s:1:\"1\";s:43:\"ncode_imageresizer_bbcodeimglink_killinsigs\";s:1:\"1\";s:30:\"ncode_imageresizer_useroptions\";s:4:\"none\";s:36:\"ncode_imageresizer_clearusersettings\";i:0;s:11:\"subfhome_on\";i:1;s:28:\"all_albums_default_sortfield\";s:15:\"lastpicturedate\";s:28:\"all_albums_default_sortorder\";s:4:\"desc\";s:27:\"all_albums_show_navbar_link\";i:1;s:27:\"all_albums_show_quick_links\";i:1;s:29:\"all_albums_shlow_navbits_link\";i:1;s:9:\"subucp_on\";i:1;s:12:\"subucp_nogrp\";s:1:\"6\";s:10:\"subexp_exp\";i:1;s:14:\"subexp_rct_exp\";i:0;s:8:\"subexp_1\";i:1;s:12:\"subexp_rct_1\";i:0;s:8:\"subexp_2\";i:1;s:12:\"subexp_rct_2\";i:0;s:8:\"subexp_7\";i:1;s:12:\"subexp_rct_7\";i:0;s:9:\"subexp_30\";i:1;s:13:\"subexp_rct_30\";i:0;s:10:\"subexp_lng\";i:1;s:14:\"subexp_rct_lng\";i:0;s:9:\"subexp_nn\";i:1;s:13:\"subexp_rct_nn\";i:0;s:13:\"subexp_rctnum\";i:5;s:14:\"subexp_rctdate\";i:0;s:12:\"tfseo_enable\";i:1;s:10:\"tfseo_type\";s:1:\"2\";s:14:\"tfseo_url_type\";s:1:\"1\";s:13:\"tfseo_rewrite\";i:7;s:9:\"tfseo_301\";i:7;s:10:\"tfseo_base\";s:22:\"http://www.8wayrun.com\";s:9:\"tfseo_chr\";s:1:\"0\";s:10:\"tfseo_page\";s:4:\"page\";s:11:\"tfseo_index\";i:0;s:12:\"tfseo_maxkey\";i:8;s:15:\"ae_ignore_users\";s:1:\"1\";s:13:\"ae_recipients\";s:5:\"Jaxel\";s:9:\"ae_sender\";i:1;s:9:\"ae_sendpm\";i:1;s:10:\"ae_forumid\";i:0;s:14:\"ae_startthread\";i:0;s:16:\"ae_ignore_groups\";s:5:\"5,6,7\";}', 1);

MySQL Error   : Table 'datastore' was locked with a READ lock and can't be updated
Error Number  : 1099
Request Date  : Thursday, August 21st 2008 @ 10:54:28 PM
Error Date    : Thursday, August 21st 2008 @ 10:54:30 PM
Script        : http://www.8wayrun.com/admincp/cronadmin.php?do=runcron&cronid=19
Referrer      : http://www.8wayrun.com/admincp/
IP Address    : 68.197.175.128
Username      : Jaxel
Classname     : vB_Database
MySQL Version : 5.0.51a-community

[Jaxel]

text limit...

There were my settings:

<?php
/*
<!-- $Header: d:\cvs/3.7/Auto-backup/includes/mysqlbackupconfig.php,v 3.2 2008/01/06 15:32:44 pem Exp $ -->

Auto-Backup (Lite) for vBulletin 3.7 - Paul M - v 3.7.001
This lite version is adapted from the original 3.0 version by Trigunflame.
*/

// Combine all tables into one file
$backup['COMBINE'] = 1; // 0 = No, 1 = Yes

// Close Forum during Backup
$backup['SHUTDOWN'] = 1; // 0 = No, 1 = Yes
$backup['MESSAGE'] = "The forums are currently closed while the database is undergoing a routine backup process.";

// File Saving Information
$backup['DATE'] = 'Y-M-d'; // Backup file date format (See [url]http://uk.php.net/date[/url])
$backup['PREFIX'] = '8WR-'; // Backup file prefix, applied to all files
$backup['DUMP_PATH'] = '/home/eightway/public_html/backups/'; // Path to backups folder, must have a trailing slash

// -----------------------------------------------------------------------------------------------//

// Backup Options
$backup['LOCK'] = 1; // Lock Tables during dump
$backup['REPAIR'] = 1; // Repair & Optimize Tables before dump

// Backup Type To Use
$backup['TYPE'] = 2; // 1 = Only Specified Tables, 2 = All except Specified Tables
$backup['TABLES'] = array(); // Table List - e.g. array('table1', 'table2')

// Backup Optimizations
$backup['INNODB'] = 0; // Set to 1 if you have Innodb Tables

// Execution Function
$backup['COMMAND'] = 'exec'; // exec, system or passthru

?>

I turned $backup['LOCK'] off, and then it worked. is there a reason why I cant lock?

[Jaxel]

NM... got it working.

[z0diac]

Originally Posted by M-Tuning

Nice, thanks.

i always forget to do them myself

I don't forget - me just tooo lazy

I'll grab this now.

[turbosatan]

ok so i have this working now. is there a way of automatically mailing the new db to myself each day after the backuphas completed?

i am sure i ahve read about using normal crons in cpanel to do this but i cant recall where and i dont seem to be able to find any info.

please let meknow if you can help and

Great Mod!! Thank Paul M

[blackwolf1962]

thank you i was getting a error but as soon as i got the correct path in config it worked fine thanks installed

[ogameclub]

Can be this hack zip file for backup?