Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 16 Nov 2007, 04:30
bxbigt bxbigt is offline
 
Join Date: Oct 2007
Real name: Steve
database

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
Reply With Quote
  #2  
Old 16 Nov 2007, 05:20
R1lover's Avatar
R1lover R1lover is offline
 
Join Date: Apr 2006
Location: Northern Ca
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?
Reply With Quote
  #3  
Old 16 Nov 2007, 05:33
Gunshot Gunshot is offline
 
Join Date: Feb 2005
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
Reply With Quote
  #4  
Old 16 Nov 2007, 06:07
R1lover's Avatar
R1lover R1lover is offline
 
Join Date: Apr 2006
Location: Northern Ca
ahh didn't think of that, I also always use ssh... there's another way? lol
Reply With Quote
  #5  
Old 16 Nov 2007, 06:09
bxbigt bxbigt is offline
 
Join Date: Oct 2007
Real name: Steve
i dont need to , but that is the limit and i was wondering tell me more plz , any links lol

thanks
Reply With Quote
  #6  
Old 16 Nov 2007, 06:54
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
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/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_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/showt...t=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 12:11.

Layout Options | Width: Wide Color: