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.

[Paul M]

Yes, you can use that for MySQL5 as well.

All it does is add the DISABLE KEYS command while the data is being loaded (and then ENABLE them afterwards).

[Mudvayne]

Ok.. Paul.. I just installed it.. I'm using MuSQL v5.0.24-standard-log.. I didn't change any value for this "$backup['MYSQL4'] = 1; // Set to 1 if you are using MySQL4".. I mean keep it as it is.. Then run it from Schedule Task Manager without having any error.. Does that mean its working fine?

[Paul M]

You won't know that until you restore a database using the output file.

[kotlt99]

how does it work ??
I installed but i dont know how to backup database ?

[Mudvayne]

It 'll take the backup automatically using cron.

[JimmyN]

I have a few questions, first of

My database is 30mb, is there a way to keep get it smaller?
Also i would like to archive a few days of database backups and then have a cron script that will remove the old ones so i dont build up a few gig just in backups.

Also if i needed to restore one of these files, how would i do it?
Is there a way i can restore it from script /home/myname/forum_db_backup/
It would take a hour to download it from the server and iv never been able to restore it via php myadmin, (any file over 10mb) as it stops responding and looks up, probally due to timeouts etc.

Thats why id like the server side to restore to save me having to download and upload etc.

Anyone know how this can be done?/or make a script/cron for this hack

Thanks heaps

[verbosity]

Thank you so much! Installed and just did a test run, works!

[Bounce]

BRILLIANT !!!!

Works superbly on 3.6.4

Thanks Paul

Its taking around 7 mins to run so i've changed the forum off message to suit

The Forum is closed because a database backup is in progress.
Approx Time for this is 7 mins......

It will be getting run at 3am so shouldnae be many on so letting my forums stay closed whilst it completes it

*clicks install*

[TonyGau]

When i test this mod on localhost(windows), it work successful, But when i publish this mod on my server(linux), it not work
I config like

$backup['DUMP_PATH']	= '/var/www/vhosts/mydomain/httpdocs/diendan/backups/';

and I chmod 777 to backups folder
I click run now Dbbackup in Scheduled Task Manager, display this error

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

But I browse backups folder , it create a folder like 2006-12-08 (?)
What this problem ? Can u support me ?

[JimmyN]

Tonygau, check the config backup path is correct, and also chmod 777 the folder.