[Forum] Where is Backup Database Option in Vbulletin 4 ?

[guesst1078]

Yesterday, I just upgrade my forum to Vbulletin 4.0.2 Suite. Today, I went into the MAINTENANCE OPTIONS to backup my forum database like I used to in Vbulletin 3, but I don't see the DATABASE BACKUP OPTION under MAINTENANCE anymore. Anyone know where that option at? Or Vbulletin 4 doesn't have one?

Screen Shot: http://i48.tinypic.com/34ya3nr.png

[Anthony89]

The feature has been removed.

[guesst1078]

Thank Anthony89. But I don't know why they remove this great feature. This is so odd. I know we could using phpmyadmin on the server to backup the database, but I like to using it in Forum ACP. It is quicker and easy. I hope their going to put back this feature in the vbulletin 4.0.3.

[s0lidgr0und]

It's with the roadmap.

[Trevor Hannant]

It was removed because backing up with a PHP script like that in the AdminCP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. The most reliable method of backing up and restoring a database is with shell access via ssh. Please see the instructions here:

Backup:

http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:

http://www.vbulletin.com/docs/html/maintenance_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:

http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:

http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

Bigdump:

http://www.ozerov.de/bigdump.php

[beishe8]

P.S. If you don't have shell access, some people have also reported success with these scripts:

Trevor,I believe that very few people have shell access to the database.
It would be in the best interest of vB to design a good, inbuilt backup system into vB4.

[Ashley Pietersen]

I agree with beishe8. Hope to see such a feature soon in new next version. - Ashley

[samiro]

of corse - this backup is must in the admin cp

[borbole]

While the backup option in the acp is a ''must'' for small forums I wouldn''t recommend to use it for medium and/or large forums. In such cases, the other ways listed by Trevor Hannant above are the best way to go.

[mcrider]

You could always install
vBulletin Cron Based Database Backup
http://www.vbulletin.org/forum/showthread.php?t=231481

[beishe8]

You could always install
vBulletin Cron Based Database Backup
http://www.vbulletin.org/forum/showthread.php?t=231481

It is a good hack from Paul but:

Since I did not write the original version, but have modified & adapted it, support of this modification may be limited.

...or scrapped.Can we expect anyone to update his/her hack forever for free?
Could vB scrap the backup function without saying a word about it?

[chuckrobbie]

Well I would think that there are more smaller boards than big ones...and usually a big board owner would have access to the DB anyway!

I would like to see this added back for smaller boards! It was quick, easy and perfect for noobs like me!

[samiro]

me 2.
we want back the backup... (from the adminCP)

[Videx]

It was quick, easy and perfect for noobs like me!

Ya, except that, like the man just reminded you, it simply wouldn't work a lot of the time. Of course, if you never tried to recover using one of those backups, you probably never noticed it.

My site backup isn't exactly huge at 2.5gb, but that's large enough that even the usual cpanel backup options won't work. Oops wait, we're talking about db backups? Those need to be done daily and there's no way you're going to go in and hit those buttons on a regular basis. If so, then just use the cpanel db backups daily. Same number of button pushes.