Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
  #1  
Old 31 Oct 2007, 00:51
sarahk's Avatar
sarahk sarahk is offline
 
Join Date: Jun 2004
Backup/Restore a large database

A client has a large MySQL database and the existing backup & restore options provided through vBulletin are timing out as the database is large (596MB).

The hosting console has limited features - it's cpanel or direct admin or anything. We don't have shell access but will be able to use PHP's exec().

Prior to software upgrades we need to be backing up the database and able to restore it if need be.

Any recommendations?
__________________
Property Management Services
Simple SEO Blog
Reply With Quote
Comments
  #2  
Old 31 Oct 2007, 09:19
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

Similar Mod
Mod Developer Type Replies Last Post
MySQL Database Backup/Restore Hack Ver. 1.0 Birdie501 vBulletin 2.x Beta Releases 150 18 Jul 2004 22:32



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

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 02:46.

Layout Options | Width: Wide Color: