Backup vBulletin with MySQLDumper

MySQLDumper

Well Im not sure if anyone has covered how they backup there vBulletin forum but I have used for sometime.

Its click and backup database system and is very easy to set up and use ( 21 MB takes about 4mins ) and just as easy to re install if you loose your database.

MySQLDumper - Sichern von MySQL-Datenbanken (z.B. Foren, Gästebücher und Onlineshops)

Official Info

MySQLDumper goes around the Timeout error with the help of a small cheats: He picks out only a certain number of data records from the table, notes, how far he came, and calls themselves afterwards. Thus the Script receives the full 30 seconds with each call again and goes around so the Timeout error. The same principle uses MySQLDumper also when restoring the data.
MySQLDumper can pack the data immediately with the protection. Also the Wiederherstellungsscript can read directly from this packed file, without she unpacked on the server become must! Naturally one can leave the file also unpacked, but at the latest with the high shop of a Backups one appreciates this.
Some functions…

• simple safety device and re-establishment of MySQL data bases
• MySQLDumper re-establishes Backups Parser integrated by foreign programs owing to
• MySQLDumper control Multipart Backup. I.e. with large data bases the Backup can be distributed automatically on several files (the desired maximum size of the members adjustable!). During the re-establishment MySQLDumper looks for automatically the correct first member, even if inadvertently anderere one were selected.
• SQL Browser: You have access to your tables. You can delete tables, edit or add data records, process and also store SQL instructions directly.
• Data base overview: Processes (with adjustable actualization, possibility for terminating processes), variable, etc.
• comfortable administration of the baking UP files
• automatic deletion of outdated Backups after rules defined (after age of the file or after number)
• over a provided Perl Script can be automated in connection with a furnished Cronjob Backupvorgänge
• Finished, i.e. all possible attitudes of the PHP Scripts are likewise integrated Perl Cronscript in the Perl Script.
• Configuration is possible for September advice for PHP and Perl
• Baking UP opinion with adjusted parameters
• E-Mail notification about Backupvorgänge with and without appendix of the backup file, taken place. Appendix can be limited to maximum size.
• automatic dispatching of the Backups by ftp on another server
• Improved Timing during Backup and re-establishment by automatic adjustment
• Security: One can be able to be provided from the Script a listing protection (this protection applies to the listing of the Skriptes and to all subordinated listings). The kind of the coding is selectable. The script examines for listing protection and shows with absence a warning. (Who integrated the protection differently, this examination can switch off in config.php

What does everyone else use ?

i use this:
Automatic Database Back-up - vBHackers.com - vBulletin Modifications, Hacks, and Help

I'm probably living in the stone age, but I create and restore my database backups using SSH.

Hello everyone, I have installed the vbseo but since then I can not back up the forum.
It always gives me a problem that the page not found.
I have made with mysqldump and with Dump_db and do not work.
It is as if vbseo block access to files. Php

Please someone tell me how can I solve this problem.
Thank you.

Do you guys disable your boards so that no new posts can be made during the backup, or have you found that it doesn't matter?

If you were going to perform a backup via chron and wanted to disable your board during the backup, I suppose you would just run a script to update the vBulletin database and set whatever value specifies that the board is disabled, and then run something to re-enable it after the backup?

Does anyone know if there is a way to set it so that the forum can still be browsed when it is disabled so that there won't be any issues with search engine spiders and people who visit the site can still read threads during the backup?

Finally, is there any way to verify that the backup completed 100% successfully? It may be tough to tell when the backup file is gigabytes large.

Thanks!

Originally Posted by Tize

Hello everyone, I have installed the vbseo but since then I can not back up the forum.
It always gives me a problem that the page not found.
I have made with mysqldump and with Dump_db and do not work.
It is as if vbseo block access to files. Php

Please someone tell me how can I solve this problem.
Thank you.

if there is a script that runs outside of admincp, you can add it to the exclude files in the vbseo CP. but, it really should be in admincp for secuirty reasons.

Originally Posted by Johnny5

Do you guys disable your boards so that no new posts can be made during the backup, or have you found that it doesn't matter?

If you were going to perform a backup via chron and wanted to disable your board during the backup, I suppose you would just run a script to update the vBulletin database and set whatever value specifies that the board is disabled, and then run something to re-enable it after the backup?

Does anyone know if there is a way to set it so that the forum can still be browsed when it is disabled so that there won't be any issues with search engine spiders and people who visit the site can still read threads during the backup?

Finally, is there any way to verify that the backup completed 100% successfully? It may be tough to tell when the backup file is gigabytes large.

Thanks!

i do not close the board. i run it at 5am eastern when basically no one is on the site anyway. (mostly us traffic)

if it misses a few posts, it's not a big deal. This is only one of my 3 backups that i do daily.

1- raw VB dump
2- cpanel nightly dump to NAS at datacenter
3- semi daily local FTP pull to my personal machine at home (in case my data center burns down)

Hello Brian Cummiskey. thank you for your reply.
Regards.

Originally Posted by Ace Shattock

I'm probably living in the stone age, but I create and restore my database backups using SSH.

That's the best way to do it, actually. Especially once your board grows and gets bigger.

I'm at 5 gigs. I was hopeful that MySQLDumper would solve my problems but it seems my boards is simply too big for it. Tried a few different configurations, still no go.

It seems that SSH is the only option that is left for me, but I don't know where to learn.
Does anyone know where there's a good vbulletin guide for getting a vbulletin backup? (As in vbulletin only, I'd like to be direct rather than learn all about SSH when I know I could learn in 3 minutes with a focused guide.)