database

[bxbigt]

heres a quick question my boared is getting semi big and im about to head over the 51 mb database just curious if needed how do i load a database over the 51 mb aloud maxmuim

[R1lover]

51mb is not a big database.... why do you think it's big? Is your host telling you this, or limiting you to this 51mb size?

[Gunshot]

I think he might be referring to restoring a database using phpmyadmin.....I think..
Shell access is the best and easiest way to backup and restore a database and there are no size limits.....

or you can contact your host and they will do it for you

[R1lover]

ahh didn't think of that, I also always use ssh... there's another way? lol

[bxbigt]

i dont need to , but that is the limit and i was wondering tell me more plz , any links lol

thanks

[Marco van Herwaarden]

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. 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