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.

[santimariani]

Originally Posted by Paul M

You're not getting enough visitors to trigger all your cron jobs.

Paul,

Could you elaborate a bit further or point me to a topic that does? I did not know that I needed visitors to trigger cron jobs. How many visitors do I need?

[Mecho]

Originally Posted by Paul M

1. By default yes - you can change that in the config file.

Would u plz tell me how can i set the Config file to get just a one .SQL backup file, instead of table by table ...

also what is ur suggestion ?? which one is better ( 1 file or table by table ) ?

Thanks in Advance

[princeedward]

thanks for this....it might very useful or help for me.....wonderful mod....million thanks...

[Paul M]

Originally Posted by Mecho

Would u plz tell me how can i set the Config file to get just a one .SQL backup file, instead of table by table ...

Why not read the config file, since it tells you.

Originally Posted by Mecho

also what is ur suggestion ?? which one is better ( 1 file or table by table ) ?

Neither is really better, it's personal choice and dependant on how you intend to use them.

Originally Posted by santimariani

I did not know that I needed visitors to trigger cron jobs. How many visitors do I need?

http://www.vbulletin.com/docs/html/m...ed_tasks_intro

[santimariani]

Paul,

Thanks for the help. I now realize I should set up the task at a time when I will actually have some users, and not when I don't expect there to be any.

[Chadi]

Originally Posted by chadi

Thanks. Out of curiosity is there a swift and rather convenient way to restore the databases (or certain portions) via admincp?

I see the sql files are done per table, which is great but what is the proper way to restore these, aside phpmyadmin?

Just curious if you plan on adding this feature. Thanks Paul.

[BadgerDog]

Originally Posted by chadi

Just curious if you plan on adding this feature. Thanks Paul.

I second that.... :up:

Beautifully written to back us up, but I'd live to be able to do a general restore in case of crisis as easily. I know nothing about tables etc, s it would sure help to be able to do this for laymen like me.

Thanks for your work Paul....

Always appreciated....

Regards,
Badger

[Paul M]

I think this line in the main post covers your question

Notes:
* I will not add anything new to this, or spend vast amounts of time supporting it.

[Evaporate]

Originally Posted by Paul M

I think this line in the main post covers your question

Beats me why this sort of stuff isn't default. I converted from SMF (sorry for swearing, which generally was rubbish compared to VB) . However from the admin panel I could one click bakcup or restore. Brilliant really. I want admins to be able to backup in my abscence but don;t want to give them access to my ISP cpanel etc.

This should really be out of the box stuff. Please please incorporate this sort of feature natively.

[Pure Dope]

Doing a test restore.....

root@www1 [/home/allsexre/backups/2007-07-08]# mysql -umyun -pmypw mydb < Live-2007-07-08-full-backup.sql
ERROR 1064 (42000) at line 24395714: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1812' at line 1
root@www1 [/home/allsexre/backups/2007-07-08]#

Anyone maybe know why? Is there a different way I could import this db?