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]

Nope, both will have the date.

[Artes_Marciales]

OK, thanks Paul.
then if I have to restore the data base I have to rename all of the files? : (

Best Regards!!

[Paul M]

Why do you have to rename the files, there is no reason to have to do that.

[abdelghani68]

Thanks for this hack.

Can you help me please, i have some probleme with some emphasis.

how to resolve the problem

thanks

[Artes_Marciales]

Originally Posted by Paul M

Why do you have to rename the files, there is no reason to have to do that.

Ok thanks.
then like I must restore a data base?

I thought that files should have had the same names than originals

Best Regards!! : )

[fedorama]

I'm pretty green and would love if someone can hold my hand here -

OK, I downloaded it, and read the instructions, here -

Installation.

1. Copy all files in the 'includes' folder to the server.

2. Set your choice of options in the mysqlbackupconfig.php file.

3. Upload the product XML via the Product Manager.

4. Alter the timing of the cron job to suit.

OK, so I understand 1, 3, and 4, but how do I set choices in the mysqlbackupconfig.php file , can this be done AFTER from the acp, or the actual file needs to be edited ( I'm no programmer or coder, and have no clue what to edit)

The most important thing - WHERE should the back-up go - I read here it's unsafe to put it in the public_html, and should be in the root.

Would someone kindly assist me (pm or here, or in the forums) to go thru it step by step - my database is not large now, about 30 MB, but I need to back-up now and weekly.

[Paul M]

For option 2 you edit the actual file.

[captainron19]

Excellent Mod - just installed - couple of quick questions...

Is it recommended I turn off boards to do a backup? I just did a "Run Now" in the scheduled Task Manager and it backed up my entire forum in about 30 seconds at 40MB (so it is not that large)

Will it overwrite the previous backup or will I have to routinely ftp in and delete the old files?

Currently I am saving backups in public_html/backups with path being ../backups/

I understand it is not wise to have in acceptible location where accessible by public so where should I save to and what would the path to that section be?

I was going to protect the directory with ausername and password but I am assuming that if I do that it will not only prevent unwanted people from accessing but it will also prevent the mod from saving the backup file to that location.... true?

any help would be appreciated

[Paul M]

Where you save it will be server dependant, but outside your public folder would be best.

If you mean an htaccess user/password, then that should not affect this mods ability to write to the folder.

Previous backups will not be overwritten unless they are named the same.

[captainron19]

Originally Posted by Paul M

If you mean an htaccess user/password, then that should not affect this mods ability to write to the folder.

not sure about htaccess user/password - whenever I want to protect a directory I just go into cpanel and click on "protect files and folders" and then choose a folder to protect and designate a username and password