vBulletin Cron Based Database Backup

[Paul M]

There is no limit to the size it will process, if you get timeouts then you need to check php timeout settings and also mysql timeout settings.

That said, with a database that size, I would not rely on just this mod as a backup method.

[washingtonboise]

I have tried some other scripts like mysqldumper, and they are all timing out, probably mysql timeout.

I find it surprising that people are telling me I can log in to SSH, run a few commands (like five), and the server will make a perfect, fail-proof copy of the database.

Are scripts limited from using the same kind of commands like 'wget' that work so reliably in SSH? It's starting to look like I'm just going to have to buy a book and learn the shell commands.

[Paul M]

I find it surprising that people are telling me I can log in to SSH, run a few commands (like five), and the server will make a perfect, fail-proof copy of the database.
This is correct, read up on "mysqldump" :)

[Hostboard]

Back in 08ish I wrote a Perl script that not only backed up the database but also the physical files. I ran it via CRON but it could also be manually envoked. You can use the single line in the code below noting the mysqldump as Paul mentioned. The code below will give you an idea of what you need to read about (mysqldump switches) to get a proper backup.

#!/usr/bin/perl
# System Backup
#------ Variables ------
$backupdir = "/usr/local/DirectoryOfBackUpLocation"; # "." for current
$other_dirs = "/usr/local/DirectoryToBeBackedUp1 /usr/local/DirectoryToBeBackedUp2";
#-----------------------
print "Backup Initiated...\n";
@timenow = localtime(time);
$newfilename = sprintf("%02d",$timenow[4]+1) .
sprintf("%02d",$timenow[3]) . ($timenow[5] + 1900);
print "Using Filename: $newfilename.sql \n";
print "Starting database backup... \n";
system "mysqldump -qce -r $newfilename.sql -u root DataBaseName";
print "Starting Compression... \n";
system "tar czf $backupdir/$newfilename.tar.gz $other_dirs $newfilename.sql";
unlink "$newfilename.sql" || print "Error: Cannot delete file specified: $newfilename - $_ \n";
print "Done. \n"


I use Paul's modification on ALL my sites and am surprised it is not a default VB option. As backups are critical if you run a site.

If I had any requests it would be to have an option to also include the physical files and auto purge backups X days old.

[cameraguru]

What a life saver a good backup can be!

Thanks

[grasshopper1983]

hi paul

someting wrong here

It make a date folder in my backup folder... but its not wrinting the .sql files...

and still getting the Backup Error : Could not write to destination file

what i'm i doing wrong?

thanks

[Paul M]

That would be a permissions error.

[Hostboard]

hi paul

someting wrong here

It make a date folder in my backup folder... but its not wrinting the .sql files...

and still getting the Backup Error : Could not write to destination file

what i'm i doing wrong?

thanks

CHMOD the backup folder to 777 Also make sure the backup folder is NOT in your websites directory but rather off of the root of your account.

[BadgerDog]

This may sound silly, but to get it to just backup every day of the week and overwrite the previous weeks files so it doesn't keep growing, do I change the field Y-m-d and put a lower case letter "L" l in that field?

Thanks .. :)

Regards,
Doug

[Paul M]

Yep, that sounds about right.

[BadgerDog]

Yep, that sounds about right.

Thank you.... :)

Regards,
Doug

[singh9211]

Gr8 mod, working fine after installation.

Is it possible to have an remote backup option(remote file transfer through FTP or scp or rsync, etc) available with this mod.

[TeknoSounds]

Gr8 mod, working fine after installation.

Is it possible to have an remote backup option(remote file transfer through FTP or scp or rsync, etc) available with this mod.

setting up remote transfer would be outside the scope of the mod, as it would be a nice feature, the process of setting up a secure rsync connection is quite a pain as it needs generated passkeys to verify passwords and all sorts of fun stuff. If it was possible I think the amount of work involved to get it running wouldn't fun for Paul.

Heres a howto for you tho:
http://thedrupalblog.com/setting-passwordless-automated-rsync-backup

[odie3]

Thanks for this mod. I had one like this for vB 3.6.x but one thing it would do was to create a folder for the year, then month under it, then day under it - then the backup files would go into that folder.... that's a nice option, can yours do that too?

nm, i like the lower case "L" options from http://uk.php.net/manual/en/function.date.php better I think.

[sc123]

Is this reliable?

[MarceloS]

Paul, your product is great, and I use it in all my sites.

I have two suggestions, maybe for a paid version (I would be willing to purchase):
1. Auto-delete older backup files (you could choose to keep only the last "X" files).
2. Send to Amazon S3 or other storage system.

Thanks

[MarceloS]

Is this reliable?

Yes it is! I had to use hte backup files once and it worked perfectly.

[iyama]

Processed Database in 17.986 seconds

[Compressing Combined File] : Processed File Compression in 0.011 seconds

Backup Completed Successfully

3.5G ;)

The line: <!-- $Header: F:\CVS/4.x/Auto-backup/Auto-backup.txt,v 1.3 2010/12/04 22:52:33 Pem Exp $ -->

Is that for the header?

[Paul M]

0.011 Seconds ?

That suggests it simply skipped the compression.

That line is a cvs comment.

[fxwoody]

Hi Paul, i might have a little question here, been using your plugin for over a year now and works like a charm, tho, i had to upload one of the b-up in my test site and when it finished, every words in french that had an accent ????^ got lost and replaced by "?" instead!
I looked into the setups from the language manager and they are set to ISO-8859-1, in MyPhpAdmin the charset are UTF-8 and collation Latin1_general_ci. Normally this setup shouldn't loose any of the special character but it does!

Now, i know that phpMyAdmin as updated and the options to export and import have kind of changed (they added more option to the fields) and since i'm not a top gun i wondered if you would have an idea about this!?!?

I also looked in the ACP option and the "Censorship Options" / "Blank Character Stripper" are still the same as originally " 160 173 u8205 u8204 u8237 u8238" .
So as far as it goes the only probable mistake i can find could be from the "collation_connection" and "collation_server" that are set to "latin1_swedish_ci" instead of "general_ci"!

But could this little difference make it all happen???
Thanks in advance Paul, i would appreciate some advice here :o:rolleyes::up:

[fldewey]

Works perfect - thank you.

[DaVitsche]

no matter what I try I keep getting this error
Backup Error : Could not write to destination file ( ../testbackups/2011-09-28/Forum-2011-09-28-Access.sql )

I manually created the folder /testbackups and the folder /2011-09-28 gets created automaticly.
I've set 777 to the testbackups folder and all subfolders, but the file itself isn't being written.

This is the path I filled in Vbulletin automatic options: ../testbackups/

What am I missing?

after losing 8 years worth of content after 2 issues I want those backups to work!

[Paul M]

Its a permissions error of some kind, you probably need to speak to your host.

[charlesr]

I had the same problem as DaVitsche - no amount of permission fiddling would work. Moving the backupfolder inside the normal website structure at the same level as "includes" for example worked fine with chmod 755.

[Trevor Matthews]

Hi
I too have the same problem.

backBackup Error : Could not write to destination file ( ../../backups/2011-10-08/Forum-2011-10-08-Access.sql )

I created a folder called backups and put in the forums folder and tried it in the root of the server but I stil get the above error.

Permissions were tried at 777 and 755.

Any idea what I have done wrong?

[Trevor Matthews]

Problem solved.

I created a folder called backups and placed it in the same folder as my forum.

I then set the path to backups/
That solved the problem and it now works.

How do I know if I have any InnoDB Tables

And should I set block processing to on and what size should I select?

My forums database is about 40meg on the server and the gzip file is 10meg, does that sound right?

Thanks for a very useful mod.

[Paul M]

You should avoid saving backups anywhere that is acessible over the web (like in your forum folder). If you must, then at the very least protect the folder using htaccess. If you dont anyone can access your backups by typing in the url.

[Trevor Matthews]

It seems Cometchat uses InnoDB tables.
I have this installed so have selected that option.

[TeknoSounds]

Hi
I too have the same problem.

backBackup Error : Could not write to destination file ( ../../backups/2011-10-08/Forum-2011-10-08-Access.sql )

I created a folder called backups and put in the forums folder and tried it in the root of the server but I stil get the above error.

Permissions were tried at 777 and 755.

Any idea what I have done wrong?

Problem solved.

I created a folder called backups and placed it in the same folder as my forum.

I then set the path to backups/
That solved the problem and it now works.

How do I know if I have any InnoDB Tables

And should I set block processing to on and what size should I select?

My forums database is about 40meg on the server and the gzip file is 10meg, does that sound right?

Thanks for a very useful mod.

You can set the folder outside the forums using the relative path. Such as "../backups/" This path works for me currently. But as mentioned if anything you will need to protect it with a htaccess user/pw to ensure its not immediately accessible from the net.
I see in your previous post you used "../../path/"
That path will go up 2 folders from the VB forums folder. The question is does your linux user have permissions to be able to write to that folder?
And yes, that zip file sounds about right for the correct size.

[FTDave]

If you don't install this you are insane. :)

This little hack has saved me big time!!!!

Thank you!!!

[Paul M]

Updated: This is now available for the 4.1.x series of vBulletin only.

[BirdOPrey5]

Paul,

Any reason to upgrade if the old version is working well? Any new features?

[misericorde]

Thank you Updated

Nice

[Marios858]

Thanks mate , you are the best !!! Excellent mod !!!

[HMBeaty]

Paul,

Any reason to upgrade if the old version is working well? Any new features?
The only changes I see in it are in:

includes/mysqlbackup.php
includes/cron/cronbackup.php

So really, all you have to do is upload the files. No need to import the .xml. (Paul, please correct me if I'm wrong)

[Paul M]

Paul,

Any reason to upgrade if the old version is working well? Any new features?

Simply bringing all of my mods into line, not all will have changes other than the version.

[Trevor Matthews]

Thanks TeknoSounds, as it is all working correctly I will just add the .htaccess file to it.

[Cicada]

Processed Database in 99.906 seconds

Backup Completed Successfully
Done


:D thanks for this!

[Desibabu19]

This is fantastic hack. If at all one needs only one hack, this should be it.

Paul, I have a question.

Some time, I see the compression is not done, and I have the inflated file for few days while most of the days the compression is done.

What can I do to ensure the compression is always done ? why would it skip compression some time ?

[Paul M]

The mod will always instruct the server to gzip the file (if you have the option set). If its not doing it sometimes then thats a server side issue.

[Trevor Matthews]

Hi
I have had this working happily until I moved the forum to a virtual private server over the weekend. I now find there are no backups being created anymore.

Am I right in thinking that there was an option to create a backup immediately to allow me to test the settings???

I thought there was but I can't find it.

I have found the full path to my forum is along the lines of /var/www/vhosts/forum name/httpdocs/backups/ but it still doesn't make a backup.

I get no errors but I am sure there was a create backup now button.

[Paul M]

Just use the run now option in the Scheduled Task manager.

[Trevor Matthews]

Thanks Paul

I knew the option was there somewhere :-)

[Trevor Matthews]

Actually the path was correct. It seems the folder permissions had managed to change themselves in the move over to the new server.

Not sure how that happens.......

All working nicely again.
Many thanks.

[p@ndu]

Processed Database in 98.509 seconds

[Compressing Combined File] : Processed File Compression in 19.182 seconds

Backup Completed Successfully

Done

[MaXimus]

I installed it on vBulletin v4.1.8, but how do I create my first backup? (sorry for the n00b question)

Is it even compatible with 4.1.8?

[Paul M]

I works with any 4.1.x

The backup is run automatically by the vb cron system.
If you want to manually test it see post #542 above.

[MaXimus]

worked fine thank you

I created a folder in my forums directory name: backups

and I put the setting in the plugin to backups/

[Boofo]

worked fine thank you

I created a folder in my forums directory name: backups

and I put the setting in the plugin to backups/

Not a good place to have it as that makes your backups available to almost anyone. The best place for the backups folder is in the same folder as public_html. Then use the following for the path:

../../backups/

If you can't do that, then at least password-protect the folder via htaccess.

[Kyoshokid]

Thanks Tom, another awesome mod.

[Paul M]

Tom ?

[shuuk]

hmm what code is the back up format? its not utf8 :/
how can i find out?

[MaXimus]

Not a good place to have it as that makes your backups available to almost anyone. The best place for the backups folder is in the same folder as public_html. Then use the following for the path:



If you can't do that, then at least password-protect the folder via htaccess.

Thanks a lot for the tip bro

but when I did that and ran the backup, I got the following error message:

Automatic Database Backup for vBulletin

Warning: include_once([path]/./includes/cron/cronbackup.php) [function.include-once]: failed to open stream: No such file or directory in [path]/admincp/cronadmin.php on line 113

Warning: include_once() [function.include]: Failed opening '[path]/./includes/cron/cronbackup.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/admincp/cronadmin.php on line 113

Done

I created a folder named backups in the root of public_html

what do you think I should do?

[Boofo]

Are your forum files under the forums directory or in the domain root itself?

[MaXimus]

Are your forum files under the forums directory or in the domain root itself?

no the forum files are in

public_html/forums

my Wordpress site is in the public_html

[Boofo]

I have it set up like this:

vb4_db_backups
public_html

Then you can use what I posted earlier but make sure the folder is chmodded to 777.

[MaXimus]

I have it set up like this:

vb4_db_backups
public_html

Then you can use what I posted earlier but make sure the folder is chmodded to 777.

got it done at last!

thanks a lot bro!

[Bergler]

Is there a way to set this up so everytime it backs up, it overwrites the existing file instead of creating a new file everytime?

[Paul M]

Change the filename date setting to something that doesnt change often, like Year, or Year+Month.

[MaXimus]

I have created a database backup

let's say I wipe my forums entirely and want to reinstall it from scratch, how do I restore this database backup to have all my members, posts, threads restored?

[TeknoSounds]

I have created a database backup

let's say I wipe my forums entirely and want to reinstall it from scratch, how do I restore this database backup to have all my members, posts, threads restored?

command line mysql or phpmyadmin

google restore for whichever method you have access to.

I wouldn't test on a live forum, could always backup and restore to a new DB and build your forum up before wiping the old one.

[nightbloom]

Installed it, made the backups folder, test ran it.

Perfect.

Thanks!

[molieman]

I just updated to the latest version of AutoBackup. I'm running vB 4.1.8

I just ran a backup and noticed the file size was half of what I would of backed up using SSH.

Combine Files set for "yes" and all others are "no"

You're help will be appreciated :)

[molieman]

Just wanted to ad to my last post:

There is a change in regards to the "AutoBackup" backup file and when I do it through SSH command line.

Command line method: 333,781,110 bytes
"AutoBackup" method: 497,856,231 bytes

There are a total of 380 tables, SSH restores all, "AutoBackup" 2/3 of the total.

This does not make sense to me, perhaps someone else it will..... :)

Again, any help to make this work for me will be appreciated :)

[molieman]

I'm not getting support, so I'll have to uninstall.... too bad. It seems to work for most.

[ali1359]

Does it work in 4.1.9 ?

[ahobilam]

I installed it in VB4.1.9
No error while and after installation found!
I could not find anything in the Admin CP to change settings?!
No additional tab or not listed in the options?!
So, I uninstalled it.

[Paul M]

Does it work in 4.1.9 ?
Yes.

[chimaira]

Getting Warning: include_once([path]/./includes/cron/databack.php) [function.include-once]: failed to open stream: No such file or directory in [path]/admincp/cronadmin.php on line 113

yet i have done everything, is this an absoloute path error?

[Paul M]

You have a cron job trying to run file called databack.php - that isnt anything in this mod.

[Shadow]

I'm kinda stuck. The default value for the path is "../../backups/". Where is that directory located?

Thanks!

[pbnjj11]

I am having the same problem. not too sure where to put a backups folder at....or if that's what I have to do...help would be greatly appreciated.

[Paul M]

../ means up one level.

So if your forum is in /domain/public_html/forum, it will be at /domain/backups

[pbnjj11]

Backup Error : Could not write to destination file ( ../../backups/2012-01-04/Forum-2012-01-04-Vb4_access.sql )

Sorry paul, I still cant get it to work, /backups is at the same level as /public_html

permissions are set at 777 also.

again sorry....but all I have to do is put a backups directory at the same level as my public_html right?

[Paul M]

Possibly you have php open_basdir restrictions in place - esp if you are using Plesk.

[pbnjj11]

Not too sure where that's at. I'm using Cpanel. I will try to find that. thanks paul.

[hennnerz]

Automatic Database Backup for vBulletin
Backup Error : Could not write to destination file ( ../../backups/2012-01-08/Forum-2012-01-08-Access.sql )

Any ideas?

[Paul M]

Did you create the folder ?

If so, fix the permissions on the server so it can write to the folder.

[hennnerz]

Yah I have a backups folder set to 777, where should it be? At the moment it's just in public_html/mysite.com

[TeknoSounds]

../ means up one level.

So if your forum is in /domain/public_html/forum, it will be at /domain/backups

^^^

[anandbagmane]

do we get email notification for failed & successful backup?

[Paul M]

No.

[Valcav]

what should be the permission for the backup folder?
And can it be outside of the "public_html" folder?

EDIT:
(going to kind of answer myself a little bit...)
1) The backup folder can be placed outside the "public_html" folder
2) I currently have set the permission to 755 for the backup folder...
Just wondering if it can/should be lowered to be a little bit more secure...

[dune3000]

My direct path to folder is: /home/xxxxxxx/backups.
Backups folder permission set to 777
I run backup all successful :
Processed Database in 11.074 secondsBackup Completed Successfully Done

I find DB file : backupsForum-2012-01-22-Full-Backup.sql but not in backups folder

I look into backups folder and there is no files. What I am doing wrong?

[BrightStar]

could someone help me on how to run as cron job? I have installed the plugin but what should i do next?

Thanks

[dune3000]

How I can change : how often auto backup can be created

[Paul M]

Change the cron job settings - however, they are somewhat limited unless you want to run every hour or more.

[wheretobet]

Can you tell me the effect, if any of trying to install this on a hacked 4.1.6?

Please advise.

TY

[Paul M]

Install it and see. I cannot advise on specific set-ups.

[ALBCODERS]

i have wierd problem , after

Processing podcastitem (No Row Data)
Processing poll (25) : Processed 25 Rows in 0.007 Seconds
Processing pollvote (2230) : Processed 2230 Rows in 0.213 Seconds
Processing post (104156) : Processed 45339 Rows in 21.424 Seconds

i get this

Database error in vBulletin 4.1.9:

Invalid SQL:
SHOW CREATE TABLE `postedithistory`;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, February 8th 2012 @ 10:32:35 PM
Error Date : Wednesday, February 8th 2012 @ 10:33:01 PM
Script : http://www.myweb.com/admincp/cronadmin.php?do=runcron&cronid=41
Referrer : http://www.myweb.com/admincp/cronadmin.php?do=modify
IP Address : *
Username : my
Classname : vB_Database
MySQL Version :


Any suggestion , never happen before . I use to run version autobackup 4.0.1 for sometime, and no problems. i got 2 weeks now with this problem and i have no idea where did com from .


i installet new version 4.1.7 i have same problem :/

can u please tell me what to do guys because hostgator is so crap when u try to back up files manualy , it never gives u full kb or mb in sql files. Autobackup make such a good job, and it gives u every bit of your website.


Regards.

[HMBeaty]

i have wierd problem , after

Processing podcastitem (No Row Data)
Processing poll (25) : Processed 25 Rows in 0.007 Seconds
Processing pollvote (2230) : Processed 2230 Rows in 0.213 Seconds
Processing post (104156) : Processed 45339 Rows in 21.424 Seconds

i get this

Database error in vBulletin 4.1.9:

Invalid SQL:
SHOW CREATE TABLE `postedithistory`;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, February 8th 2012 @ 10:32:35 PM
Error Date : Wednesday, February 8th 2012 @ 10:33:01 PM
Script : http://www.myweb.com/admincp/cronadmin.php?do=runcron&cronid=41
Referrer : http://www.myweb.com/admincp/cronadmin.php?do=modify
IP Address : *
Username : my
Classname : vB_Database
MySQL Version :


Any suggestion , never happen before . I use to run version autobackup 4.0.1 for sometime, and no problems. i got 2 weeks now with this problem and i have no idea where did com from .


i installet new version 4.1.7 i have same problem :/

can u please tell me what to do guys because hostgator is so crap when u try to back up files manualy , it never gives u full kb or mb in sql files. Autobackup make such a good job, and it gives u every bit of your website.


Regards.
Hostgator is about 99% of your problem lol ;)

Anyway, in regards to your database error, again, that's an issue with HostGator. See here for more information...

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

[DAMINK]

I can confirm its hostgators error.
I recently moved host just to get away from hostgator.
I was getting about 10 - 20 of those a day!

[ALBCODERS]

why i am not suprised :/

let say that i have to tell them te fix it , what do i actualy have to say cuz i have no idea

by theway thx for respondin back , HMbeaty and DAMIK i appreciate that.

[DAMINK]

I asked them to fix it myself ALBCODERS.
There answer was as below.


Hello

Thank you for contacting HostGator.

We can't set individual settings regarding MySQL in shared environments. I can say that the wait_timeout is currently set to 3600 on the particular server hosting your account. Another factor may be coding and application configuration. Is your application attempting to use persistent database connections in any way?

These are not permitted on shared servers because they tie up database connections. If an application attempts to use them it may generate the Mysql Server has gone away messages. This would actually be an internal coding or configuration issue with either the whole application or a module within the application.



I would simply move to a better host mate.
I have a reseller account with them and dont use it for myself at all lol.
I had to move. I could not keep getting these errors.
Good luck with hostgator mate. I hope they do come to your assistance.

[UnknownKillerMC]

I myself would suggest not adding this the reason being, if your site is ever compromised well just admincp it would easily give the attackers a way to get to your database ;) my opinion but good work over all thanks for making this.

[ALBCODERS]

yeah i been planin for such a long time to move from hostgator but never found a good hosting company. Even worse with hostgator u can`t email your members for any updates or stuff, cuz they suspend your account for spamin.

[DAMINK]

I myself would suggest not adding this the reason being, if your site is ever compromised well just admincp it would easily give the attackers a way to get to your database ;) my opinion but good work over all thanks for making this.

I actually removed this mod for the same reason.
I now use a 3rd party software to do my backups. (bigdump)
I felt it would be easy for someone to point to the backup file directly just based on the fact most people dont edit anything and use the default install instructions.
It may well be safe PaulM is a great coder so i expect its safe but got me concerned regardless.


yeah i been planin for such a long time to move from hostgator but never found a good hosting company. Even worse with hostgator u can`t email your members for any updates or stuff, cuz they suspend your account for spamin.

They used to ban my ip address all the time because i kept a computer on the who is online page 24/7.
I thing i asked to have my ip whitelisted about 6 times before they actually did it.
Literally had to keep telling them i have been ip banned. They would say every time thats not the case but when investigated further it was that every time.
Find a good host mate and move. You will be happy you done it.

[RustyF]

I hate to show my ignorance this way.... :)

Do I copy the files in the includes folder to the vBulletin includes folder? Seems obvious but I'm brand new and afraid to put anything in the vbulleting file system unless I'm sure.

Thanks

[Paul M]

Do I copy the files in the includes folder to the vBulletin includes folder?
Yes.

[DAMINK]

I hate to show my ignorance this way.... :)

Do I copy the files in the includes folder to the vBulletin includes folder? Seems obvious but I'm brand new and afraid to put anything in the vbulleting file system unless I'm sure.

Thanks

Thats not Ignorance. Thats good practice mate.
I imagine a lot of vb owners who first start out just dump craploads of mods on there forum and end up having all sorts of problems. (guilty as charged)

[RustyF]

Haha you do have a point. I suspect I've learned to be careful the hardway. That is by blowing stuff up. :)

[SEW810]

Installed and working on vbulletin 4.1.10

[ayam]

perfect. working with 4.1.10

Processed Database in 1.523 seconds

[Compressing Combined File] : Processed File Compression in 0.001 seconds

Backup Completed Successfully
Done

[vinzphua]

When I run it, it keeps stopping at about the 7,200,000 block or 7,300,000 block of the postindex table. The table has about 8,000,000 records.

I enabled Block Processing and Block Size of 100,000. No error messages. It just stops.

Tried it with both Combine Files on and off. And also with block size at 50,000.

Any ideas what could be wrong?

[RustyF]

I don't do much on the server so I have lost my knowledge regarding file permissions.

What permissions should I give to my backup directory?

Thanks.

[Paul M]

That really depends on what user your webserver is using. In most cases you will need 777.

[Paul M]

Any ideas what could be wrong?
Nope, but when a script just stops, thats usually a timeout somewhere.

[del Drago]

I've been hearing that it's necessary (or at least advisable) to close your forum before doing a database backup. Is that true?

If so, should the forum be closed when this script runs?

[Paul M]

No, it isnt necessary to close it.

[Nirjonadda]

Installed Great Working On vBulletin 4.1.10

[Delfi_r]

Installed and working on vBulletin 4.1.10 great!

[DirtRider]

Two things I am not sure about here
1. When setting it up the backup folder setting just looks like this ../../backups/ so now I created a folder in my root called "backups", is this correct?
2. In the doc it tell me to " Alter the timing of the cron job to suit." where do I find this?

[Paul M]

1. "../../" just means "up two levels", so if your forum is located in /var/www/html/forums/ then ../../backups refers to /var/www/backups/

2. vBulletin scheduled tasks (in the ACP).

[BMR]

Have this installed and working, but just a quick question.

What's the recommended setting for this? Is sticking with all the default options fine?

[Paul M]

Yes, thats fine.

[Webdork]

Thank you for providing this. Baffled though as to why its not part of the default product.

[GONUMBER6]

Hello, I have this successfully working on one of my forums, went to install it and cannot get it to work!

My other forum has a previous version of it.

I get this error that has been noted already "Backup Error : Could not write to destination file ( /backups/dbbackups2012-03-21/Forum-2012-03-21-Access.sql )

and no matter how I enter it (full path or partial) it DOES, I repeat DOES create the folder, but does not put anything in it. Yes, the folder is writable. I am stumped! Any suggestions?

[GONUMBER6]

I just changed some of the settings (blocks, and stuff) in admin cp and it worked now, thanks!

[vinzphua]

Edit: Question deleted as I realised I've asked before.

[vinzphua]

I just realised I've asked before and Paul has already answered...

My next question is: where are the possible areas I might look for clues as to what's going on? Like error logs, server maximum file size, etc?

Thanks.

[deathtrancer]

Finally I found this!!! thank Paul

[StarBuG]

Hello Paul,

I love your mod and it saved my forum once after a crash.

Would it be possible to build in an Email Backup option?

Due to backups becoming larger over time something like this would be great:

Enable Backup being emailed
Split backups for Email into multiple files of size: X mb

Each file could then be emailed separately to prevent file size limitations on some email servers.

This option would greatly improve on the security of db backups in case a drive crash occures and local backup files get lost/corrupted.

[RedTurtle]

I really love this mod! Thank you for all the time and effort it took you to create it Paul. It is much appreciated.

I am wondering, is there a way I could make it so that it deletes all previous backups in the directory before writing the new one? I would only like to keep one day's backup if possible. Or would there be a way for it to delete all but the last X number of backup files before writing the newest one?

Thank you!

EDIT: Nevermind, took the time to go back a few pages and found Paul's solution of using just the name of the day (Mon, Tues, Wed, etc) in renaming backups so that it will only have 7 days total. Thanks Paul!

[HNBOBBA]

Perfect! Thanks Man from Italy!

[xCSoulSlayer]

84MB Database - Processed Database in 6.811 seconds
:) Thanks

[AndrewSimm]

Does this stop the cpanel backup from running?

[Paul M]

Ths has no connection or interaction with cpanel.

[davidg]

Paul why this mod is not included in vb 4.2 ? this one is more important then "Members who have Visited Today" or "Who has Read a Thread"

[Paul M]

Because its not one that was chosen. :)

[Boofo]

What changed in vb 4.2.0 that caused this to need to be upgraded? Just curious, is all.

[Paul M]

Just the install code I believe.

[Boofo]

Is that something we need to worry about in our mods too then?

[Paul M]

Not sure what you mean by that.

Regardless of any actual changes in the mod, I always release up to date versions when vB moves up a version (i.e 3.5 > 3.6 > 3.7 > 3.8 > 4.0 > 4.1 > 4.2).

[Boofo]

I meant did something change as to the way the install works now for mods. I just wanted to be ready in case I had to change something in that area.

But I see your point in releasing updates for major vb version.

[davidg]

What changed in vb 4.2.0 that caused this to need to be upgraded? Just curious, is all.

the old version works just fine with latest vb Boofo

[davidg]

Because its not one that was chosen. :)

let's hope they include this by default in future versions
backups are the most important part for online boards

[DAMINK]

Can you change the backup location to outside webroot?

[Paul M]

Yes, you can change it to whatever you want.

[Disco_Stu]

Works perfectly (4.2)

Great mod. Thanks. Marked as installed

[DAMINK]

Works perfectly (4.2)

Great mod. Thanks. Marked as installed

It sure is mate.
I had reservations about this mod given its default location for backup.
But being able to use the literal server location and push the backup outside of the webroot is gold. Now my favorite mod on .org.
Every vb owner should have this mod running IMO.

[autoescala]

Excellent works fine in 4.2! 5 stars rating mod

[panosha]

Can you help me find the right Backups Path ?

This one do not work ---> http://www.xxxxxxx.gr/backups/

[GamerPerfection]

Can you help me find the right Backups Path ?

This one do not work ---> http://www.xxxxxxx.gr/backups/Dude you don't "find" a backup path, you "create" a backup path.

Basically you create a folder on your server and you use that as your path.

So if you go with "backups/" as your path then you must create a folder on your server in the root directory called backups.

[charlesr]

I was a little skeptical about this working without turning the forums off, but I've successfully restored the 1.5GB database (along with a copy of the filesystem) on to a local machine and it works perfectly so far.

Kudos for a great mod. This should be standard in vbulletin. I hit "nominate".

[charlesr]

Also, sent you a chunk of paypal, so you should be good for beer for a while :)

This is the most important mod on the site.

[Paul M]

Also, sent you a chunk of paypal, so you should be good for beer for a while :)
Appreciated. Thx. :up:

[Kirk Fitzgerald]

Perfect mod, works like a dream, thank you. :) Nominated for MOTM. ;)

[letipro]

if can backup to a different host or server is excellent

[Paul M]

Well you could in theory, if you setup a folder thats actually mapped to a networked drive (using NFS for example) then the backups could be directed to it.

[rhody401]

I am using a freebie called FTPSYNCH to work in conjunction with this.

It FTP's from my PC into the website twice daily, just after the cron backups happen. (6am and 6pm) It synchs the local folder with that of the server's backup folder, effectively downloading just the sql backup created a few minutes earlier.

In addition to this, i have it doing a sql single file download once daily (overwriting every 7th day, for day of the week), so there's always a 7 day history in addition to what this add-on provides. I am only using this add on for a once weekly comprehensive backup, file by file. The twice daily ones are a single file done with a command line cron command.

There may be better ways, but this works for me :)

[Skivey]

im having trouble finding the backups.

I have the forum under a subdomain and have tried different paths for this to put the backups but nothing seems to be appearing....

Ive put the folder 'backups' under the main root and in the forum folder. Both folders are chmod 777 and yet when i run the cron nothing appears in either

I have set the options to both 'backups/' and the full url http://www.myforum.co.uk/backups/ and still nothing :(

Anyone help me here?

[Paul M]

The url will fail, it dosnt work like that.

You need the folder path, either absolute or relative.

What message do you get when you run the cron ?

[Skivey]

it says:

Automatic Database Backup for vBulletin

Done

thats why im presuming its gone somewhere.

Strange

[Skivey]

I just changed it to "forum/backups/" and chmod 777 and still nada

[Paul M]

it says:

Automatic Database Backup for vBulletin

Done


No list of tables ?

[tbworld]

Just wanted to say thinks Paul,
I have been using this for years now on an hourly basis: on top of my other backup methods (very high traffic board). Then I capture transactions between the relative hours. I have not needed it very often, but when I do --- well its a lifesaver! Thanks so much for your time and for sharing :)

[Paul M]

Glad to hear its been of use to you. :D

[charlesr]

Hourly? How big is your board? How long does it take your job to run?
And how do I find out how long it takes to run on mine? The log in vb just gives time of start and "success".

My vb control panel says:
Data Usage 1.51 GB
Index Usage 896.57 MB

[Skivey]

No list of tables ?

No list of tables... me thinking something isnt working right here

Maybe I should uninstall and start again?

[Paul M]

No list of tables... me thinking something isnt working right here

Maybe I should uninstall and start again?
Indeed, something is not right, it will list each table as it backs it up.

[Paul M]

And how do I find out how long it takes to run on mine? The log in vb just gives time of start and "success".
You need to manually run the schedule in Schedule Manager.

[Skivey]

Hmmm... I uninstalled, reinstalled and over writ all files via ftp.

Reded settings and reran the scheduled task and again I get

Automatic Database Backup for vBulletin

Done

Bit concerning this, im not doing anything wrong. :(

[Paul M]

What happens if you run the sql "SHOW tables" ?

[Skivey]

it lists me a shed load of DB tables

[Skivey]

ok, really not to worry now. Ive decided to use mysqldumper instead and create a cron with the cpanel. Not only does backups of the forum but my whole list of databases.

Thanks for trying though!! :))

[charlesr]

You need to manually run the schedule in Schedule Manager.

Thanks. Did that.

30 mins for the live backup and 7 mins for the compression.
Is that about what you'd expect for a database of my size? (see a few posts back).

No point in me running this once an hour! It would be in a constant state of backup :D

[Paul M]

30 mins for the live backup and 7 mins for the compression.
Is that about what you'd expect for a database of my size? (see a few posts back).
That seems a bit slow. I have 1.65 GB data, 900M index, and it backs up in < 10 Min.

[charlesr]

Really? How odd. I just tried it on my local PC instead (test server) which is pretty fast and it took 23mins for the backup (obviously the gzip bit didn't work), so a little faster, but not nearly as quick as yours.

Any suggestions/ideas? I checked and the database isn't fragmented to any significant degree.

[compassion23ph]

Where can i SEE the .gzip file of this?

[JMEWLS`]

Processing access (1) [Compressing File] : Processed 1 Rows in 0.029 Seconds
Processing action (18) [Compressing File] : Processed 18 Rows in 0.022 Seconds
Processing activitystream (13761) [Compressing File] : Processed 13761 Rows in 0.766 Seconds
Processing activitystreamtype (16) [Compressing File] : Processed 16 Rows in 0.005 Seconds
Processing ad (3) [Compressing File] : Processed 3 Rows in 0.023 Seconds
Processing adcriteria (No Row Data) [Compressing File]
Processing adminhelp (1801) [Compressing File] : Processed 1801 Rows in 0.091 Seconds
Processing administrator (3) [Compressing File] : Processed 3 Rows in 0.005 Seconds
Processing adminlog (7557) [Compressing File] : Processed 7557 Rows in 0.828 Seconds
Processing adminmessage (3) [Compressing File] : Processed 3 Rows in 0.077 Seconds
Processing adminutil (7) [Compressing File] : Processed 7 Rows in 0.096 Seconds
Processing album (8) [Compressing File] : Processed 8 Rows in 0.016 Seconds
Processing albumupdate (No Row Data) [Compressing File]
Processing announcement (3) [Compressing File] : Processed 3 Rows in 0.104 Seconds
Processing announcementread (112) [Compressing File] : Processed 112 Rows in 0.007 Seconds
Processing apiclient (No Row Data) [Compressing File]
Processing apilog (No Row Data) [Compressing File]
Processing apipost (No Row Data) [Compressing File]
Processing attachment (116) [Compressing File] : Processed 116 Rows in 0.065 Seconds
Processing attachmentcategory (No Row Data) [Compressing File]
Processing attachmentcategoryuser (115) [Compressing File] : Processed 115 Rows in 0.039 Seconds
Processing attachmentpermission (No Row Data) [Compressing File]
Processing attachmenttype (11) [Compressing File] : Processed 11 Rows in 0.026 Seconds
Processing attachmentviews (No Row Data) [Compressing File]
Processing autosave (1031) [Compressing File] : Processed 1031 Rows in 0.142 Seconds
Processing avatar (No Row Data) [Compressing File]
Processing bbcode (No Row Data) [Compressing File]
Processing bbcode_video (8) [Compressing File] : Processed 8 Rows in 0.125 Seconds
Processing block (12) [Compressing File] : Processed 12 Rows in 0.027 Seconds
Processing blockconfig (39) [Compressing File] : Processed 39 Rows in 0.045 Seconds
Processing blocktype (6) [Compressing File] : Processed 6 Rows in 0.017 Seconds
Processing blog (No Row Data) [Compressing File]
Processing blog_attachmentlegacy (No Row Data) [Compressing File]
Processing blog_category (No Row Data) [Compressing File]
Processing blog_categorypermission (No Row Data) [Compressing File]
Processing blog_categoryuser (No Row Data) [Compressing File]
Processing blog_custom_block (No Row Data) [Compressing File]
Processing blog_custom_block_parsed (No Row Data) [Compressing File]
Processing blog_deletionlog (No Row Data) [Compressing File]
Processing blog_editlog (No Row Data) [Compressing File]
Processing blog_featured (No Row Data) [Compressing File]
Processing blog_groupmembership (No Row Data) [Compressing File]
Processing blog_grouppermission (No Row Data) [Compressing File]
Processing blog_hash (No Row Data) [Compressing File]
Processing blog_moderation (No Row Data) [Compressing File]
Processing blog_moderator (No Row Data) [Compressing File]
Processing blog_pinghistory (No Row Data) [Compressing File]
Processing blog_rate (No Row Data) [Compressing File]
Processing blog_read (No Row Data) [Compressing File]
Processing blog_relationship (No Row Data) [Compressing File]
Processing blog_search (No Row Data) [Compressing File]
Processing blog_searchresult (No Row Data) [Compressing File]
Processing blog_sitemapconf (No Row Data) [Compressing File]
Processing blog_subscribeentry (No Row Data) [Compressing File]
Processing blog_subscribeuser (No Row Data) [Compressing File]
Processing blog_summarystats (No Row Data) [Compressing File]
Processing blog_tachyentry (No Row Data) [Compressing File]
Processing blog_text (No Row Data) [Compressing File]
Processing blog_textparsed (No Row Data) [Compressing File]
Processing blog_trackback (No Row Data) [Compressing File]
Processing blog_trackbacklog (No Row Data) [Compressing File]
Processing blog_user (55) [Compressing File] : Processed 55 Rows in 0.017 Seconds
Processing blog_usercss (No Row Data) [Compressing File]
Processing blog_usercsscache (No Row Data) [Compressing File]
Processing blog_userread (No Row Data) [Compressing File]
Processing blog_userstats (No Row Data) [Compressing File]
Processing blog_views (No Row Data) [Compressing File]
Processing blog_visitor (No Row Data) [Compressing File]
Processing bookmarksite (4) [Compressing File] : Processed 4 Rows in 0.006 Seconds
Processing cache (649) [Compressing File] : Processed 649 Rows in 2.934 Seconds
Processing cacheevent (878) [Compressing File] : Processed 878 Rows in 0.031 Seconds
Processing calendar (1) [Compressing File] : Processed 1 Rows in 0.017 Seconds
Processing calendarcustomfield (No Row Data) [Compressing File]
Processing calendarmoderator (No Row Data) [Compressing File]
Processing calendarpermission (No Row Data) [Compressing File]
Processing cms_article (255) [Compressing File] : Processed 255 Rows in 0.131 Seconds
Processing cms_category (No Row Data) [Compressing File]
Processing cms_grid (2) [Compressing File] : Processed 2 Rows in 0.012 Seconds
Processing cms_layout (1) [Compressing File] : Processed 1 Rows in 0.004 Seconds
Processing cms_layoutwidget (11) [Compressing File] : Processed 11 Rows in 0.005 Seconds
Processing cms_navigation (214) [Compressing File] : Processed 214 Rows in 0.016 Seconds
Processing cms_node (214) [Compressing File] : Processed 214 Rows in 0.032 Seconds
Processing cms_nodecategory (No Row Data) [Compressing File]
Processing cms_nodeconfig (5) [Compressing File] : Processed 5 Rows in 0.036 Seconds
Processing cms_nodeinfo (214) [Compressing File] : Processed 214 Rows in 0.025 Seconds
Processing cms_permissions (18) [Compressing File] : Processed 18 Rows in 0.005 Seconds
Processing cms_rate (No Row Data) [Compressing File]
Processing cms_sectionorder (No Row Data) [Compressing File]
Processing cms_widget (14) [Compressing File] : Processed 14 Rows in 0.005 Seconds
Processing cms_widgetconfig (45) [Compressing File] : Processed 45 Rows in 0.006 Seconds
Processing cms_widgettype (21) [Compressing File] : Processed 21 Rows in 0.013 Seconds
Processing contentpriority (No Row Data) [Compressing File]
Processing contentread (1713) [Compressing File] : Processed 1713 Rows in 0.1 Seconds
Processing contenttype (28) [Compressing File] : Processed 28 Rows in 0.006 Seconds
Processing cpsession (1) [Compressing File] : Processed 1 Rows in 0.004 Seconds
Processing cron (31) [Compressing File] : Processed 31 Rows in 0.006 Seconds
Processing cronlog (54518) [Compressing File] : Processed 54518 Rows in 3.846 Seconds
Processing customavatar (343) [Compressing File] : Processed 343 Rows in 0.912 Seconds
Processing customprofile (4) [Compressing File] : Processed 4 Rows in 0.013 Seconds
Processing customprofilepic (238) [Compressing File] : Processed 238 Rows in 0.27 Seconds
Processing datastore (40) [Compressing File] : Processed 40 Rows in 0.05 Seconds
Processing dbquery (No Row Data) [Compressing File]
Processing deletionlog (2054) [Compressing File] : Processed 2054 Rows in 0.114 Seconds
Processing discussion (4) [Compressing File] : Processed 4 Rows in 0.006 Seconds
Processing discussionread (No Row Data) [Compressing File]
Processing editlog (8432) [Compressing File] : Processed 8432 Rows in 0.34 Seconds
Processing event (1) [Compressing File] : Processed 1 Rows in 0.013 Seconds
Processing externalcache (No Row Data) [Compressing File]
Processing faq (80) [Compressing File] : Processed 80 Rows in 0.016 Seconds
Processing filedata (115) [Compressing File] : Processed 115 Rows in 1.041 Seconds
Processing forum (115) [Compressing File] : Processed 115 Rows in 0.021 Seconds
Processing forumpermission (36) [Compressing File] : Processed 36 Rows in 0.017 Seconds
Processing forumprefixset (1) [Compressing File] : Processed 1 Rows in 0.011 Seconds
Processing forumread (No Row Data) [Compressing File]
Processing forumrunner_push_data (No Row Data) [Compressing File]
Processing forumrunner_push_users (No Row Data) [Compressing File]
Processing gcbos (30) [Compressing File] : Processed 30 Rows in 0.032 Seconds
Processing glowhostspamomatic_log (39214) [Compressing File] : Processed 39214 Rows in 4.184 Seconds
Processing glowhostspamomatic_remotecache (307) [Compressing File] : Processed 307 Rows in 0.248 Seconds
Processing glowhostspamomatic_stats (1) [Compressing File] : Processed 1 Rows in 0.112 Seconds
Processing groupmessage (14) [Compressing File] : Processed 14 Rows in 0.006 Seconds
Processing groupmessage_hash (No Row Data) [Compressing File]
Processing groupread (No Row Data) [Compressing File]
Processing holiday (No Row Data) [Compressing File]
Processing humanverify (24) [Compressing File] : Processed 24 Rows in 0.053 Seconds
Processing hvanswer (5) [Compressing File] : Processed 5 Rows in 0.045 Seconds
Processing hvquestion (2) [Compressing File] : Processed 2 Rows in 0.102 Seconds
Processing icon (62) [Compressing File] : Processed 62 Rows in 0.134 Seconds
Processing imagecategory (3) [Compressing File] : Processed 3 Rows in 0.007 Seconds
Processing imagecategorypermission (No Row Data) [Compressing File]
Processing indexqueue (No Row Data) [Compressing File]
Processing infraction (8) [Compressing File] : Processed 8 Rows in 0.005 Seconds
Processing infractionban (No Row Data) [Compressing File]
Processing infractiongroup (No Row Data) [Compressing File]
Processing infractionlevel (4) [Compressing File] : Processed 4 Rows in 0.016 Seconds
Processing ipdata (1713) [Compressing File] : Processed 1713 Rows in 0.194 Seconds
Processing language (1) [Compressing File] : Processed 1 Rows in 0.165 Seconds
Processing mailqueue (No Row Data) [Compressing File]
Processing moderation (9327) [Compressing File] : Processed 9327 Rows in 0.332 Seconds
Processing moderator (19) [Compressing File] : Processed 19 Rows in 0.005 Seconds
Processing moderatorlog (56661) [Compressing File] : Processed 56661 Rows in 6.044 Seconds
Processing navigation (40) [Compressing File] : Processed 40 Rows in 0.041 Seconds
Processing notice (4) [Compressing File] : Processed 4 Rows in 0.029 Seconds
Processing noticecriteria (4) [Compressing File] : Processed 4 Rows in 0.059 Seconds
Processing noticedismissed (151) [Compressing File] : Processed 151 Rows in 0.008 Seconds
Processing package (3) [Compressing File] : Processed 3 Rows in 0.005 Seconds
Processing passwordhistory (6096) [Compressing File] : Processed 6096 Rows in 0.241 Seconds
Processing paymentapi (7) [Compressing File] : Processed 7 Rows in 0.006 Seconds
Processing paymentinfo (No Row Data) [Compressing File]
Processing paymenttransaction (No Row Data) [Compressing File]
Processing phrase (16538) [Compressing File] : Processed 16538 Rows in 1.121 Seconds
Processing phrasetype (78) [Compressing File] : Processed 78 Rows in 0.008 Seconds
Processing picturecomment (27) [Compressing File] : Processed 27 Rows in 0.017 Seconds
Processing picturecomment_hash (No Row Data) [Compressing File]
Processing picturelegacy (No Row Data) [Compressing File]
Processing plugin (204) [Compressing File] : Processed 204 Rows in 0.056 Seconds
Processing pm (2514) [Compressing File] : Processed 2514 Rows in 0.11 Seconds
Processing pmreceipt (12) [Compressing File] : Processed 12 Rows in 0.008 Seconds
Processing pmtext (2178) [Compressing File] : Processed 2178 Rows in 0.474 Seconds
Processing pmthrottle (No Row Data) [Compressing File]
Processing podcast (No Row Data) [Compressing File]
Processing podcastitem (No Row Data) [Compressing File]
Processing poll (204) [Compressing File] : Processed 204 Rows in 0.089 Seconds
Processing pollvote (1656) [Compressing File] : Processed 1656 Rows in 0.11 Seconds
Processing post (317671) [Compressing File] : Processed 317671 Rows in 33.858 Seconds
Processing postedithistory (26315) [Compressing File] : Processed 26315 Rows in 4.321 Seconds
Processing posthash (7) [Compressing File] : Processed 7 Rows in 0.026 Seconds
Processing postlog (3594) [Compressing File] : Processed 3594 Rows in 0.521 Seconds
Processing postparsed (11992) [Compressing File] : Processed 11992 Rows in 1.427 Seconds
Processing postrelease (1) [Compressing File] : Processed 1 Rows in 0.14 Seconds
Processing prefix (5) [Compressing File] : Processed 5 Rows in 0.074 Seconds
Processing prefixpermission (No Row Data) [Compressing File]
Processing prefixset (1) [Compressing File] : Processed 1 Rows in 0.089 Seconds
Processing product (15) [Compressing File] : Processed 15 Rows in 0.005 Seconds
Processing productcode (23) [Compressing File] : Processed 23 Rows in 0.02 Seconds
Processing productdependency (9) [Compressing File] : Processed 9 Rows in 0.006 Seconds
Processing profileblockprivacy (80) [Compressing File] : Processed 80 Rows in 0.007 Seconds
Processing profilefield (6) [Compressing File] : Processed 6 Rows in 0.005 Seconds
Processing profilefieldcategory (No Row Data) [Compressing File]
Processing profilevisitor (4631) [Compressing File] : Processed 4631 Rows in 0.12 Seconds
Processing ranks (7) [Compressing File] : Processed 7 Rows in 0.014 Seconds
Processing reminder (No Row Data) [Compressing File]
Processing reputation (1268) [Compressing File] : Processed 1268 Rows in 0.062 Seconds
Processing reputationlevel (15) [Compressing File] : Processed 15 Rows in 0.027 Seconds
Processing route (4) [Compressing File] : Processed 4 Rows in 0.028 Seconds
Processing rssfeed (40) [Compressing File] : Processed 40 Rows in 0.008 Seconds
Processing rsslog (48182) [Compressing File] : Processed 48182 Rows in 2.455 Seconds
Processing searchcore (391069) [Compressing File]

Keeps timing out here. Switched on block processing. Not sure what else to do.

[Mariner1]

Im using 4.1.2
Which ver is best to download and install pls

[cloferba]

Can I make 2 backups, one file for each table and other with the full database?

[davidg]

Processing access (1) [Compressing File] : Processed 1 Rows in 0.029 Seconds
Processing action (18) [Compressing File] : Processed 18 Rows in 0.022 Seconds
Processing activitystream (13761) [Compressing File] : Processed 13761 Rows in 0.766 Seconds
Processing activitystreamtype (16) [Compressing File] : Processed 16 Rows in 0.005 Seconds
Processing ad (3) [Compressing File] : Processed 3 Rows in 0.023 Seconds
Processing adcriteria (No Row Data) [Compressing File]
Processing adminhelp (1801) [Compressing File] : Processed 1801 Rows in 0.091 Seconds
Processing administrator (3) [Compressing File] : Processed 3 Rows in 0.005 Seconds
Processing adminlog (7557) [Compressing File] : Processed 7557 Rows in 0.828 Seconds
Processing adminmessage (3) [Compressing File] : Processed 3 Rows in 0.077 Seconds
Processing adminutil (7) [Compressing File] : Processed 7 Rows in 0.096 Seconds
Processing album (8) [Compressing File] : Processed 8 Rows in 0.016 Seconds
Processing albumupdate (No Row Data) [Compressing File]
Processing announcement (3) [Compressing File] : Processed 3 Rows in 0.104 Seconds
Processing announcementread (112) [Compressing File] : Processed 112 Rows in 0.007 Seconds
Processing apiclient (No Row Data) [Compressing File]
Processing apilog (No Row Data) [Compressing File]
Processing apipost (No Row Data) [Compressing File]
Processing attachment (116) [Compressing File] : Processed 116 Rows in 0.065 Seconds
Processing attachmentcategory (No Row Data) [Compressing File]
Processing attachmentcategoryuser (115) [Compressing File] : Processed 115 Rows in 0.039 Seconds
Processing attachmentpermission (No Row Data) [Compressing File]
Processing attachmenttype (11) [Compressing File] : Processed 11 Rows in 0.026 Seconds
Processing attachmentviews (No Row Data) [Compressing File]
Processing autosave (1031) [Compressing File] : Processed 1031 Rows in 0.142 Seconds
Processing avatar (No Row Data) [Compressing File]
Processing bbcode (No Row Data) [Compressing File]
Processing bbcode_video (8) [Compressing File] : Processed 8 Rows in 0.125 Seconds
Processing block (12) [Compressing File] : Processed 12 Rows in 0.027 Seconds
Processing blockconfig (39) [Compressing File] : Processed 39 Rows in 0.045 Seconds
Processing blocktype (6) [Compressing File] : Processed 6 Rows in 0.017 Seconds
Processing blog (No Row Data) [Compressing File]
Processing blog_attachmentlegacy (No Row Data) [Compressing File]
Processing blog_category (No Row Data) [Compressing File]
Processing blog_categorypermission (No Row Data) [Compressing File]
Processing blog_categoryuser (No Row Data) [Compressing File]
Processing blog_custom_block (No Row Data) [Compressing File]
Processing blog_custom_block_parsed (No Row Data) [Compressing File]
Processing blog_deletionlog (No Row Data) [Compressing File]
Processing blog_editlog (No Row Data) [Compressing File]
Processing blog_featured (No Row Data) [Compressing File]
Processing blog_groupmembership (No Row Data) [Compressing File]
Processing blog_grouppermission (No Row Data) [Compressing File]
Processing blog_hash (No Row Data) [Compressing File]
Processing blog_moderation (No Row Data) [Compressing File]
Processing blog_moderator (No Row Data) [Compressing File]
Processing blog_pinghistory (No Row Data) [Compressing File]
Processing blog_rate (No Row Data) [Compressing File]
Processing blog_read (No Row Data) [Compressing File]
Processing blog_relationship (No Row Data) [Compressing File]
Processing blog_search (No Row Data) [Compressing File]
Processing blog_searchresult (No Row Data) [Compressing File]
Processing blog_sitemapconf (No Row Data) [Compressing File]
Processing blog_subscribeentry (No Row Data) [Compressing File]
Processing blog_subscribeuser (No Row Data) [Compressing File]
Processing blog_summarystats (No Row Data) [Compressing File]
Processing blog_tachyentry (No Row Data) [Compressing File]
Processing blog_text (No Row Data) [Compressing File]
Processing blog_textparsed (No Row Data) [Compressing File]
Processing blog_trackback (No Row Data) [Compressing File]
Processing blog_trackbacklog (No Row Data) [Compressing File]
Processing blog_user (55) [Compressing File] : Processed 55 Rows in 0.017 Seconds
Processing blog_usercss (No Row Data) [Compressing File]
Processing blog_usercsscache (No Row Data) [Compressing File]
Processing blog_userread (No Row Data) [Compressing File]
Processing blog_userstats (No Row Data) [Compressing File]
Processing blog_views (No Row Data) [Compressing File]
Processing blog_visitor (No Row Data) [Compressing File]
Processing bookmarksite (4) [Compressing File] : Processed 4 Rows in 0.006 Seconds
Processing cache (649) [Compressing File] : Processed 649 Rows in 2.934 Seconds
Processing cacheevent (878) [Compressing File] : Processed 878 Rows in 0.031 Seconds
Processing calendar (1) [Compressing File] : Processed 1 Rows in 0.017 Seconds
Processing calendarcustomfield (No Row Data) [Compressing File]
Processing calendarmoderator (No Row Data) [Compressing File]
Processing calendarpermission (No Row Data) [Compressing File]
Processing cms_article (255) [Compressing File] : Processed 255 Rows in 0.131 Seconds
Processing cms_category (No Row Data) [Compressing File]
Processing cms_grid (2) [Compressing File] : Processed 2 Rows in 0.012 Seconds
Processing cms_layout (1) [Compressing File] : Processed 1 Rows in 0.004 Seconds
Processing cms_layoutwidget (11) [Compressing File] : Processed 11 Rows in 0.005 Seconds
Processing cms_navigation (214) [Compressing File] : Processed 214 Rows in 0.016 Seconds
Processing cms_node (214) [Compressing File] : Processed 214 Rows in 0.032 Seconds
Processing cms_nodecategory (No Row Data) [Compressing File]
Processing cms_nodeconfig (5) [Compressing File] : Processed 5 Rows in 0.036 Seconds
Processing cms_nodeinfo (214) [Compressing File] : Processed 214 Rows in 0.025 Seconds
Processing cms_permissions (18) [Compressing File] : Processed 18 Rows in 0.005 Seconds
Processing cms_rate (No Row Data) [Compressing File]
Processing cms_sectionorder (No Row Data) [Compressing File]
Processing cms_widget (14) [Compressing File] : Processed 14 Rows in 0.005 Seconds
Processing cms_widgetconfig (45) [Compressing File] : Processed 45 Rows in 0.006 Seconds
Processing cms_widgettype (21) [Compressing File] : Processed 21 Rows in 0.013 Seconds
Processing contentpriority (No Row Data) [Compressing File]
Processing contentread (1713) [Compressing File] : Processed 1713 Rows in 0.1 Seconds
Processing contenttype (28) [Compressing File] : Processed 28 Rows in 0.006 Seconds
Processing cpsession (1) [Compressing File] : Processed 1 Rows in 0.004 Seconds
Processing cron (31) [Compressing File] : Processed 31 Rows in 0.006 Seconds
Processing cronlog (54518) [Compressing File] : Processed 54518 Rows in 3.846 Seconds
Processing customavatar (343) [Compressing File] : Processed 343 Rows in 0.912 Seconds
Processing customprofile (4) [Compressing File] : Processed 4 Rows in 0.013 Seconds
Processing customprofilepic (238) [Compressing File] : Processed 238 Rows in 0.27 Seconds
Processing datastore (40) [Compressing File] : Processed 40 Rows in 0.05 Seconds
Processing dbquery (No Row Data) [Compressing File]
Processing deletionlog (2054) [Compressing File] : Processed 2054 Rows in 0.114 Seconds
Processing discussion (4) [Compressing File] : Processed 4 Rows in 0.006 Seconds
Processing discussionread (No Row Data) [Compressing File]
Processing editlog (8432) [Compressing File] : Processed 8432 Rows in 0.34 Seconds
Processing event (1) [Compressing File] : Processed 1 Rows in 0.013 Seconds
Processing externalcache (No Row Data) [Compressing File]
Processing faq (80) [Compressing File] : Processed 80 Rows in 0.016 Seconds
Processing filedata (115) [Compressing File] : Processed 115 Rows in 1.041 Seconds
Processing forum (115) [Compressing File] : Processed 115 Rows in 0.021 Seconds
Processing forumpermission (36) [Compressing File] : Processed 36 Rows in 0.017 Seconds
Processing forumprefixset (1) [Compressing File] : Processed 1 Rows in 0.011 Seconds
Processing forumread (No Row Data) [Compressing File]
Processing forumrunner_push_data (No Row Data) [Compressing File]
Processing forumrunner_push_users (No Row Data) [Compressing File]
Processing gcbos (30) [Compressing File] : Processed 30 Rows in 0.032 Seconds
Processing glowhostspamomatic_log (39214) [Compressing File] : Processed 39214 Rows in 4.184 Seconds
Processing glowhostspamomatic_remotecache (307) [Compressing File] : Processed 307 Rows in 0.248 Seconds
Processing glowhostspamomatic_stats (1) [Compressing File] : Processed 1 Rows in 0.112 Seconds
Processing groupmessage (14) [Compressing File] : Processed 14 Rows in 0.006 Seconds
Processing groupmessage_hash (No Row Data) [Compressing File]
Processing groupread (No Row Data) [Compressing File]
Processing holiday (No Row Data) [Compressing File]
Processing humanverify (24) [Compressing File] : Processed 24 Rows in 0.053 Seconds
Processing hvanswer (5) [Compressing File] : Processed 5 Rows in 0.045 Seconds
Processing hvquestion (2) [Compressing File] : Processed 2 Rows in 0.102 Seconds
Processing icon (62) [Compressing File] : Processed 62 Rows in 0.134 Seconds
Processing imagecategory (3) [Compressing File] : Processed 3 Rows in 0.007 Seconds
Processing imagecategorypermission (No Row Data) [Compressing File]
Processing indexqueue (No Row Data) [Compressing File]
Processing infraction (8) [Compressing File] : Processed 8 Rows in 0.005 Seconds
Processing infractionban (No Row Data) [Compressing File]
Processing infractiongroup (No Row Data) [Compressing File]
Processing infractionlevel (4) [Compressing File] : Processed 4 Rows in 0.016 Seconds
Processing ipdata (1713) [Compressing File] : Processed 1713 Rows in 0.194 Seconds
Processing language (1) [Compressing File] : Processed 1 Rows in 0.165 Seconds
Processing mailqueue (No Row Data) [Compressing File]
Processing moderation (9327) [Compressing File] : Processed 9327 Rows in 0.332 Seconds
Processing moderator (19) [Compressing File] : Processed 19 Rows in 0.005 Seconds
Processing moderatorlog (56661) [Compressing File] : Processed 56661 Rows in 6.044 Seconds
Processing navigation (40) [Compressing File] : Processed 40 Rows in 0.041 Seconds
Processing notice (4) [Compressing File] : Processed 4 Rows in 0.029 Seconds
Processing noticecriteria (4) [Compressing File] : Processed 4 Rows in 0.059 Seconds
Processing noticedismissed (151) [Compressing File] : Processed 151 Rows in 0.008 Seconds
Processing package (3) [Compressing File] : Processed 3 Rows in 0.005 Seconds
Processing passwordhistory (6096) [Compressing File] : Processed 6096 Rows in 0.241 Seconds
Processing paymentapi (7) [Compressing File] : Processed 7 Rows in 0.006 Seconds
Processing paymentinfo (No Row Data) [Compressing File]
Processing paymenttransaction (No Row Data) [Compressing File]
Processing phrase (16538) [Compressing File] : Processed 16538 Rows in 1.121 Seconds
Processing phrasetype (78) [Compressing File] : Processed 78 Rows in 0.008 Seconds
Processing picturecomment (27) [Compressing File] : Processed 27 Rows in 0.017 Seconds
Processing picturecomment_hash (No Row Data) [Compressing File]
Processing picturelegacy (No Row Data) [Compressing File]
Processing plugin (204) [Compressing File] : Processed 204 Rows in 0.056 Seconds
Processing pm (2514) [Compressing File] : Processed 2514 Rows in 0.11 Seconds
Processing pmreceipt (12) [Compressing File] : Processed 12 Rows in 0.008 Seconds
Processing pmtext (2178) [Compressing File] : Processed 2178 Rows in 0.474 Seconds
Processing pmthrottle (No Row Data) [Compressing File]
Processing podcast (No Row Data) [Compressing File]
Processing podcastitem (No Row Data) [Compressing File]
Processing poll (204) [Compressing File] : Processed 204 Rows in 0.089 Seconds
Processing pollvote (1656) [Compressing File] : Processed 1656 Rows in 0.11 Seconds
Processing post (317671) [Compressing File] : Processed 317671 Rows in 33.858 Seconds
Processing postedithistory (26315) [Compressing File] : Processed 26315 Rows in 4.321 Seconds
Processing posthash (7) [Compressing File] : Processed 7 Rows in 0.026 Seconds
Processing postlog (3594) [Compressing File] : Processed 3594 Rows in 0.521 Seconds
Processing postparsed (11992) [Compressing File] : Processed 11992 Rows in 1.427 Seconds
Processing postrelease (1) [Compressing File] : Processed 1 Rows in 0.14 Seconds
Processing prefix (5) [Compressing File] : Processed 5 Rows in 0.074 Seconds
Processing prefixpermission (No Row Data) [Compressing File]
Processing prefixset (1) [Compressing File] : Processed 1 Rows in 0.089 Seconds
Processing product (15) [Compressing File] : Processed 15 Rows in 0.005 Seconds
Processing productcode (23) [Compressing File] : Processed 23 Rows in 0.02 Seconds
Processing productdependency (9) [Compressing File] : Processed 9 Rows in 0.006 Seconds
Processing profileblockprivacy (80) [Compressing File] : Processed 80 Rows in 0.007 Seconds
Processing profilefield (6) [Compressing File] : Processed 6 Rows in 0.005 Seconds
Processing profilefieldcategory (No Row Data) [Compressing File]
Processing profilevisitor (4631) [Compressing File] : Processed 4631 Rows in 0.12 Seconds
Processing ranks (7) [Compressing File] : Processed 7 Rows in 0.014 Seconds
Processing reminder (No Row Data) [Compressing File]
Processing reputation (1268) [Compressing File] : Processed 1268 Rows in 0.062 Seconds
Processing reputationlevel (15) [Compressing File] : Processed 15 Rows in 0.027 Seconds
Processing route (4) [Compressing File] : Processed 4 Rows in 0.028 Seconds
Processing rssfeed (40) [Compressing File] : Processed 40 Rows in 0.008 Seconds
Processing rsslog (48182) [Compressing File] : Processed 48182 Rows in 2.455 Seconds
Processing searchcore (391069) [Compressing File]

Keeps timing out here. Switched on block processing. Not sure what else to do.


maybe change your hosting?

[Paul M]

Keeps timing out here. Switched on block processing. Not sure what else to do.
Change your script timeout settings (assuming you can).

[cloferba]

Can I make 2 backups, one file for each table and other with the full database?

Hello Paul, could you please answer this?

I always prefer to backup each table separately, but in some cases a lot of tables are compromised and I can?t restore each table. The last week I had to do that and I spent 30 minutes restoring each table....

[Paul M]

You have the choice of either.

[eva2000]

Hey Paul, probably not that hard to add pigz as alternative to gzip compression ? pigz parallel version of gzip up to 33x times faster than gzip http://vbtechsupport.com/2094/ :D

[Paul M]

How many servers are likely to have that installed ? Ive never heard of it until today.

[JMEWLS`]

Change your script timeout settings (assuming you can).
I can't anymore suggestions.

[eva2000]

How many servers are likely to have that installed ? Ive never heard of it until today.

hard to say right now, but whm/cpanel are looking into replacing all there backup functions using gzip and switching to pigz http://forums.cpanel.net/f145/faster-cpanel-backup-replacing-gzip-pigz-case-55535-a-242831.html, so imagine every cpanel/whm based server online with pigz support in future. I'd say quite a few will have pigz eventually :D

[charlesr]

I hadn't heard of it, but it's on the RHL/Centos Repoforge repository, so anyone that has server access should be able to install it safely.
http://pkgs.org/centos-5-rhel-5/repoforge-x86_64/pigz-2.1.6-1.el5.rf.x86_64.rpm.html#download

[eva2000]

Yeah EPEL repo has pigz as well

yum -q list pigz
Installed Packages
pigz.x86_64 2.2.4-1.el6 @epel

[PattiOz]

Dumb n00b question, but where do I find the option to run?

[Kirk Fitzgerald]

Dumb n00b question, but where do I find the option to run?

Go to:
AdminCP/Scheduled Tasks/Scheduled Task Manager

Scroll down to:
Automatic Database Backup for vBulletin

Click Run Now on the right.

[PattiOz]

Thank you! Done and dusted :)

[Paul M]

hard to say right now, but whm/cpanel are looking into replacing all there backup functions using gzip and switching to pigz http://forums.cpanel.net/f145/faster-cpanel-backup-replacing-gzip-pigz-case-55535-a-242831.html, so imagine every cpanel/whm based server online with pigz support in future. I'd say quite a few will have pigz eventually :D
Prod me again when cpanel start using it.

In the meantime, I presume you can simply edit the command in the code from gzip to pigz if so desired. :)

[anymvs]

Hey, Is any-one used this mod with 4.2PL2 version?? Also as I notice a lot of members used cpanel and apache instead of nginx and ispconfig. Can this affect the whole mod as a part of vbulletin ?? Thank you!! :)

[Paul M]

It works just fine in 4.2.

[cloferba]

Paul, I´ll send you a PM due an issue with your plugin and the use of CPU resources of my server

[nesttle]

This plugin broke my database, I'm not sure but my db got some tables deleted 1 day after I installed this plugin.

[Paul M]

No it didnt.

Its not possible for this to break anything, since it doesnt change anything. It certainly cannot delete tables.You need to look elsewhere.

[doctorsexy]

Thanks...works smashin...

[Naijasite]

Processed Database in 22.642 seconds

[Compressing Combined File] : Processed File Compression in 0 seconds

Backup Completed Successfully
Done

But No files in the bank up folder
Backups Path ./backups

The back up folder in my ftp is backups

But the Backup folder is empty...what the solution

[max1982]

Processed Database in 22.642 seconds

[Compressing Combined File] : Processed File Compression in 0 seconds

Backup Completed Successfully
Done

But No files in the bank up folder
Backups Path ./backups

The back up folder in my ftp is backups

But the Backup folder is empty...what the solution

Same problem here any fix for this

[Naijasite]

Same problem here any fix for this

I have fix my and it's ok now

[s.stuart]

Brilliant thank you kindly

[BMR]

When Updating this do I need to reupload all files or just overwrite the XML?

[shellys]

I installed this but i do not see any option where i can set that what time of day the backup has to be taken and when (what day it has to be taken) ? Can any body help

Hosts Observer (http://www.hostsobserver.com)

[nacaruncr]

Go to Admincp - Scheduled Tasks - Scheduled Task Manager - Automatic Database Backup for vBulletin

And here say you when and what time it does the backup :)
Regards :)

[whitewolf68]

Not sure what this means but I keep getting this error:

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 7249956 bytes)

I am on shared hosting with Godaddy on a windows box.

[dorans]

:D :up:
cca 900MB
Thanx :)

[Mauro79]

the backup does me fine, but when I put everything in the localhost - attachaments and avatars are not.
may be corrupted?
What configuration of hack me?
thanks

[BirdOPrey5]

Mauro-

It is likely you have attachments and avatars set to be saved in the file system- this mod only backs up the database. You need to worry about coping files separately.

Admin CP -> Attachments -> Attachment Storage Type
and
Admin CP -> Avatars -> User Picture Storage Type

These places will tell you where your attachments and avatars are stored.

[charlesr]

the backup does me fine, but when I put everything in the localhost - attachaments and avatars are not.
may be corrupted?
What configuration of hack me?
thanks

Assuming you have also put the filesystem into localhost..... Don't panic. When restoring the forum locally you need to specify the local location for the attachments etc. It's a hidden menu.

To get things working:
Update local path in /includes/config.php
Update email options settings in vbulletin admin panel to reference new url (along with all the other settings)
I had my attachments stored in the filesystem and in vbulletin, in a location specified as a crazy full server path which can only be changed by switching to debug mode: $config['Misc']['debug'] = 1; <<by adding that to the 2nd line of the config.php). Then a hidden item in the admin panel's option menu appears for "untouchables" (2nd on the list!) where the path can be changed (remembering to remove the debug mode line afterwards from config.php).

[tonym]

The mod will always instruct the server to gzip the file (if you have the option set). If its not doing it sometimes then thats a server side issue.

Any idea what we should tell our host about this error? I have this mod installed on 2 forums and a test forum.

all stopped working on aug 30th 2012.....my host dont seem to think its them..all files on my side have not changed and even reinstalled the mod...still no gzip.


Host just emailed back and said everything fine on the server

The gzip is installed on the server and working fine. Please have a look:

======================================
root@rs2 [~]# which gzip
/bin/gzip

root@rs2 [~]# gzip -V
gzip 1.3.5
nothing has changed on my end.......time to find a new host I guess

[Mauro79]

I have everything stored in the database.
mm do not quite understand your answers. My English is bad.

http://i.imgur.com/Bmhkf.png
http://i.imgur.com/aFyTO.png
http://i.imgur.com/s5ge5.png

probe twice with two backs.
Thanks for your answers.

[BirdOPrey5]

I see you've made a separate thread- https://vborg.vbsupport.ru/showthread.php?p=2362366#post2362366

Good idea because the error does not seem to be related to this mod.

[tonym]

Unfortunately, I cannot help you with server issues. The mod will issue the command to gzip them, if the server fails to do this then you need to speak to your host to investigate why. An easy test would be to connect via SSH, navigate to the folder and type gzip <filename>.

on 4.2

I can ssh and gzip the files
but it still dont work from the MOD, gzip in this MOD has worked for 2 months since I installed it. It just stopped working a few days ago....

thanks for any help

I have installed at another host also...same problem

[Superorb]

I have found a script that incorporates a feature that will delete backups that are X days old. Is there a way to incorporate it into this Mod? Maybe in the next release?

http://www.wjunction.com/48-technical-security-tutorials/118-automatic-mysql-backup-script.html

[Trumpetrhapsody]

I just tossed this code in there to keep only the latest 5 backups:

// Delete Old Backups
function deleteOLD($directory)
{
$dirs = array($directory);
$files = array();
$files = array_merge($files, scandir($directory, false));
unset($files[0]);
unset($files[1]);
sort($files);

// Loop over all but the 5 newest files and delete them
// Only need the array keys (filenames) since we don't care about timestamps now as the array will be in order
if (count($files) > 5)
{
for ($i = 0; $i < (count($files) - 5); $i++)
{
// You'll probably want to check the return value of this too
$file = $this->DUMP_PATH.$files[$i];
$this->removeFile($file);
echo "<i>[Deleting Old Backup - $file]</i><br />"; vbflush();
}
} else { echo "<i>[No Old Backups to Delete.]</i><br /><br />"; vbflush(); }


}

You can call it whenever you want, I put it after the "Repair and Optimize" section, before the "Start Initial Dump" section.

[Superorb]

I just tossed this code in there to keep only the latest 5 backups:



Does this work for you? I have 6 files in my backupDB directory and after running the script I still have 6 files. The backups weren't created every day though, they were a few days apart for some of them. I placed the code in the same spot in my mysqlbackup.php file.

[Trumpetrhapsody]

Sorry, I meant to say 6. If you have no more than 6 files you won't see any get removed. You can adjust the number it keeps around.

[Superorb]

Sorry, I meant to say 6. If you have no more than 6 files you won't see any get removed. You can adjust the number it keeps around.
I uploaded a few dummy files to my testvb and it still doesn't delete them. The dir is 755 so deleting should be fine. I have 7 files in that dir and it's set to keep 5 files.

[ZombieAndy]

Im probably being really dumb here paul but everytime i try to run this i just get:

Automatic Database Backup for vBulletin
Backup Error : Could not write to destination file ( .../backups/2012-09-17/Forum-2012-09-17-Aaggregate_temp_1347351000.sql )

And ive tried different varients of the address, both full and relative.. have made sure the directory permissions are set to 777.. what else can i do?

[Superorb]

Im probably being really dumb here paul but everytime i try to run this i just get:

Automatic Database Backup for vBulletin
Backup Error : Could not write to destination file ( .../backups/2012-09-17/Forum-2012-09-17-Aaggregate_temp_1347351000.sql )

And ive tried different varients of the address, both full and relative.. have made sure the directory permissions are set to 777.. what else can i do?
Should it be 3 dots or two? [.../]?

[ZombieAndy]

If your trying to create relative path it should actually be 1 stop (./backups/)

What you see is my dodgy editing for the post.

Anyway, it dosnt work with either a relative or full path in there.

[Paul M]

Should it be 3 dots or two? [.../]?
Two.

[Superorb]

Two.
I know ;)

[betterthanyours]

Is there anything similar that will backup and then also upload to remote site at all?

[Delfi_r]

I just tossed this code in there to keep only the latest 5 backups:

// Delete Old Backups
....
}

You can call it whenever you want, I put it after the "Repair and Optimize" section, before the "Start Initial Dump" section.

Wich file I should modify?

[Superorb]

Wich file I should modify?
The mysqlbackup.php file, but this code did not work for me when I added it to the test or live sites.

[charlesr]

Is there anything similar that will backup and then also upload to remote site at all?

If you have server access to two servers you could set up an rsync with ssh on a cronjob to sync the backups created by this mod to a remote server. Probably.

[betterthanyours]

I do have shell access to both servers. Is there a tutorial on this anywhere?

[charlesr]

I haven't tried it myself. I googled and found this which should probably work: http://troy.jdmz.net/rsync/index.html and could include your forum filesystem as well as the db backup. Please report back on your progress :)

[Delfi_r]

The mysqlbackup.php file, but this code did not work for me when I added it to the test or live sites.

thanks, I'll try and report

[Cicada]

doesn't seem to be backing up _all_ of the tables...

[Superorb]

doesn't seem to be backing up _all_ of the tables...
Which tables is it missing? My backups seem to be smaller than the DB size, but when restored to a test installation all the stats and data usage reported in the Vb admin pages is identical.

[steeler7]

Paul,

Mod was working like a charm and then we changed accounts (stayed with the same host, just moved to a different server) and ever since, I'm not getting any Backups made. It's not version or vbulletin version based either since I recent;y upgraded to 4.2.0 and the newest version of this Mod and nothing.

Could there be something on the host side (using VPS) preventing this from working?

[Superorb]

Paul,

Mod was working like a charm and then we changed accounts (stayed with the same host, just moved to a different server) and ever since, I'm not getting any Backups made. It's not version or vbulletin version based either since I recent;y upgraded to 4.2.0 and the newest version of this Mod and nothing.

Could there be something on the host side (using VPS) preventing this from working?
Did the directories or permissions change? When you manually run the script does it complete successfully?

[rgf207]

i created the backups folder in the root of my vbulletin install and changed permissions to 777 but I still get this error


Backup Error : Could not write to destination file ( ../../backups/2012-09-27/Forum-2012-09-27-Vb_access.sql )

[Paul M]

../../ will take you a couple of levels up the folder tree - on most steups, that will be outside of the sites html folder completely (which is where backups should be).

[Delfi_r]

Last week we had a problem, something was deleted. After installing the last backup on a test server we extracted a copy of the deleted content and all went fine. One of the most useful plugins I have installed.

[RedTurtle]

I do have shell access to both servers. Is there a tutorial on this anywhere?

I use a cronjob on my destination server to login to my site server daily and sync up the backup folder.

Here's the command on the destination server:

rsync -vrltuzDP --rsh='ssh -p2222' admin@mydomain.com:~/backup/ /volume1/Backups/Database/

One thing you do have to do is set up a SSH authentication (I forget the exact term for this) but what it will let you do is login from your destination server into your site server without a password and still encrypt the data transfer.

[kemana]

Hey Paul This mod is really Great,,

i already mark installed :D

But there's one thing that really confuse me,,
i already set my timing at "Scheduled Task Manager" but it's not working.
but when i used "Run Now" it's worked.
i'm using Vbulletin Version 4.1.3

thx before

[Superorb]

Hey Paul This mod is really Great,,

i already mark installed :D

But there's one thing that really confuse me,,
i already set my timing at "Scheduled Task Manager" but it's not working.
but when i used "Run Now" it's worked.
i'm using Vbulletin Version 4.1.3

thx before
Your site needs to be busy enough to run the cron jobs.

[kemana]

Your site needs to be busy enough to run the cron jobs.

Thx for the respond Superorb
But could u be more spesific,,i still don't understand,,

Thx A lot :)

[Superorb]

Thx for the respond Superorb
But could u be more spesific,,i still don't understand,,

Thx A lot :)
Scheduled tasks are called to run when the footer is loaded in a browser. If no one visits the site the footer is never loaded, hence the scheduled tasks are never run. There needs to be activity on the site to run the cron tasks. You can just browse your site for a minute or so and everything should start to catch up.

[kemana]

Scheduled tasks are called to run when the footer is loaded in a browser. If no one visits the site the footer is never loaded, hence the scheduled tasks are never run. There needs to be activity on the site to run the cron tasks. You can just browse your site for a minute or so and everything should start to catch up.

awesome ,, i already try that nad it was working :) Thx Superorb

[JMEWLS`]

Change your script timeout settings (assuming you can).
How exactly would I do this? Sorry to be a pain.

[mattballew]

Can anyone help with an issue... I get this error:

Backup Error : Could not write to destination file ( /backups/Forum-11-01-2012-Full-Backup.sql )

I have set the folder /backups/ to permission 7777 but still the same error. What have i done wrong?

[Gary_Oak]

Everytime I try to perform the backup through 'Run Now' I get this error message...

Warning: include_once([path]//includes/cronbackup.php) [function.include-once]: failed to open stream: No such file or directory in [path]/admincp/cronadmin.php on line 116

Warning: include_once() [function.include]: Failed opening '[path]//includes/cronbackup.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/admincp/cronadmin.php on line 116
Done

Any ideas how I can fix this? Also, does 'Done' mean that it actually worked, even though it says all that as well, or not? Finally, once I perform the backup, how do I access the backup so I can use it to restore either my main site or a test site?

Thanks in advance!

[Paul M]

That means you are missing one or more of the files used by the mod.

Either you didnt upload them, they failed to upload, or you uploaded them to the wrong place.

[Gary_Oak]

Oh okay. Well I just downloaded FileZilla and uploaded the files to the public_html directory, tried it, and it didn't work. So I tried the public_ftp directory and that didn't work either. Do you know where the files belong? Because my host has not said I need to upload any files to a specific folder or section, and it doesn't say it in the text document when you download the mod, so where exactly should they be uploaded to? I know they are being uploaded because I see them right there, so it is in the wrong place then I would assume.

[Paul M]

When you unzip it, you will see an includes folder, the files (and folders) inside this go into your existing forum includes folder.

[Gary_Oak]

I did that. It still showed me the same error message. I uploaded all contents into the includes folder of my forum, tested it in my ACP, and still got the same error message. It shows it as uploaded, so it should be working, but it isn't.

[Gary_Oak]

Sooooo... what should I do now to get this working?

[Paul M]

Give someone access to your server and ask them to check what you have done.
The error means the file(s) cannot be found, which indicates they are not where they should be. There isnt anymore I can tell you.

[zapiy]

Automatic Database Backup for vBulletin
Backup Error : Could not write to destination file ( ../../backups/2012-01-08/Forum-2012-01-08-Access.sql )

My site is /httpdocs/backups

so i have tried every way

please advise.

folder is 777

[bzcomputers]

The directory path appears incorrect.

It also appears you maybe trying to backup to your root directory, which could lead to a security issue for your backups (easy access in many cases).

What is the directory of your forum itself? www.xxxx.com/forums ?

You should be backing up the database outside of your root directory.

[djbaxter]

I have this running on five vB 4.2.0 PL3 forums now, all with "Set to yes to combine all tables into one backup file = Yes".

Two issues:

1. The filesize changes up and down from day to day with no discernible logic. What would cause this?

2. On the forum with the largest database, the process often fails to complete.