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.

[MPDesignZ]

Originally Posted by Paul M

open_basedir restrictions are part of how php is set-up, speak to your host to find out what they may be on your set-up.

Ok it was allowing backups just fine before and now they are not working on the regular database backup system within vbulletin. This is why I went in search of this mod and was trying it out, so I think this maybe another issue all together that I will have to address. I will keep the php open_basedir in mind just in case. But I was able to do backups before we installed FlashChat.

Thanks
MP

[member007]

Originally Posted by Paul M

Go to your Scheduled Task Manager in the ACP and run the cron job.

Works great!! Only problem is that I got too many sql files being generated instead of one sql file to restore. For example, I got Live-2007-12-05-access.sql, Live-2007-12-05-adminhelp.sql, Live-2007-12-05-administrator.sql and the list goes on and on. How does this happen?

[ChurchMedia]

Originally Posted by member007

Works great!! Only problem is that I got too many sql files being generated instead of one sql file to restore. For example, I got Live-2007-12-05-access.sql, Live-2007-12-05-adminhelp.sql, Live-2007-12-05-administrator.sql and the list goes on and on. How does this happen?

That's just the way it's coded. It has its benefits. All of my PHP scripts share the same database, so I like the tables to be separated like that. If you wanted to restore all of them at once, I'm pretty sure you could just use a wildcard (*.sql) to dump back into the database.

[Paul M]

It's controlled by a setting in the config file (just read the file).

[edgecutioner]

In accordance to this post by SkyCatcher on Linux Distros, if your host uses cPanel, you can get your root directory by seeing the 'Home Directory' and adding that value with the directory of the desired folder where your autobackup goes. In my setup, it's like this:

$backup['DUMP_PATH'] = 'home/(my username)/ws/autobackup'; // Path to backups folder, with trailing slash
where home/(my username), I got that from cPanel and I just appended the directory I wanted.

Thanks for the port Paul

[hqvtl2004]

Can you add new function that send backup file to an specific email address? I think it's will be great feature in next version.

Thanks

[MrApples]

Whats the minimum Chmod?

[TrIn@dOr]

Perhaps someone can help me.

After executing this nice script, i have in my selected folder under the today date my 118 sql files. Each one represent a table, Ok?

In my CMD i copy *.sql to theone.sql, right?, to make only 1 file.

Then, locally in my phpmyadmin i try to import the unique file trough the dir ./upload (large file procedure for phpmyadim), yes?

But im getting a halt on the table 85, and all the rest of the tables are not imported.

Why?, need help, this is critical for us.

Thanks in advance.

[Paul M]

That sounds like a phpmyadmin issue - but someone might have a clue if you tell us what error message you get.

[control1110]

I am looking at the config file and something is confusing me does this mod take the forum into offline mode while it is doing the backup or can users still use the forum?