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]

Some hosting systems (Plesk being an example) have default open_basdir settings that prevent the webserver writing to any files outside the domains root html folder. You have to check/change them.

[jazz_aaf]

the script stops after the largest table in database. How to overcome this?

thanks

[kenfuzed]

This may be unrelated to the backup itself, but right after this runs each morning my db/site seems to be having trouble restarting correctly. This doesn't happen every time but lately has occurred several times per week. Only the forumhome page starts correctly but all other pages have errors and won't display their content (just lines of errors). When I go in and turn vB off then back on, all pages display correctly. The errors occur right after the backup completes. Is there a command I could add to the end of the backup config file that would perform this restart procedure after the backup is completed?

[raiderlax]

How big of a database can this backup?

Thanks

[Paul M]

There is no limit other than what your server can handle.

[raiderlax]

Okay thanks, but I am somewhat confused. Their is the option of SSH backup and that can do big database backups, now with this one isn't it a script and could it "time out" on big databases?

I am somewhat new to database backups and don't fully understand them, so say my database is 500mb , this can back it up without timing out and would do a FULL backup?,

now what do you mean "other than your server can handle"???

Sorry for all the questions, I truly appreciate the help

[cjddrum1]

I have a question, this may sound stupid however:

the backup isnt just 1 sql file, say I wanted to restore the database, would I have to load each .sql file that this backup saved?

Say I had a database error, how would I go about restoring the database?

sorry just trying to figure out how to use this since im used to the 1 .sql file

[raiderlax]

When this backs up it put the sql into seperate files and not into a zip or something, how would I re-upload the database now???

Thanks

[Paul M]

As per the many previous posts on the subject, you have the choice to backup to a single file if you wish.

[raiderlax]

Originally Posted by Paul M

As per the many previous posts on the subject, you have the choice to backup to a single file if you wish.

Sorry found out how to do it now, wow!, this backs up the database so fast, how come it is this fast, it took like 3 seconds to do a backup, whereas I used another script and it took like 1 minute.

I downloaded the backup file and it was 15 mb, now is this too large for a database?

Now sorry but I have to ask this, how would I go about restoring the database from this 1 file?, please I need to know this.

Thanks