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.

[taydu]

One question, after I restore the database and go to the forum it still say " Forums is close ...." shouldn't it turn on automatically? Just to make sure that i'm not doing anything wrong

[Paul M]

No, you will have to turn it on manually if it's closed (because you backed it up closed).

[taydu]

thanks Paul,

In the future will you include FTP option so it can upload the db to an external server for a second back up? This is a nice feature to have, hope to see it future version.

Thanks

[verbs]

I apologize for being a newb here, but is there a step by step of how/where to install this on my database and then how to turn it on so that it backs up all the information I need automatically?

[Quantnet]

which directory you guys backup to? I backup to the same server my forum resides but given that the backup folder is 777, other people will be able to read my database backup ?

[TrIn@dOr]

Hey Paul, in our site the script halt on "Database Backup" and stays there.

In the FTP, the new date dir is created, but the site is not closed and a sql file is not generated.

3.6.4

[Paul M]

Then you have a problem with your set-up.

[Reven]

Originally Posted by TheFrienzNet

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 172643155 bytes) in /usr/local/psa/home/vhosts/frienz-network.com/httpdocs/includes/mysqlbackup.php on line 534

Hmph.. I guess the memory exhausted?

PHP obviously ran out of memory. If you have access to php.ini then you can manually increase the allocated memory for PHP, but backups by nature will always be resource intensive.

Originally Posted by Paul M

If you don't mind I'll think about borrowing this code and adding some extra options at some point (when I'm not so busy).

Sorry for not replying sooner. Yes, of course you can use the code.

[oglsmm]

You can also create/edit the .htaccess file in your forum directory. Add the line:

php_value memory_limit 50M

If your host allows this you can boost the allowed memory.

[kontrabass]

I really wish I could use this mod... Is there any chance of a MysqlHotCopy version of this? Or is there already something out there that I'm not finding?

With over 3.5 million post table records and no slave DB server, using mysqldump really isn't an option (downtime would be way too long).

Mysqlhotcopy can do the backup in 3 minutes, but I wish I could find a mod like this to shut down / open the boards automatically...