vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Administrative and Maintenance Tools - vB Database Backup (https://vborg.vbsupport.ru/showthread.php?t=167276)

PAKIDIL 08-13-2008 09:00 PM

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 08-13-2008 09:48 PM

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 08-13-2008 10:00 PM

// 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 08-22-2008 01:55 AM

Got the following error when running this cronjob...

HTML Code:

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 08-22-2008 02:03 AM

text limit...

There were my settings:

Quote:

<?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 08-22-2008 03:46 AM

NM... got it working.

z0diac 08-22-2008 05:55 PM

Quote:

Originally Posted by M-Tuning (Post 1418437)
Nice, thanks.

i always forget to do them myself :D

I don't forget - me just tooo lazy :p

I'll grab this now.

turbosatan 08-22-2008 10:40 PM

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 08-23-2008 06:52 AM

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

ogameclub 08-23-2008 11:41 AM

Can be this hack zip file for backup?


All times are GMT. The time now is 12:00 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01382 seconds
  • Memory Usage 1,853KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_html_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete