Database to big ?

**Steve Machol** · Tue 18 Sep '07, 7:19pm

Thatt doesn't seem too big to me.

**liorra3** · Tue 18 Sep '07, 11:39pm

tnx Steve

**BBH** · Wed 19 Sep '07, 8:45am

How Big is Too Big?

Originally posted by Steve Machol

Thatt doesn't seem too big to me.

I know this seems a bit dumb; but our 295MB database won't back up with Admin tools at all, even if I do close the boards.

We have a good dedicated 1&1 server; and we are having no performance problems; but at some point, we will have to start pruning and I was looking for a ballpark number.

So for a totally dedicated server, and a membership of only 7,000; how big is TOO BIG?

bb

**Dilly** · Wed 19 Sep '07, 9:05am

There is no such thing as too big, until you start reaching your hardware limits. You aren't even close.

You need to backup using SSH though. The admin backup is not sufficient.

**liorra3** · Wed 19 Sep '07, 9:33am

Originally posted by Dilly

You need to backup using SSH though. The admin backup is not sufficient.

i am sorry, way is the andmin backup is not sufficient ?
how can i use the SSH backup ?

thx for the info

**Steve Machol** · Wed 19 Sep '07, 9:46am

The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. This isbecause backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file.

Please see the instructions here:

Backup:

vBulletin Manual

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

Restore:

vBulletin Manual

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

If you don't have telnet or SSH access, some people have reported success with these scripts:

MySQLDumper:

403 Forbidden

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

MySQLHotxcopy:

vBulletin Community Forum

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

Bigdump (restore only):