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.

[maxicep]

this support large databases tables ? because i tried some auto backup scripts but they didnt complete backup the database. My tables are so long .

SSH rlz

p.s: my database about 1gigabyte .

[Jase2]

If I remember rightly - it does.

(Note: If you have an extremely large database, make sure to use the mysqldump binary option that is selected by default.)

Regards Jason

[abroad]

Get this error:
An error occured during the Backup : Could not open Destination SQL file for writing.

and tried it with

../backups/

and with

/home/xxx/yyy/backups/ (provided by filepath.php)

always the same error message

[Paul M]

Originally Posted by Jase2

I edit "Automatic Database Backup for vB 3.7" under "scheduled Task Manger". Day of the week is set to *

Day of the month: *

Then do I set hour to 4 and minute to 0, so that it does it 4am UK time?

Regards Jason

Yes.

[Jase2]

Hi Paul,

Is it a good idea to have it in a web accessible area? I have mine at public_html/backups ... and I don't think this is a good idea, as anyone can then download your backups .sql.

Where is it best to have it, and what path would it have?

Regards Jason

[abroad]

any idea why I get this:

An error occured during the Backup : Could not open Destination SQL file for writing.

and tried it with

../backups/

and with

/home/xxx/yyy/backups/ (provided by filepath.php)

always the same error message

[Paul M]

Originally Posted by Jase2

Is it a good idea to have it in a web accessible area? I have mine at public_html/backups ... and I don't think this is a good idea, as anyone can then download your backups .sql.

No, its not a very good idea and should be avoided if possible.

If you cant then at the very least you should use an htaccess file to stop people accessing the folder via the web.

[Jase2]

Yes, I've changed it too: /home/user/backups ... all looking good.

Once again, thanks for this great hack

Regards Jason

[avsunforum]

thanks

[gertoo]

60MB database it didnt backup even 50% of the table. Yes i Did try with the "mysqldump binary option"