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 |
#102
|
|||
|
|||
Nice script,
But i do seem to get error's when importing the database using either Shell, or bigdump.php, but i don't seem to get errors when i just manually go into vbulletin admincp -> import and maintanence -> database backup. Good mod, but sadly i cannot use it, will have to keep doing it manually >< |
#103
|
||||
|
||||
Quote:
Is the dump being done by PHP or Mysqldump? If it's via PHP dump, then I actually know why it might not be working, Im using some directives designed specifically for mysql 4 / innodb, that might not be working for you. If thats the case, I will patch the script with options to enable/disable mysql 4/innodb optimizations. |
#104
|
|||
|
|||
Quote:
|
#105
|
|||
|
|||
great hack!!! should be the best of the YEAR !!! not the month!
|
#106
|
||||
|
||||
Quote:
Mysqldump shouldnt cause any errors remaking the db, as its automated through the binary, and I don't touch its output in the script. |
#107
|
||||
|
||||
Update Version 1.9
Added configuration support for Enabling MySQL4/InnoDB/Lock Tables for the Directives placed inside the MySQL Dumps. |
#108
|
|||
|
|||
First: Thank you for an excellent addition - much needed! Automatic backups == GOOOOOOD!
Second: Bug found? Running with LOCK off, I got these on every table: LOCK TABLES `access` WRITE; UNLOCK TABLES; If Lock is turned off, shouldn't the export NOT have locks in it? It's not good if I have to manually edit out the LOCKS because I can't perform locks in my DB and I need to restore quickly from the latest backup. Its ok - but not having to edit would be much better. Note - this is using today's update mysqlbackup109.zip - downloaded at 12:56pm EST - about an hour and a half after your update. |
#109
|
||||
|
||||
Quote:
However if it is using MySQLDump; by default I have the switches set at '--opt' which provides the best performance dump but they add locks and other directives to the dump. In the updated zip file, I have included in the configuration the most compatible switches while giving a good dump, although I still have '--opt' as default. The switches are, '--add-drop-table --extended-insert --quick'. Look in the config file and change $backup['SWITCHES'] to the alternate setup that I have listed in the config. |
#110
|
|||
|
|||
You know what, the problem was mine - I had $backup['LOCKTABLES'] set to 1. Missed changing that when I set it up yesterday.
Thanks! |
#111
|
||||
|
||||
Your welcome, im still working on SCP support btw. Should finish it, if I can plow through some of my client projects today.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|