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 |
#142
|
||||
|
||||
Quote:
|
#143
|
||||
|
||||
Quote:
|
#144
|
||||
|
||||
Top Hack, Installed with no probs at all.
One question though, Can I rename or change one of the phps so that I can also run a backup once a week and ftp my database? I have the cron set to run at midnight at present and dont want to FTP everynight. Thanks XraY |
#145
|
||||
|
||||
Quote:
Other then that, just change your cron to backup once a week.. OR 1 more thing you could do. ------------------- create a copy of cronbackup so that you have: cronbackup.php cronbackup2.php create a copy of mysqlbackupconfig so that you have mysqlbackupconfig.php mysqlbackupconfig2.php change cronbackup2.php to include mysqlbackupconfig2.php instead of mysqlbackupconfig.php change mysqlbackupconfig.php, and turn FTP off make sure mysqlbackupconfig2.php has FTP on add the crontask as such: cronbackup.php is daily, it will not use ftp cronbackup2.php is weekly, it will use ftp ------------------- Hope I didnt make that all to be too complicated |
#146
|
|||
|
|||
Hi
Is there a way to encrypt the backup files so I can store my files safely on public servers knowing that no one can read them but me. Or I could make a deal with someone to send me his backups and I send him min! Thanks |
#147
|
||||
|
||||
Quote:
1. I "Could" code in shell support for using ZIP's encryption, tar/gz and I believe bz also do not support encryption. 2. Use MCRYPT to encrpyt a backup archive into a solid mass of encryption, then it would be up to you to Decrypt using another PHP script or I could create one. 3. BEST Option. Set your backup directory to something, below your public_html directory, that way it can not be accessed via url by traditional means. |
#148
|
||||
|
||||
I have aproblem that I cannot solve..
I put the rights passwords and login name etc but it gives me the following message... 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, `gamechallenges` READ, `gamenews` READ, `games` READ, `gamesessions` 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: 'o0oo0X@localhost' to database 'o0oo0X' How can i solve it? |
#149
|
||||
|
||||
Quote:
$backup['LOCK'] = 0; $backup['LOCKTABLES'] = 0; You most likely dont have the necessary permissions. Also, make sure to read the configuration, there are lots of options to chose, and I have them explained; in detail. |
#150
|
||||
|
||||
Thanks 4 answering, I guess I wont backup the locked tables if I set them to 0 right?
So my backup won´t be complete.. Tell me if Iám wrong. |
#151
|
|||
|
|||
Is there any way to have it backup other databases as well?
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|