PDA

View Full Version : How to properly backup?

janneke
27 Apr 2008, 22:55
Don't laugh at me cause I am a real Noob when it comes to that sorta things. I would like to know where I can fully back my site up (no zipfile please) and store the file on my computer(a special thingy I have for backups)

Can anybody please explain me step by step for a full backup? Incl templates and all.
Jase2
28 Apr 2008, 00:13
Backing up via a command line is more reliable than using something like PHPMyAdmin. :)

If you have SSH or Telnet access, then I would recommend backing up via a command line. If not, you may have PHPMyAdmin, if that's the case -- take a look here (http://www.vbulletin.com/docs/html/main/maintenance_phpmyadmin_backup). However, this is only recommend with small databases, as time outs can occur.

You may also be interested in taking a look at this (http://www.vbulletin.org/forum/showthread.php?t=167276) hack, which does an automatic (cron) backup of your database :)
SEOvB
28 Apr 2008, 00:17
Templates are included in the database backup.

The only reliable method of backing up your data is to use SSH a free SSH client would be Putty

After that login to your server via SSH with your account information, and enter commands like

tar -cvvf backup.tar /home/account/public_html/*

and

mysqldump -u USERNAME -p database_name > /home/account/database_backup.sql

Then download the backup.tar and database_backup.sql files to your computer.
Dismounted
28 Apr 2008, 07:43
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
Shriz
28 Apr 2008, 09:16
If you have cPanel for your control panel go to backup and then after 5 minutes go into backup again download the backup file it backs up all your mySQL Databases all your ROOT Dictories everything! :)
SEOvB
28 Apr 2008, 10:14
If you have cPanel for your control panel go to backup and then after 5 minutes go into backup again download the backup file it backs up all your mySQL Databases all your ROOT Dictories everything! :)

I seriously wouldn't rely on that
Boofo
28 Apr 2008, 10:55
Why? CPanel is excellent for things like that.
Dismounted
28 Apr 2008, 13:03
Ask TECK :rolleyes:.
Boofo
28 Apr 2008, 15:29
What am I missing here? ;)
Lynne
28 Apr 2008, 16:18
What am I missing here? ;)
I've seen some posts where people have said that cPanel can create corrupted backups.
Boofo
28 Apr 2008, 16:26
I have never had a problem with CPanel. Direct Admin has given me nightmares, though.
Jase2
28 Apr 2008, 17:19
Personally, I wouldn't backup via cPanel. Much better and more reliable through shell access via telnet or ssh.
theOZer
28 Apr 2008, 18:19
I put together my own worksheet/walkthru where I create a testvb environment then upgrade from vB36x to vB370whatever.
PM me if you would like a copy, it's not a professional write up but it may be of help to you.
~OZ
Rev O
28 Apr 2008, 22:38
The problem is most hosts don't allow SSH or Telnet..what's an Admin to do? There must be more alternatives out there, surely?
Yogesh Sarkar
29 Apr 2008, 16:45
I have never had a problem with CPanel. Direct Admin has given me nightmares, though.
I agree, I also take backups through Cpanel
Turbe
01 May 2008, 02:10
The options (Maintenance/Database Backup, Backup database to a file on the server) in the vBulletin Admin CP are not recommended? What about on XP (NTFS) where I have full access to the server, simply using the option to Save to a path relative to the root and then manually moving the file????

Thanks in advance.
Turbe
07 May 2008, 02:03
The options (Maintenance/Database Backup, Backup database to a file on the server) in the vBulletin Admin CP are not recommended? What about on XP (NTFS) where I have full access to the server, simply using the option to Save to a path relative to the root and then manually moving the file????

Thanks in advance.

Bump
SEOvB
07 May 2008, 02:06
No using the vBulletin script is still not recommended.