Administrative and Maintenance Tools - vB Database Backup

This modification is no longer available or supported.

Note: Because I did not write the original version, but rather have modified & adapted it, support of this modification may be limited

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 and now for vb3.7.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. 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.

Notes:
* I will not add anything new to this, or spend vast amounts of time supporting it.
* This is a Lite version to allow people to use the basic backup functionality on 3.7.


History:

v3.7.001 : First version for vB 3.7.

[Paul M]

Originally Posted by tom212

Paul,

If this is installed and running perfectly in 3.7.4, would you expect any issues when upgrading to 3.8? I realize you have a 3.8 version but I hate to go through the upgrade/config hassles if this version should suffice.

Any ideas?

Thanks,

Tom

I believe it should work fine after you upgrade.

[MTGDarkness]

I installed this... For some reason, I can't get the directory right. I have no idea about relative directories... I stuck a folder named "Backups" in the Includes folder, CHMODded it to 777, and then pointed it to any number of locations... ../backups/, /public_html/forums/includes/backups/, ... Not sure what to do at this point...

[kevcj]

Originally Posted by MTGDarkness

I installed this... For some reason, I can't get the directory right. I have no idea about relative directories... I stuck a folder named "Backups" in the Includes folder, CHMODded it to 777, and then pointed it to any number of locations... ../backups/, /public_html/forums/includes/backups/, ... Not sure what to do at this point...

Well, to start with you want your backup folder ABOVE the html root. The location you have it at now - "/public_html/forums/includes/backups/" - anyone could access that folder and download your database. And then guess what, all of your data no belongs to someone else.

The backup folder should be somewhere like - account_name/backups/public_html/forums

Get the path fixed before you get the script running.

[Lionel]

Hi Paul,

I have been using this great script for a while now. I recently added a function in the cron to delete all backups that are 3 days or older when it performs a backup, because I had to constantly manually delete old files.

I placed it right after

echo $mysqlBackup->STATUS;

What I'd like to know is how to determine a successful status from the script. In case of failure I don't want to run the delete. Something like
if($status == 'success')
{
// my stuff here
}

Thanks

[Paul M]

It should contain 'The Backup was completed successfully.'

You can change that (about line 27) in the mysqlbackup.php file if you wish.

[MTGDarkness]

I just can't get the directory right... I set up a folder in the server's root directory, and tried setting the dump path to just /(foldername)/. Then I tried (server username)/(foldername)/... How can I set this right?

[Paul M]

Use a relative path, like ../../foldername

[MTGDarkness]

And what would the relative path be when the folder is in the server root? I honestly don't know how to use relative paths.

[Paul M]

No idea, that depends on your server setup. Google is your friend, lookup reletive paths.

[Markos]

hi Paul is there away so i can make this run twice a day like say 10am and 10pm