Administrative and Maintenance Tools - vB Database Backup (Lite)

As of 24 Nov 2017 this modification has been withdrawn.

Note: I did not write the original version, but rather have modified & adapted it.

When vb 3.5 first came out I was using this backup system on my vb 3.0 - and having nothing better to use - I converted it to work on vb 3.5 (here) and since then I have cut it down and adapted it, first for vb 3.6, 3.7 and now for vb3.8.

The original version was by Trigunflame and the rights to the code were bought by Zoints (David Chapman) in January 2007. Later in 2007 David gave me permission to release my adaptation.

I have stripped out much of the extra stuff that I do not use (or indeed, could not get to work). This is a simple (Lite) version that does a php based dump of your database either as one file, or one file per table.

As of version 3.8.002, most of the options have moved to the ACP in vBulletin Options >> vBulletin Automatic Backup

Notes:
* I will not be adding anything new to this modification.
* This is a Lite version to allow people to use the basic backup functionality on 3.8.


History:

v3.8.001 : First version for vB 3.8.
v3.8.002 : Moved most of options to ACP.
v3.8.003 : Moved more options to ACP.
v3.8.004 : Gzip option backported from vb4 version.
v3.8.005 : Split option backported from vb4 version, close option removed.
v3.8.006 : Fix php 5.3 deprecated warning.

[Vinyljunky]

Originally Posted by FCDobbs

But could you advise as to how I might be able to set up a CRON job to delete folders which are more than 7 days old ?

Thanks

I'd like to be able to do that too

[Paul M]

You could just change the time format in the config to use the day of the week, this is what I do so I only ever have 7 folders (Monday to Sunday).

 $backup['DATE'] = 'l'; // Lowercase 'L'

[FCDobbs]

Paul, never mind my earlier request.

I have successfully built a VB script (Windows Scripting Host) which:

1. Invokes Windows FTP command to connect to my site host server and list out all the folder names for all the backups.
2. Examines these folder names (each is actually the date the folder was created),
does a numerical check against todays date, and stores the information for all folders which are more than 7 days old, and stores the information for all folders which are 7 days old or less.
3. Loops through all the folder names which are more than 7 days old, and creates/runs a Windows FTP job to delete each folder.
4. Loops through all the folder names which are 7 or less days old (I want to copy them to my computer for a second backup), and copies the file in each one to my computer.
Actually, it first checks to see if the folder already exists on my computer.
If so, it ignores copying that file; if not, it creates that folder, then copies the file over.
This is also done via a Windows FTP job.

Now I merely schedule this task to run every day on my computer, and presto... it all runs unattended for me, and does exactly what I want.

Perfect.

By the way.... if anyone would like a copy of my script, just PM me and I'll be happy to send it to you.
Of course, it will be "bare bones"... you will have to insert/modify the code to accommodate your FTP ID and password, and your server backups folder structure, and your PC folder structure. But is is significantly commented so you should be able to do this quite easily.

Cheers,

[Phaedrus]

Originally Posted by Yonatan

Oops :S
by mistake i wirte "backup" instead of "backups".
but, in backups folder. it's make folders(like: 2009-Jan-28 and etc), but not sql files.

Check inside the folders.

[Vaupell]

well installed, did force cron to run a backup worked like a charm
downloaded backup aswell.

this might be a FAQ- if so, could u add it to your post for mySQL newbs like me.
How do i restore the backup if i needed to, i dont right now, but would be nice to
know when i get to the point where i need to restore

I got phpmyadmin acces to mySQL server at the webhost.

no rush..

PS: Installed

[FCDobbs]

Paul, thanks for the hint.

At least now, I will only have 7 days stored.

And I won't have to use the script I built.

[JonUrban]

Thanks Paul M! I just installed and ran a 'run now" and it worked like a champ! Very nice! Marked as installed and nominated.

[Yonatan]

Originally Posted by Phaedrus

Check inside the folders.

I was check.
the folders is empty

[BlackJacket]

where do i create the "backups" folder? Which directory?

[Yonatan]

Originally Posted by NittoMOD

where do i create the "backups" folder? Which directory?

In public_html


- - - - - - - - -

Paul.
Pleash help me, in my problem.
Thanks,
yonatan