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.

[Deimos]

This is the out of memory message I get

Creating gzip file from SQL file

Fatal error: Out of memory (allocated 5242880) (tried to allocate 206317869 bytes) in /home/xxxxx/public_html/includes/mysqlbackup.php on line 534

Forgot to add, I had the memory limit set to 500mb and it did this
so I don't know what to do

[StarBuG]

Hi

Is there a way to have the script make 2 backups each day?
How would I do that?

I have lost 2 days of my forum a while back because the backup was done a short while after my database got corrupt.
To prevent that I really would like to have 2 Backups each day.

Any chance for that?

Thanks in advance

StarBuG

[Deimos]

Can someone tell me why I keep getting that out of memory message?
I still can't do regular backups because of it

Fatal error: Out of memory (allocated 5242880) (tried to allocate 208268833 bytes) in

[Paul M]

No idea, there is no gzip facility in this modification.

[Paul M]

Originally Posted by StarBuG

Hi

Is there a way to have the script make 2 backups each day?
How would I do that?

I have lost 2 days of my forum a while back because the backup was done a short while after my database got corrupt.
To prevent that I really would like to have 2 Backups each day.

Any chance for that?

Thanks in advance

StarBuG

AFAIK, you cannot run one vb cron job just twice a day - you would need to create a second cron job to run at the hour you want.

You also need to change the config file to include the hour in the file name, otherwise one backup will overwrite the other.

[StarBuG]

Originally Posted by Paul M

AFAIK, you cannot run one vb cron job just twice a day - you would need to create a second cron job to run at the hour you want.

You also need to change the config file to include the hour in the file name, otherwise one backup will overwrite the other.

I know that, but how do I add the hour into the filename in the config?
I am not a php programmer

[Paul M]

Edit the backup date config line ;

$backup['DATE'] = 'Y-m-d'; // Backup file date format

The format of the letters is here.

[StarBuG]

This adds the time to the folder as well

I rather would like to have the time added to the filename only so that I have one folder per day with X numbers of backups inside it.
How would I go for that?

[Paul M]

You cannot, there is no seperate setting for that.

[StarBuG]

But wouldn't that be possible by editing the mysqlbackup.php file?
The name is generated there, isn't it?
I don't mind having it hardcoded and not as a config setting.