vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Moving Servers/Database Backup Help (https://vborg.vbsupport.ru/showthread.php?t=185953)

RC Attacker 07-21-2008 06:38 PM

Moving Servers/Database Backup Help
 
I have read the docs on moving vBulletin to another server and I still need some help.

All I want to do is move the threads, posts, and members to the new forum. I don't want to save any Admin CP settings, user groups, user ranks, styles and skins, modifications and hacks, or avatars and profile pictures.

It seems my only way (the only thing I have access to on the original forum) is the Admin CP database backup. When I try to download it to my hard drive I do not know if it is completing because it is a large database.

And when I try to backup the database to a file on the server I get this message:
Quote:

Unable to write backup to file ./forumbackup-07-21-2008-fbf95.sql. This file or the directory this file is in must be world writable!
and if I add that file and chmod it 777 it says the file already exists.

Quote:

All I want to do is move the threads, posts, and members to the new forum. I don't want to save any Admin CP settings, user groups, user ranks, styles and skins, modifications and hacks, or avatars and profile pictures.
In order to get only those three things successfully onto my new forum, which tables do I need to select yes to when downloading the database to my computer? And after I do that where do I upload it to on the new forum?

MoT3rror 07-21-2008 08:18 PM

You need to chmod the directory. Also Impex I believe will take care of all the importing when you get the database backup.

SEOvB 07-21-2008 08:50 PM

you will need to be bale to login to the old server via FTP, then chmod the forums directory to 0777

This will make the DB backup right there in the forums directory, then you will need to download that.

Move it to your new server, restore it, and use impex to import the data you wish to import. You can download impex from vbulletin.com/members area

Dismounted 07-22-2008 07:03 AM

Create a full backup of your database:
Quote:

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
As the posters above have said, you can use ImpEx to import as little as you want.


All times are GMT. The time now is 08:22 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02435 seconds
  • Memory Usage 1,719KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete