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.

[dimeola]

Processing poll : Total Rows = 24
Processing pollvote : Total Rows = 291
Processing post : Total Rows = 86239

it is cutting the process here.

I changed my time out period like this

max_execution_time 200

mysql.allow_persistent On On
mysql.connect_timeout 600 600
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

I think i have a different problem.

[Paul M]

max_execution_time is set to 60 on our server, post has over 750,000 rows. Whatever your problem is, it's server related.

[steadicamop]

I've been testing with mine, it reaches around 13mb mark before stopping, I managed to trim some old tables from the database, but it still doesn't reach the end - max_exec time is set to 60 on my server too - this is just so damn frustrating, i realise this isn't your problem, I'm just so desperate to be able to make daily backups automatically!

Thanks,

Jason

[steadicamop]

Just did a short test on something; I used my phpMyAdmin to backup the database - it didn't complete it, cut off around the same place as it would with the VB Backup, then I used my host's version of phpMyAdmin which backed up it fully!!

Just for reference - my version backed up around 13mb, my hosts did a full 24mb.....

[Antyrael]

Hello,

First I want to thank Paul M for this backup plugin, it's working very nice on my Windows server!

Now I got a request, or question, well actually 2:
I would like to compress (zip or rar) the folder containing the .sql files after the dumps have been completed.
Plus I would like to keep a history of atleast 6 previous backups on the server (I don't have the posibility to FTP/move the files to another location), and that the script automatically deletes the oldest backup.

Unfortunately I am unable to code this myself, is there anyone who can help me with this?

[soletrader]

I have a newbie question. I get the following error:

An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

I have chommoded the folder to 777. Did I not input the config.php file correctly?

here is what I have: DIR.'/home/sole/backups/

Is this correct? Thank you

[Paul M]

No, DIR is the path to your forums, you are then appending that with another full path, change it to just '/home/sole/backups/'

[Deimos]

Good system to have, just lacks the Gzip option, which is a shame.

[alraqee]

Paul thanks for the mod

i have small problem, when i started to back up it reach up to Processing posthash : Total Rows = 0
Processing postindex : Total Rows = 585217

then stops !!!

any idea??

[alraqee]

paul ... the problem solved

MySQL Backup was completed successfully with no errors.

thanks again