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 |
#52
|
||||
|
||||
Here is the error i get:
Database error in vBulletin 3.0.7: Invalid SQL: LOCK TABLES `access` READ, `adminhelp` READ, mysql error: THE REST DELETED Access denied for user: 'xxxxxxxxx@localhost' to database 'xxx-xxx_forums' mysql error number: 1044 Date: Tuesday 22nd of March 2005 09:30:44 AM Script: http://xxxxxxxx.com/forums/admincp/c...cron&cronid=17 Referer: http://xxxxxxxx.com/forums/admincp/index.php? Username: paratek IP Address: xx.xxx.xxx.xx |
#53
|
||||
|
||||
Quote:
You might not have LOCK priviledges or something. |
#54
|
||||
|
||||
Ok Progress...i turn off the lock feature, and using mysql type backup i get the Failover was initiated for MySQLDump Binary but backup was succesfull error....however, i can not find the backup anywhere. If i change it to php dump built into the program it does work and the backup file is in my directory. I am just concerned that i am turning locks off, as you said it was not recommended.
|
#55
|
||||
|
||||
One last thing, and i am sure it was not the intended use of the program to manually do backups with it. Any backups i do on the same day, are just written over, as the file name format is saved using the date. If i do 1 backup per day, fine, it just saves the file as the next date. If i do multiple backups in one day, they will just get written over.
|
#56
|
||||
|
||||
Quote:
When I finish making the AdminCP based page for it, you will be able to test different settings, customize backups, do individual dumps etc... Note: Yes, not using locks isnt as secure.. but if you have the shutdown forum option enabled, that is almost as good. Its basically turning the forum off to your members while the backup is in progress; that will prevent anyone from writing to the database. So, it Is your 2nd best option, just make sure its enabled. |
#57
|
||||
|
||||
Well thanks for the reply. Just smacked the install. Last question. What happens to the users already in the forums when the cron starts and shuts the board down? I haven't been able to test this myself yet.
|
#58
|
||||
|
||||
Quote:
|
#59
|
||||
|
||||
Marvellous!
All working fine now...I can only assume my path was a bit bung..I have /backups directories dotted around the server, but it didn't find them. |
#60
|
||||
|
||||
Quote:
|
#61
|
|||
|
|||
Good job
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|