View Full Version : Administrative and Maintenance Tools - Automatic Database Back-up
Logikos
04-25-2006, 10:00 PM
Vote This mod HOTM Here (https://vborg.vbsupport.ru/showthread.php?t=115627)
https://vborg.vbsupport.ru/ (http://www.vbhackers.com)
Automatic Database Back-up
www.vBHackers.com (http://www.vBHackers.com)
Keywords
Automatic, Database, Backup, Cron
What this does
This is a port of Brad (https://vborg.vbsupport.ru/member.php?u=1068)'s hack that can be found here (https://vborg.vbsupport.ru/showthread.php?t=62149). This will backup your database using the vBCron system in vBulletin and send the file to a directory that you specified in the vBulletin Options area.
IMPORTANT NOTE TO ALL THAT USE THIS SCRIPT
This script invokes an outside process that runs in the backround on your server to backup and compress your database. It is important to remember that this is not an instant process, do not enter you ftp as soon as the script says it is done and try to download your backup. It will likely be incomplete and your server will probbly still be writting the file to disk.
I ussally give the process an hour or two before I mess with the file, larger databases will take more time of course.
To do list...
Time to install: 5 minutes
Queries to run: 0
File Mods: 0
Templates to edit: 0
Templates to add: 0
New Phrases: 5
New Plugins: 0
Credits
Thanks to Brad (https://vborg.vbsupport.ru/member.php?u=1068) for allowing me to port this.
Install This Product (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=114097)
Show your support and click the install button!
Testing Information
I've been using this for vBHackers.com since I first upgrade. I have all my backups being sent to a directory, outside of the public_html. I've yet to experiance any problems. I have had to use one of the backups before, and all worked well.
Product History
Wednesday, April 26, 2006 - Public Released
Help & Support
Before asking for support, please make sure you have done all the necessary changes! If you still need support, please post a reply here and double check that you have clicked the Install Button (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=114097). I will try to support this hack the best I can. Support is not guaranteed!
Please post any bugs and errors here. Hope you like it, feedback is always welcomed! :)
Logikos
04-26-2006, 08:31 AM
~ Post Reserved ~
Frapegliko
04-26-2006, 08:36 AM
cool mod
apdcanari
04-26-2006, 08:57 AM
Cool..but I have an error :
Automatic Database Back-up
Warning: exec() has been disabled for security reasons in /includes/cron/databack.php on line 21
Fait
Atakan KOC
04-26-2006, 08:58 AM
Thanks LiveWire
Logikos
04-26-2006, 09:02 AM
@ apdcanari: Your host has disabled that feature for security reasons. I suggest you contact your host. :)
@ Atakan KOC & Frapegliko: Thanks & No Problem! :)
apdcanari
04-26-2006, 09:07 AM
@ apdcanari: Your host has disabled that feature for security reasons. I suggest you contact your host.
Ok, thanks.
My host is Informaniak
theArchitect
04-26-2006, 11:55 AM
Forgive the nOObie question, but does this work using the same system as a SSH autobackup?
I have set-up a script, with a friends help on my server which takes care of my back-ups, but this hack could be useful for other site I work on where I don't have SSH access and can't set-up something similar to my system.
But I am very nervous of the AdminCP back-up system.
dacho
04-26-2006, 01:11 PM
installed but there is a error problem
Warning: exec(): Unable to fork [mysqldump --add-drop-table -h192.000.000.000 -uXXXXX -XXXXX XXXXX 2>/XXXX/XXXX/forums.dacho.co.il/XXXX/04-26-2006-error.txt >/XXXX/XXXX/forums.dacho.co.il/XXXX/04-26-2006.sql] in \includes\cron\databack.php on line 21
Warning: exec(): Unable to fork [tar -cSz --remove-files -C/XXXX/XXXX/forums.dacho.co.il/XXXX -f/XXXX/XXXX/forums.dacho.co.il/XXXX/04-26-2006.tar.gz 04-26-2006.sql 04-26-2006-error.txt] in \includes\cron\databack.php on line 26
COBRAws
04-26-2006, 02:49 PM
installed but there is a error problem
Warning: exec(): Unable to fork [mysqldump --add-drop-table -h192.000.000.000 -uXXXXX -XXXXX XXXXX 2>/XXXX/XXXX/forums.dacho.co.il/XXXX/04-26-2006-error.txt >/XXXX/XXXX/forums.dacho.co.il/XXXX/04-26-2006.sql] in \includes\cron\databack.php on line 21
Warning: exec(): Unable to fork [tar -cSz --remove-files -C/XXXX/XXXX/forums.dacho.co.il/XXXX -f/XXXX/XXXX/forums.dacho.co.il/XXXX/04-26-2006.tar.gz 04-26-2006.sql 04-26-2006-error.txt] in \includes\cron\databack.php on line 26
The dir path to your forums is -C/XXXX/XXXX/forums.dacho.co.il/XXXX ??
I think it is -C/XXXX/XXXX/dacho.co.il/XXXX/forums
Boofo
04-26-2006, 02:51 PM
You have a directory in the zip that has a newer plug-in in it. Which files do we use, sir? ;)
Sooner95
04-26-2006, 03:43 PM
installed, I used the first set.. hopefully that is it...
Boofo
04-26-2006, 03:55 PM
installed, I used the first set.. hopefully that is it...
I used the ones in the second databack directory. The php file had a newer date on it. Shouldn't really matter, though. As long as it works. ;)
And it is working great on my site. ;)
The Chief
04-26-2006, 04:06 PM
Looks great, might install when we really get in need of it ;)
Boofo
04-26-2006, 04:21 PM
Looks great, might install when we really get in need of it ;)
You should be in need of it now. It's always best to have a backup of the db close at hand and as new as possible. ;)
nvhlinh
04-26-2006, 05:16 PM
I try to run the script in Sheduled Tasks and it creates a error-file with this error message:
mysqldump: Out of memory (Needed 661284 bytes)
mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from server
Snake
04-26-2006, 05:55 PM
Do you have any screenshots if available?
Boofo
04-26-2006, 06:23 PM
Do you have any screenshots if available?
There's nothing to see. It just backs up your forum db at a set time via a cron job. ;)
Tefra
04-26-2006, 06:48 PM
thank you, works great here too!
btw all dublicated files are the same exactly.
Boofo
04-26-2006, 06:50 PM
thank you, works great here too!
btw all files are the same exactly.
The xml files are 2 different sizes. The php file is the same. ;)
Logikos
04-26-2006, 07:13 PM
Fixed the zip. Winzip was archiving duplacates for some strange reason.
Boofo
04-26-2006, 07:15 PM
Fixed the zip. Winzip was archiving duplacates for some strange reason.
Which xml file did you keep? The zip I have had 2 different sized ones.
Logikos
04-26-2006, 07:21 PM
Both XMLs are the same, the only diffrence was on of the XML files had an extra setting in the Admincp asking you for the name of the file that you want your backup to be called. That setting was a test I was trying, but I never added the code in the databack.php. So everything will work no matter which XML you used. You might just have an extra setting in the admincp that won't work anyways, because I deleted the code before I ever released it. :)
Boofo
04-26-2006, 07:33 PM
Both XMLs are the same, the only diffrence was on of the XML files had an extra setting in the Admincp asking you for the name of the file that you want your backup to be called. That setting was a test I was trying, but I never added the code in the databack.php. So everything will work no matter which XML you used. You might just have an extra setting in the admincp that won't work anyways, because I deleted the code before I ever released it. :)
Actually, that might be a setting that would be good. On the same principal of renaming the admin and mod cp directories in the config.php file, if you get my meaning. ;)
Logikos
04-26-2006, 07:37 PM
I was making it so it would be the name you selceted in the admincp, then the date. For example: vbhbackup-4-23-06.sql. They have to be unique names for when updating it each day, or they will over-right each other
hi all,,
where it saves the database back-up ??????
Logikos
04-26-2006, 07:41 PM
You have the setting in the admincp. Go to Admincp => vBulletin Options => Database Backup Settigs => File Dump Path :)
Logikos
04-26-2006, 07:43 PM
Adding a screenshot of the settings.
Boofo
04-26-2006, 07:48 PM
I was making it so it would be the name you selceted in the admincp, then the date. For example: vbhbackup-4-23-06.sql. They have to be unique names for when updating it each day, or they will over-right each other
Couldn't you do a setting for the name if it is NOT an hourly backup? I backup once a week. I think that is more than enough and doesn't flood the directory with a lot of files of size. Most users won't do more than one backup a day, anyway. No real need to. ;)
Beller
04-26-2006, 07:49 PM
Installed..You never know when you will need this one!
Logikos
04-26-2006, 07:55 PM
I backup every 12 hours over-righting the old backup. Then I go to the directory once or twice a week and clean it up manually. Gotta have some work as an admin :p
Boofo
04-26-2006, 08:00 PM
I'm sure I can figure out how to add the setting for it. ;)
Logikos
04-26-2006, 08:01 PM
When you do, don't forget to share it with us. :p
puertoblack2003
04-26-2006, 08:16 PM
I try to run the script in Sheduled Tasks and it creates a error-file with this error message:
mysqldump: Out of memory (Needed 661284 bytes)
mysqldump: Got error: 2008: MySQL client run out of memory when retrieving data from server
even though i like the hack i can't installed it...i'm assuming you're with dreamhost...i send them an email because i had the same problem and this is there response hopr this can help...
Hello,
Your database is large at 124MB and we divide the server up into multiple
Mysql instances each with a 50MB memory limit. You will not be able to
backup the database on your own because of this. Dont worry though, we
backup the database for you every day.
Thanks!
Boofo
04-26-2006, 08:36 PM
When you do, don't forget to share it with us. :p
You already had the setting there, editing the php file is all that it should take.
bashy
04-26-2006, 08:36 PM
Hi peeps
This dont appear to be working for m8 :(
It says
Automatic Database Back-up
Done
yet the folder is empty, I have manually ran this about 5 tims now pmsl..
The php is in the cron directory....
I do have the correct path to the file, found using the php info
Perhaps i will have about 5 in the dir in the morning lol
Baffled me is :)
Boofo
04-26-2006, 08:40 PM
Hi peeps
This dont appear to be working for m8 :(
It says
Automatic Database Back-up
Done
yet the folder is empty, I have manually ran this about 5 tims now pmsl..
The php is in the cron directory....
I do have the correct path to the file, found using the php info
Perhaps i will have about 5 in the dir in the morning lol
Baffled me is :)
Did you chmod the directory to 777 like it says to?
shadowdancer36
04-26-2006, 11:34 PM
Where are the options at that you show in your screen shot? I've looked all over and haven't seen it.
I think this is a great idea. You think you can add a way to send out a message to users online saying system maintence is bout to happen, blah blah blah... and disable the board until the download is complete? Then bring it back up and notify the admin that it is done? Makes me think back to the old days of BBSin when TAG or Teleguard did it's tasks.
Boofo
04-27-2006, 01:45 AM
Look in the vBulletin Options under Database Backup Settings. ;)
Zidane007nl
04-27-2006, 02:53 PM
Installed it without problems. Great job. That will hopefully protect me more from my forum being hacked...
bashy
04-27-2006, 03:10 PM
Of cousre i didnt, else it would have worked...pmsl... :o
Cheers boofo, its usually the most obvious :o
Did you chmod the directory to 777 like it says to?
bashy
04-27-2006, 03:15 PM
One small query if i may?
My normal database backup is about 30mb
Using this hack its 25mb (not using compression) why would this be please?
Boofo
04-27-2006, 03:17 PM
Installed it without problems. Great job. That will hopefully protect me more from my forum being hacked...
It won't protect you or off any more sevurity than you have now. It will just make it faster and easier for you to get your site up and going again. ;)
Boofo
04-27-2006, 03:43 PM
One small query if i may?
My normal database backup is about 30mb
Using this hack its 25mb (not using compression) why would this be please?
That's normal, you're ok. The database takes up space, too. ;)
bashy
04-27-2006, 04:47 PM
Ok boofo only if ya sure, cant quite get my head around that actually..
Normal backup is 32.54mb on my pc
This hack backup 24.56mb pn my pc
So what actually cause this, just so i can get my head around it please :)
Boofo
04-27-2006, 05:32 PM
Ok boofo only if ya sure, cant quite get my head around that actually..
Normal backup is 32.54mb on my pc
This hack backup 24.56mb pn my pc
So what actually cause this, just so i can get my head around it please :)
Haven't you been deleteing some hacks off of your site lately? ;)
Beller
04-27-2006, 07:23 PM
It seems to be working fine.
Is it supposed to create an empyt error txt file with each back up?
topsoftware
04-27-2006, 09:24 PM
helo
i instal this hack but i have error
Automatic Database Back-up
Warning: exec() has been disabled for security reasons in /includes/cron/databack.php on line 21
Warning: exec() has been disabled for security reasons in /includes/cron/databack.php on line 26
i musy change any to databack.php fike
tha,ks
Logikos
04-27-2006, 09:32 PM
Your host has that feature disabled. You have to contact them to enable it.
Logikos
04-27-2006, 09:34 PM
Ok boofo only if ya sure, cant quite get my head around that actually..
Normal backup is 32.54mb on my pc
This hack backup 24.56mb pn my pc
So what actually cause this, just so i can get my head around it please
Bashy, thats normal. Its all in how the file is created, line brakes, whitespace, etc... I assure you there isn't any missing data. ;)
BeaLzeBuB
04-27-2006, 10:29 PM
thats is thank you man.
installed
now waiting
theArchitect
04-27-2006, 10:34 PM
Forgive the nOObie question, but does this work using the same system as a SSH autobackup?
I have set-up a script, with a friends help on my server which takes care of my back-ups, but this hack could be useful for other site I work on where I don't have SSH access and can't set-up something similar to my system.
But I am very nervous of the AdminCP back-up system.Just bumping my own question.
Logikos
04-27-2006, 11:27 PM
Yes this is the same concept, instead php is running the command and pointing to which directory to save to. Sorry, must have missed your comment theArchitect. :)
topsoftware
04-28-2006, 04:53 AM
Your host has that feature disabled. You have to contact them to enable it.
i dont anderstand can you help me or unistal hack
Logikos
04-28-2006, 05:54 AM
Your hosting provider has disable that feature on there sever. You have to ask them to enable it, or you won't beable to use this hack.
briansol
04-28-2006, 01:55 PM
I would LOVE to see this made into a full/bitwise backup system.
Sunday night, Full back up.
Monday-sat, just each day's back up.
repeats, overwriting sunday's and so on...
On big boards, it can sometimes take 4 hours to back up a database, and doing this on a daily basis is simply not feasable.
Mattikana
04-28-2006, 08:00 PM
Typo: Database Backup Settings
Boofo
04-28-2006, 09:22 PM
Typo: Database Backup Settings
You don't have any Settigs? You must be using one of them high-falootin' message boards. ;)
Feckie (Roger)
04-28-2006, 09:53 PM
LiveWire
Anychance of adding the FTP back-up to this also
:cool:
Logikos
04-29-2006, 01:22 AM
@briansol I could look into this over the weekend.
@Feckie (Roger) Example? Whats an FTP Backup?
rinkrat
04-29-2006, 04:00 AM
Works great, and even gets compressed. Sweet!
Logikos
04-29-2006, 04:56 AM
Glad you like rinkrat! :)
hadog
04-29-2006, 09:12 AM
Hi
I installed
I get an error file created when run
'mysqldump' is not recognized as an internal or external command,
operable program or batch file.
I am running mysql5 if that is a help
Feckie (Roger)
04-29-2006, 11:01 AM
@briansol I could look into this over the weekend.
@Feckie (Roger) Example? Whats an FTP Backup?
Backing up to an external ftp site
(Offsite To Where The Main Server Is)
gedsta
04-29-2006, 06:10 PM
Warning: exec(): Unable to fork [mysqldump --add-drop-table -hlocalhost -uxxxx -pxxxx xxxx_ 2>c:/Inetpub/vhosts/xxxx/httpdocs/forum/xxxx/databack//04-29-2006-error.txt >c:/Inetpub/vhosts/xxxx/httpdocs/forum/xxxx/databack//04-29-2006.sql] in \includes\cron\databack.php on line 21
help please :-)
Logikos
04-29-2006, 08:27 PM
@hadog, I'll have to see what to use for mysql5. For the time being, I would disable this product.
@gedsta, it looks like the script was trying to fork too many times. Ask your host to increased the process limit for exec() and give it a shot. Should work after that.
yinyang
04-30-2006, 06:14 AM
installed and working flawlessly. thanks!
BeaLzeBuB
04-30-2006, 10:08 AM
thats is thank you man.
installed
now waiting
it is working great :D
creedmaniac
04-30-2006, 05:47 PM
is this supposed to create a date.sql and a date-error.sql everytime it runs? (i'm hoping it's supposed to be making the error.sql...cuz if it's not something's wrong with mine...it's going to the correct folder though so i don't know what else would be wrong)
Sleazy
04-30-2006, 06:07 PM
Hi,
For some reason this hack creates the tar files in my backup folder each day but they are always empty. Any idea of what maybe causing this?
Thanks
jamshed
05-01-2006, 08:17 AM
Hay
when i hit Scheduled Task Manager on Run Now i got problem :S
Invalid SQL:
INSERT INTO upload_cronlog
(cronid, dateline, description)
VALUES
(25, 1146474570, 'Saved backup of databse to /public_html/forum/XXXX on 05-1-2006 at 5:09am (file name 05-1-2006.tar.gz');
MySQL Error : Table 'slipenc_vb.upload_cronlog' doesn't exist
Error Number : 1146
Date : Monday, May 1st 2006 @ 05:09:31 AM
Script : http://www.XXXXX.com/forum/admincp/cronadmin.php?do=runcron&cronid=25
Referrer : http://www.XXXXXX.com/forum/admincp/cronadmin.php?do=modify
IP Address : XXXXXXXXXXX
Username : XXXXXX
Classname : vb_database
help plz
Logikos
05-01-2006, 10:16 AM
Jamshed, It looks like your log_cron_action() function was changed. The default vBulletin table is called cronlog. In your error, it is showing up as upload_cronlog.
What is your table_prefix named? You can find the name by opening the /includes/config.php file and looking for: $config['Database']['tableprefix']
I also need you to post your log_cron_action() function. Open /includes/functions_cron.php and search for:
function log_cron_action($description, $nextitem)
Post the code in between the brackets ({}). The default vB function is:
function log_cron_action($description, $nextitem)
{
global $vbulletin;
if (defined('ECHO_CRON_LOG'))
{
echo "<p>$description</p>";
}
if ($nextitem['loglevel'])
{
/*insert query*/
$vbulletin->db->query_write("
INSERT INTO " . TABLE_PREFIX . "cronlog
(cronid, dateline, description)
VALUES
($nextitem[cronid], " . TIMENOW . ", '" . $vbulletin->db->escape_string($description) . "')
");
}
}
Also, does this happen on all your task managers? Try running another one and let me know if the same thing happens. :)
tqvn2004
05-01-2006, 10:38 AM
I cann't get this hack to work on my site! I did as instructed, and chmod the folder as 777, but there is no output sql file when I try to run the cron task!
My host does not specify _SERVER[PATH_TRANSLATED], _SERVER["DOCUMENT_ROOT"] is "/customers/x-cafe.com/x-cafe.com/httpd.www/", therefore I set the File Dump Path as "/customers/x-cafe.com/x-cafe.com/httpd.www/forum/backups". And the backups folder is 777. I received no error message when running cron task, it said DONE. But no file is outputed! Please help!
jamshed
05-01-2006, 12:59 PM
LiveWire Big Thanks problem solve..:banana: :banana:
creedmaniac
05-01-2006, 02:47 PM
is this supposed to create a date.sql and a date-error.sql everytime it runs? (i'm hoping it's supposed to be making the error.sql...cuz if it's not something's wrong with mine...it's going to the correct folder though so i don't know what else would be wrong)
you skipped me livewire :)
Logikos
05-01-2006, 09:00 PM
@creedmaniac and tqvn2004: Upload the attached file anywhere on your site and send me a PM of the link so I can check your server settings.
Didn't mean to skip :p
Logikos
05-02-2006, 02:50 AM
@creedmaniac: Thanks for the quick PM! Okay make sure that your File Dump Path setting is set to the following.
I would suggest place this in a folder outsite of the public_html folder for security reason. To do this, log into your website via FTP. This will place you in the /home/inara/ directory. Create a folder and name it whatever you want. I named mine databack.
Once you have finished that. Log into your admincp panel and make your way to the Database Backup Settigs. This is under the vBulletin Options. Make your your File Dump Path settings is set to /home/inara/databack (no ending slash). Then run the cron and give it a good 15 mins to transfer the database to that folder. The time all depends on the size of your database. Let me know if that fixed it. :)
ConqSoft
05-02-2006, 02:57 AM
How about an option to have it keep the last X number of backups, and rotate out the old ones as needed? (Sorry if this has already been suggested; I didn't read the whole thread.)
Thanks!
hadog
05-02-2006, 08:15 AM
LiveWire
get any time to check on my problem? Mysql5 and autobackup?
creedmaniac
05-02-2006, 11:31 AM
@creedmaniac: Thanks for the quick PM! Okay make sure that your File Dump Path setting is set to the following.
I would suggest place this in a folder outsite of the public_html folder for security reason. To do this, log into your website via FTP. This will place you in the /home/inara/ directory. Create a folder and name it whatever you want. I named mine databack.
Once you have finished that. Log into your admincp panel and make your way to the Database Backup Settigs. This is under the vBulletin Options. Make your your File Dump Path settings is set to /home/inara/databack (no ending slash). Then run the cron and give it a good 15 mins to transfer the database to that folder. The time all depends on the size of your database. Let me know if that fixed it. :)
that's what it's already set to, so nope...still getting a .sql and an error.sql
Logikos
05-02-2006, 12:39 PM
@hadog I'm still looking into this issue with mysql5. I'm hoping to update this hack soon and see why mysql5 is causing problems.
@creedmaniac: This should add a file called 05-1-2006.sql and 05-1-2006-error.txt to your /home/inara/databack directory. If you have it set to .tar.gz, then you will only get a 05-1-2006.tar.gz file in the directory. 05-1-2006 is the date of the current backup. At the moment the error files do not process when your using the .tar.gz menthod. This isn't a bug, this is just by design. I'll be updating some settings soon.
Are you at least getting the backups to the directory?
To Everyone
Is there anyone else using this hack with MySQL5? If so, is it working?
5wayshosting
05-06-2006, 05:14 AM
Thanks for this hack..
Logikos
05-06-2006, 11:03 AM
No problem. :)
hi nice hack byt i use it 3 days and my 3 backups its empty...now i change the option to do backup without compresion byt i dont thing thats my problem.
anyone have idea?
Edit:Same thing also without compres.(empty file)also one txt file apeard with this inside..
sh: line 1: mysqldump: command not found
Logikos
05-06-2006, 07:39 PM
Thats what the error.txt file is for. It's letting you know that mysqldump: command not found. Means you don't have that feature installed on your server. You would have to ask your host to enable it or install it. (mysqldump)
LOL i forget this step :) thanks for responce
kurtbarker
05-07-2006, 04:46 AM
Hey LiveWire... When I used to do this manually using the ACP, I was getting database sizes of over 100mb, using the auto system i'm getting database sizes of just over 90mb... is it missing something in the backup?
No its normal...my db its 80 and im get 73mb backup
Smiry Kin's
05-07-2006, 03:49 PM
an option to go to a throw from back up databases would be cool..
no possible way to make this able to go to another FTP address?
Quarterbore
05-09-2006, 12:46 AM
Is there any advantage to using this over a traditional server driven CRON job?
For those that can not get this to run on your server because of the settings... if you server allows you to run CRON jobs I have a page that can help you program your own CRON jobs to back up your MySQL databases here:
http://adultwebbusiness.com/adultbusinessforums/viewtopic.php?t=54
No worry, there is no adult content on there ;)
Oh yea, that is one of my sites I have not upgraded to vB yet too...
cclaerhout
05-15-2006, 12:06 PM
Backing up to an external ftp site
(Offsite To Where The Main Server Is)
And the answer is... ? :D ;)
Logikos
05-15-2006, 02:20 PM
I'll see what I can do. That is something that I've never done and will need alot of research and testing before I can insert that addon to this hack.
cclaerhout
05-15-2006, 02:59 PM
Thanks for your answer :)
I hope you will succeed !
Yorixz
05-15-2006, 05:02 PM
Wonderful addon, you got my vote in the poll for sure.
I've got one little feature request which I'm sure of that there will be others who'd like it as well; maybe you can add it so you can specify the max. number of backups you want to keep stored. I, and I'm sure I'm not alone, am on a shared hosting so I haven't got "unlimited" space, therefore I'd love to see a feature to simply have 3 backups at all time; when a new one is made the last one could be deleted to make room.
Keep up the great work and hopefully you'll add it ;)
Logikos
05-15-2006, 05:03 PM
Thats a nice idea! I will look into that as well. Thanks for your vote! :)
RemiAlone
05-15-2006, 07:51 PM
Installed it but my host has exec disabled. :(
Installed and running now. When I run it though my site slows to a crawl, a lot of timeouts and such.
How long does it take to make a backup? (1gig sql uncompressed db here)
Can I stop it halfway through somehow?
EDIT: Also, I only see how to make this run Every X Time. Is there a way to say run at 5am GMT+1 every day, for example?
EDIT2: Alright it seems the lag was caused because the script ran 3 SQL Dumps at the same time. Every time the server admin tried to kill one it started over again. Any idea why this happened? The script was set to run once every 23 hours.
Tralala
05-26-2006, 07:28 AM
I've got one little feature request which I'm sure of that there will be others who'd like it as well; maybe you can add it so you can specify the max. number of backups you want to keep stored. I, and I'm sure I'm not alone, am on a shared hosting so I haven't got "unlimited" space, therefore I'd love to see a feature to simply have 3 backups at all time; when a new one is made the last one could be deleted to make room.
Keep up the great work and hopefully you'll add it ;)
Agreed, great idea. As it stands now I'll probably have to manually clean out the backup folder from time to time.
I also think it's a good idea to suggest putting a simple index.html file in File Dump Path... otherwise in the off-chance someone guesses the backup directory name, they'd be able to download all of the forum backups simply by navigating to it in their browser.
Angelus
06-03-2006, 07:09 PM
hi.
the hack ist very well. thanks for this. BUT i have one error message:
Datenbankfehler in vBulletin 3.5.3:
Invalid SQL:
UPDATE session
SET lastactivity = 1149365202, location = '/admincp/cronadmin.php?do=runcron&cronid=15', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '1104b4313e8dc9116022d6011e23ece3';
MySQL-Fehler : Lost connection to MySQL server during query
Fehler-Nr. : 2013
Datum : Saturday, June 3rd 2006 @ 10:07:13 PM
Skript : http://www.twingo24.de/admincp/cronadmin.php?do=runcron&cronid=15
Referrer : http://www.twingo24.de/admincp/cronadmin.php?do=modify
IP-Adresse : xxx
Benutzername : Karlheinz
Klassenname : vb_database
i hope for help
Logikos
06-06-2006, 09:51 PM
You Lost connection to MySQL server during the cron. This could have been a number of things and not just this hack. Try running the script again. If the problem still continues then let me know. You might have to ask you host why this is happening. BTW, how big is your forum?
FreshFroot
06-07-2006, 03:37 AM
The weird part I had, was when I ran the task, I checked my folder. It has 2 files, 06-7-2006-error.txt and has a 06-7-2006-.sql......
What's that mean? My database wasn't backed up properly?
Logikos
06-07-2006, 04:38 AM
The 06-7-2006-.sql should be your database file. The error text is there to tell you if any errors occoured while backing up the system. How big is your 06-7-2006-.sql file?
FreshFroot
06-07-2006, 08:55 PM
I believe it is 25MB... which seems too small I think? The sql file says 0kb, so I wouldn't be able to figure out the error?
AndyP
06-09-2006, 11:49 AM
Installed and got it working (after taking a while to figure out the settings I needed).
Great mod. Just what we needed.
Replicators
06-12-2006, 12:55 AM
My host automatically does this, but i think this is even better as i can have my other admins do a restore without having to go in the ops. Great mod for people who don't have hosts that do this automatically!
Boofo
06-12-2006, 01:11 AM
Mine did too and when the HD crashed and I lost the site, guess which drive the backup they do was on. :cross-eyed:
briansol
06-20-2006, 02:01 PM
something seems odd in my backup from last night. Out of no where it jumps extensively.
I store attachments in the file system, so thats not the cause. I KNOW I didn't have 80mb worth of members and posts yesterday.
Anyone see anything like this before? I have no error logs or anything...
:banana:
melefire
06-21-2006, 09:52 AM
Thanx works great
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.