The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Vbulletin Database Backup Pro (Cron Support) Details »» | |||||||||||||||||||||||||||
Vbulletin Database Backup Pro (Cron Support)
Developer Last Online: Nov 2019
NOTICE: 02/03/2006 This system is being "ReBorn" into a new product "Vbulletin Backup Pro" working from a New Codebase and hopefully implementing all the features and fixing all the bugs that were present in the previous releases. This will be developed specifically for the vbulletin 3.5 system but will probably maintain compatabilty with the pre-existing 3.0 versions. Summary: Vbulletin Database Backup Pro is just what it says; a professional tool for your Vbulletin installation. This script will handle the automated backup of your forums in a secure, data-conscious and optimized way. Introduction: I want to interest all of you in the ultimate solution for automated database backup from within Vbulletin crontab system. And potentially more so than a standard crontab. It's been said, backing up without direct shell access is futile. Wrong. This script is optimized to work just fine with even the largest of databases. (Note: If you have an extremely large database, make sure to use the mysqldump binary option that is selected by default.) The reason for the creation of this script was due to needing a better system of automated backup. I think me and a lot of people have used either a standard cron system, or brad.loo's small database cron; while they can be somewhat effective, they do not provide the functionality or a total solution without having to extensively mod it. This system has automatic failovers for MySQLdump, as well as the compression programs used where applicable. All in all, this script is a one stop shop for handling your backup needs on a automatic basis or from the control panel without having to use shell and do a dump manually. Features:
Change log:
To-Do:
Known Issues:
Instructions:
Help Debugging: This may come as a surprise to some people.. but I do all my code in notepad, thus it may not look formatted right for people that use editors. If you want to view the code in "my" style, how its supposed to look. Open my files in Notepad, with Font size 10-Regular-Lucida Console. As for An errors you may get, when you post; Post your PHP Version, MySQL Version, and the Error as is Shown Please. Further Info: I would like a lot of people to try this script and give me feedback on what you would like changed, what Needs changed and so on and so forth. With the size of this script, it more than likely not gonna work perfect on every system.. so just tell me whats wrong and I will try to get it fixed. Show Your Support
|
Comments |
#282
|
|||
|
|||
Quote:
This is SO useful to me, I do hope you can get to the bottom of this problem? thanks -snake |
#283
|
|||
|
|||
Quote:
|
#284
|
||||
|
||||
Quote:
|
#285
|
|||
|
|||
Quote:
-snake |
#286
|
|||
|
|||
Quote:
I won't know if it is pruning older dumps for a few more days. |
#287
|
||||
|
||||
The backup is making the .sql file however it is not compressing it. I ran the test mode and it gave the following error, however it made the .sql file. It also did not upload to the remtoe FTP.
Daily BackUp An error occured while outputing a New GZ file with the PHP GZ ZLIB Module. |
#288
|
|||
|
|||
Quote:
|
#289
|
|||
|
|||
Quote:
It'd be nice if we could figure out why it stopped working. |
#290
|
|||
|
|||
Trigunflame,
GREAT SYSTEM! In fact, after reviewing this work, features, notes....it's hard to believe the vBulletin folks didn't work an automated backup system into the base software! A real asset for hard working folks out there who don't have the time to run backups manually! I gave it a shot tonight, installed as directed, configured variables as required, and ran the script. I got the error message at the bottom. Any ideas? I think it's just a simple database access problem (?) but I checked the config variables over and over, and it all looks right to me. In fact, it's the exact login info I use to access the database directly through PHPMyAdmin, so I don't know.... FYI: I ran the backup with the config script set to use MySQLDump and also the PHP mode, and it spit the same exact error both times...It also created two SQL files in the backup directory, both completely blank & showing 0KB, but named correctly. Config data requested: PHP 4.3.1 MySQL 4.0.22-nt vBulletin 3.0.7 Thanks for reading, DiSH P.S. - forgot -- like all scheduled tasks, there must be activity on the boards at the specified cron time for it to run, correct? If not, it runs the next time anyone visits? Thanks. ===== ERROR MESSAGE RECEIVED BY EMAIL ====== Database error in vBulletin 3.0.7: Invalid SQL: LOCK TABLES `access` READ, `adminhelp` READ, `administrator` READ, `adminlog` READ, `adminutil` READ, `announcement` READ, `attachment` READ, `attachmenttype` READ, `attachmentviews` READ, `avatar` READ, `bbcode` READ, `calendar` READ, `calendarcustomfield` READ, `calendarmoderator` READ, `calendarpermission` READ, `cpsession` READ, `cron` READ, `cronlog` READ, `customavatar` READ, `customprofilepic` READ, `datastore` READ, `deletionlog` READ, `editlog` READ, `event` READ, `faq` READ, `forum` READ, `forumpermission` READ, `holiday` READ, `icon` READ, `imagecategory` READ, `imagecategorypermission` READ, `language` READ, `mailqueue` READ, `moderation` READ, `moderator` READ, `moderatorlog` READ, `passwordhistory` READ, `phrase` READ, `phrasetype` READ, `pm` READ, `pmreceipt` READ, `pmtext` READ, `poll` READ, `pollvote` READ, `post` READ, `post_parsed` READ, `posthash` READ, `postindex` READ, `profilefield` READ, `ranks` READ, `regimage` READ, `reminder` READ, `reputation` READ, `reputationlevel` READ, `search` READ, `session` READ, `setting` READ, `settinggroup` READ, `smilie` READ, `stats` READ, `strikes` READ, `style` READ, `subscribeevent` READ, `subscribeforum` READ, `subscribethread` READ, `subscription` READ, `subscriptionlog` READ, `template` READ, `thread` READ, `threadrate` READ, `threadviews` READ, `upgradelog` READ, `user` READ, `useractivation` READ, `userban` READ, `userfield` READ, `usergroup` READ, `usergroupleader` READ, `usergrouprequest` READ, `usernote` READ, `userpromotion` READ, `usertextfield` READ, `usertitle` READ, `word` READ; mysql error: Access denied for user: 'flaggotsohio@%' to database 'flaggotsforum' mysql error number: 1044 Date: Wednesday 15th of June 2005 12:03:19 AM |
#291
|
||||
|
||||
I have had this installed for about 6 weeks now - the basic backups are working, but some of the features are not.
1. I had it set to zip files - sometimes this worked, sometimes it failed. When it failed there was no entry in the scheduled tasks loh either. I have given up on this and turned off zipping. 2. FTP failed to work so backups are stored locally. 3. Pruning fails to work, nothing seems to make it want to do this. In short, it does the basic backup, but I have to zip the file and transfer it to another location manually. I have to prune manually. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|