vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Moving Databases (https://vborg.vbsupport.ru/showthread.php?t=180002)

OcR Envy 05-21-2008 10:38 AM

Moving Databases
 
I want to move just certain tables(user, forums, threads, posts) of the DB to another DB, is anyone aware of a tool that will do this for me?

royo 05-21-2008 10:41 AM

PHPMyAdmin, or do it from SSH if you know your way around.

Dismounted 05-21-2008 10:51 AM

You should not copy over individual tables, doing so will most likely break your board! If you want to transfer users/thread/posts/etc., use ImpEx.

Marco van Herwaarden 05-21-2008 10:51 AM

You can not just move/copy tables, this will break vBulletin.

If you are trying to merge 2 boards, then use ImpEx.

OcR Envy 05-21-2008 12:03 PM

I suppose I just assumed it would transfer the whole table, I want to transfer users, forums, threads and posts. I'll give impex a shot, it shouldn't cause any dire problems with the original database right?

Dismounted 05-21-2008 12:18 PM

Just transferring the "user" table would break your board. Other tables also contain user info, which you would have lost if you don't use ImpEx.

hoopsta 05-21-2008 03:10 PM

Quote:

Originally Posted by Dismounted (Post 1526791)
Just transferring the "user" table would break your board. Other tables also contain user info, which you would have lost if you don't use ImpEx.

so I can't move my existing website with vb to a new server?

I'm getting a "runaway" ERROR on my current server. I don't know how to fix it and they are threatening to shut down my site.

royo 05-21-2008 03:17 PM

You can move your whole website to a new server, you just have to export the whole database, the OP is trying to do something a bit different than you.

You are probably going to get kicked out because you are using too much resources on your current server.


All times are GMT. The time now is 08:27 AM.

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.01024 seconds
  • Memory Usage 1,720KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)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