How to make a backup of my forums? [Archive]

View Full Version : How to make a backup of my forums?

Rick Sample

10-14-2005, 10:18 PM

I have a somewhat large database and when I use my control panel to make vbulletin database backups, it takes hours and hours and while its in the process, no one can access the forums, is their a better way of making this backup or is this normal?

zoro

10-15-2005, 05:36 AM

There is alot of different ways to backup your DB personally i using this app to do it http://www.richtsoft.com DumpTimer i think its the best solution for large databases yo can config the app to backup your db everyday its comressed and you can easly restore one of the backups :D

Rick Sample

10-15-2005, 03:12 PM

Downloaded that a little while ago and it doesn't seem to be working right for me. It'll get almost completed then towards the end have a timeout, out of memory, datestamp, and a bunch of other different errors each time it trys to finish.

Anywase, is downloading a backup with PHPMYADIM via the export tab ok? Its downloading as one SQL file, so if I were to ever loose my database, if I reuploaded that file, all my posts, images, users, etc would be reloaded without any problems?

T_Montana

10-15-2005, 05:06 PM

<a href="http://fragments.turtlemeat.com/mysql-database-backup-restore-phpmyadmin.php" target="_blank">http://fragments.turtlemeat.com/mysq...phpmyadmin.php</a>

aslong as you have phpymyadmin (which you should)

noppid

10-15-2005, 05:29 PM

PHP Admin is no good for large databases. It's limit is like 52MB and there can be timeouts. I dunno the details, it should not be relied on though.

I wrote this, How to Backup via SSH or Cron (http://www.vbwebmaster.com/forums/showthread.php?t=1183), last month. Give it a look.

T_Montana

10-15-2005, 07:14 PM

noppid

10-16-2005, 01:14 AM

my database is about 91 mb and never had it cutoff or timeout

I said there can be, not there will be. SSH/cron backups via mysql are the safest IMHO.