Log in

View Full Version : Backup Database HELP


introlux
01-20-2009, 10:10 PM
Hi Guys,

I am having problem backing up my forum - I need to do the update but before I do this I have been told to backup the database just incase.

Well I have followed the instructions from:

http://www.siteground.com/tutorials/vbulletin/vbulletin-backup.htm

However I am getting the following error message:

vBulletin Message

Unable to write backup to file ./forumbackup-01-21-2009-70fb5.sql. This file or the directory this file is in must be world writable!

Now what must I do in order sort this problem out. It is something to do with privilages but I do not know what folder to allow write access also what data I need to enter in the text box field.

Any help will be appreciated.

Regards,

introlux

SEOvB
01-20-2009, 10:27 PM
You need to CHMOD the directory your backing up to, to 0777,

If your using that path, you need to CHMOD the directory that has forumdisplay.php and showthread.php (your forum root)

Dismounted
01-21-2009, 04:17 AM
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