Administrative and Maintenance Tools - vB Database Backup Pro (Lite) for vb 3.6

This modification is no longer available or supported.

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 for vb 3.6.

The original version was by Trigunflame and the rights to the code were bought by Zoints (D.Chapman) in January. A while ago David gave me permission to release my adaption, but until now I haven't got round to it. Trigunflame did mention a few months ago he was working on a new version, but nothing ever appeared.

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. It's been in use on our forum since the day 3.6 was installed.

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 3.0 backup functionality on 3.6.


History:

v2.10 : First internal version.
v2.11 : Bug fixes, some code changes.
v2.12 : Initial Public Release.

[philip_g]

Originally Posted by Paul M

Turn off safe mode, I have a feeling that you cannot override the default php timeout in safemode, so the script is possibly timing out.

Yep. Working now and backing up a full 400 megs.

[slowphantom]

thx Paul good idee
but i have somthing not right

i make evry thing
and its wreit empty folder
nothing on it
i see the folder 2007-08-31
but its empty
can u help me pls
thx

[rainyleaves]

I set backup schedule task time AM:6.
But backup time is not correct when it's run PM:1 or PM:8 etc...
How can I fix?
Please help...

Thanks.

[Paul M]

Originally Posted by slowphantom

thx Paul good idee
but i have somthing not right

i make evry thing
and its wreit empty folder
nothing on it
i see the folder 2007-08-31
but its empty
can u help me pls
thx

Either it didn't run or you have a folder/files writing permissions error, most likely the second.

Originally Posted by rainyleaves

I set backup schedule task time AM:6.
But backup time is not correct when it's run PM:1 or PM:8 etc...
How can I fix?
Please help...

If you are having trouble with cron jobs then you need to ask on vbulletin.com as that's a standard part of vbulletin.

[rainyleaves]

Thanks, Paul.

[Dream]

I'm running mysql 5, should I set this to 0

$backup['MYSQL4'] = 1; // Set to 1 if you are using MySQL4

Also, to make just one dump and not one for each table, should I set this to 1

$backup['COMBINE'] = 0;

And will this delete old backups?

edit-
I just tested it with combine both on and off and figured it out.

Also I read about the mysql option being for mysql 4 and up, so I leave it as 1? Or would 0 or other value be better for Mysql 5?

Thanks for this mod, I had it on vb 3.0 and it didn't work for ages. I still had the scheduled task there, and the files. And I think the task was enabled.

[Paul M]

Set it to 1 on mysql4 and above.

Nothing in this mod deletes old backups, unless you run two backups on the same day.

[Dream]

Ok thank you.

[djbaxter]

Originally Posted by Paul M

Set it to 1 on mysql4 and above.

Nothing in this mod deletes old backups, unless you run two backups on the same day.

Although, as others have mentioned, that would be an excellent addition to this add-on... deleting old backups after the new one is created or after a certain length of time (e.g., keep only the last 3 days or 7 days).

[jazz_aaf]

Is there a way to divide the backup job into several jobs, each one of those jobs backs up certain tables of the database?

I am not able to backup a large database because of large tables.