vb.org Archive
Page 6 of 9 « First 45 6 78 Last »
Show 40 post(s) from this thread on one page

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)

Super Jinni 07-19-2008 08:02 PM
aah, sorry

I got the previous reply wrong..

thanks anyway

:)

Rideharder 07-19-2008 08:07 PM
Quote:
Originally Posted by Paul M (Post 1579293)
I dont understand your question.

This backs up whatever database your forum is using.

I have two cpanel...
I loaded my vBulletin files I used FTP to www.speedxxx.net..
I created my database on www.usaXXXX.net..
Some how the www.speedxxx.net cpanel used the www.usaXXXX.net database I made..

I was sleepy at the time okie lol

They have the same DNS

I know alittle nuts hmm..

Paul M 07-20-2008 11:48 AM
If your forum works then this will work.

BigJohnny 07-24-2008 09:57 PM
is this a lite version?

Paul M 07-24-2008 10:09 PM
Yes.

BigJohnny 07-24-2008 11:02 PM
so what would be the "heavy" version?

Paul M 07-25-2008 07:02 AM
There is no heavy version, except for vb 3.0.

pranaysanghavi 07-25-2008 04:50 PM
<i>Alter the timing of the cron job to suit.</i>
How to do that?
sorry, am new to all this

briansol 07-30-2008 06:42 AM
go into your schedule task manager, find the product name, and change the time there, save.

Paul- great mod/adaptation.

gzip seems to be a big request.
If i build it, would you have a problem adding it on to this?

lele816 07-31-2008 03:34 AM
An error occured during the Backup : Could not open Destination SQL file for writing.

why??

briansol 07-31-2008 06:11 AM
check your path.

the config file is a little misleading. it makes you think you can enter ../forums/ or whatever, but it SHOULD be the URI to your directory, like /var/vhosts/home/yoursite/nonpublic/

jkcerda 08-01-2008 04:54 PM
nice

trulylowcarb 08-02-2008 01:17 PM
SWEET! Installed and my first backup already ran successfully - thanks so much for this TERRIFIC mod.

Paul M 08-02-2008 06:13 PM
Quote:
Originally Posted by briansol (Post 1588069)
check your path.

the config file is a little misleading. it makes you think you can enter ../forums/ or whatever, but it SHOULD be the URI to your directory, like /var/vhosts/home/yoursite/nonpublic/

There is nothing misleading - relative paths are perfectly acceptable.

PAKIDIL 08-03-2008 10:58 AM
One question please does this backup all the forum,threads,post etc ?automatically the time,day we set it to .

Paul M 08-03-2008 12:00 PM
All those are part of the database, so yes.

PAKIDIL 08-07-2008 08:04 AM
what is the best configuration for the mysqlconfig ? whats the operation of this

// Combine all tables into one file

= 'Forum-'; // Backup file prefix, applied to all files
= '../../backups/'; // Path to backups folder, must have a trailing slash

what should come in forum- fields ?
and
../../backups; shoudl it be like http://www.sitename.com/forum/backups ?

briansol 08-08-2008 03:09 AM
the option is there to have 1 file per table
or 1 file for the whole thing.

the path should NEVER be web accessible. it should be at the same level or below your public_html/ directory. Keeping your backups web acessible is a huge security risk, as anyone can download your entire site and have all your content and user emails

i suggest using a path URI,

ie,

/home/yoursite/backup/
where
/home/yoursite/public_html/ is your web root.

PAKIDIL 08-09-2008 09:10 PM
okay .i have do it as i say put Y-m-d = 2008-08-10

i have put backup location

and upload autoback

but its not showing in vbulletin option ?
can any one help me abt it

Paul M 08-10-2008 02:33 PM
Nothing in this is supposed to show in vb options

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?

GeNeRaL NT 08-23-2008 05:08 PM
thanks

shlomot 08-24-2008 05:51 AM
Dear Paul,

I set a second database on the forum for PhotoPost.

What would be the best technique to include this database in the auto-backup as well?

Paul M 08-25-2008 09:16 AM
You could not do that without editing the code.

aciurczak 08-30-2008 04:45 AM
Is the "combine" function working for folks? I've tried it like this:

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

and I've tried it like this:

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

and either way it creates 1 file per table in the backups directory. Haven't figured out which way I want to go yet, but it seems like I don't have a choice if the combine isn't working for me anyway.

aciurczak 08-30-2008 05:03 AM
Sorry, my bad. Seems like it was working to combine. I just hadn't refreshed the directory on the FTP program I was using.

AryanMetha 08-30-2008 09:37 PM
hi mate... good mod.. but it didn't worked for me, when the tables were unlock..
i set the tables = 1[lock]. then it worked like a charm... i think the same thing is happening with others..
for your info i've installed the mod on vBulletin 3.7.3. thanx

MCAlexandre 09-08-2008 10:14 AM
Quote:
An error occured during the Backup : Could not open Destination SQL file for writing.
Great mod, but I have the quoted error. What do do? I CHMODed do 777 and nothing. :(

Vinyljunky 09-08-2008 11:33 AM
Quote:
Originally Posted by MCAlexandre (Post 1617273)
Great mod, but I have the quoted error. What do do? I CHMODed do 777 and nothing. :(
Are you sure that your path is correct?

MCAlexandre 09-08-2008 12:12 PM
Quote:
Originally Posted by Vinyljunky (Post 1617335)
Are you sure that your path is correct?
Yes, sure. Want me to try without the "./" or just the "." in the beggining of the path?

Paul M 09-08-2008 03:31 PM
It might help to post what path you have actually set. :)


All times are GMT. The time now is 09:15 PM.
Page 6 of 9 « First 45 6 78 Last »
Show 40 post(s) from this thread on one page

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.01578 seconds
  • Memory Usage 1,911KB
  • 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
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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