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]

You mysql timeout must be very low - I would say the database connection is timing out checking the previous table, which I would guess is the post table.

[Sakai Ray]

This is great clicks install.

[PGAmerica]

This mod rocks, I am having 2 problems.

1) Whenever I modify my "mysqlbackupconfig.php" file to exclude tables from the backup, I get an error that says

Parse error:  parse error, unexpected ',', expecting ']' in mysqlbackupconfig.php on line 29

Line 29 is where I put in my exclusions. The currently say

  $backup['TYPE'] = 2; // 1 = Only Specified Tables, 2 = All except Specified Tables
  $backup['quiz_questions','quiz_answers']    = array(); // Table List - e.g. array('table1', 'table2')

They are large and never change so I do not want them backup up. There is nothing wrong with the way they are entered into the array. What is wrong here?

2) The scheduled task area does not have an option to make a task run every 3rd day. How do I do this? This is not a busy site, I have no need for a daily backup.

Ideas?

[Paul M]

1. The example clearly shows you put the tables in the array, you have not done this.

$backup['TABLES'] = array('quiz_questions','quiz_answers');

2. You cannot do this with the vb cron system.

[PGAmerica]

Originally Posted by Paul M

1. The example clearly shows you put the tables in the array, you have not done this.

D'Oh! I am such an idiot! Thanks

Originally Posted by Paul M

2. You cannot do this with the vb cron system.

Is there mod out there that allows me another choice for cron execution?

[69lakalle]

Originally Posted by Paul M

You mysql timeout must be very low - I would say the database connection is timing out checking the previous table, which I would guess is the post table.

Thank You
What should i do?
Contact webhost ?
What is a good timeout for mysql ?
Thank You again

[Paul M]

If you are on a shared server then contact your host - dont hold out too much hope tho.

[BeerLuver]

Excellent mod/addon . I'm not too savvy with setting up cronjobs/scheduled tasks properly, so this worked perfectly. Saves a lot of time and hassle for doing regular backups; which I often tend to forget to do heh.

So huge thanks for this :up:

[Paul M]

Originally Posted by PGAmerica

Is there mod out there that allows me another choice for cron execution?

None I know of.

[Artes_Marciales]

There is any way that files not contain in your name the date but the folder yes contain?
Best Regards!!

**nominated**