vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   How Do I Split Vbulletin / Photoposts Databases (https://vborg.vbsupport.ru/showthread.php?t=135656)

58D 01-05-2007 11:13 PM

How Do I Split Vbulletin / Photoposts Databases
 
Background info:
--------------------
Vb version - 2.2.9 (upgrading very soon)
PhotoPost version - 3.1.1 (also upgrading very soon)
My experience level - Novice
Mysql Version - 4.1.21 standard
PHP version - 4.4.3

--------------------

There are tons of very experienced folks here so I thought I would see if you can help me out of a jam.

I'll soon be upgrading to Vb 3.6.4.. Before I upgrade I would like to split my PhotoPost and Vb databases into two separate databases.

Here is how I made my first attempt:
1. Created new database called PhotoPost.
2. Assigned the same Mysql user that access the forums database to the new PhotoPost database with full permissions.
3. Exported all of the PhotoPost tables out of my forum database and into the new PhotoPost database.
4. Edited the PhotoPost config-inc.php file to point towards the new database.

I thought it would be that simple, however the screenshot I've attached shows the error I am getting.

What am I forgetting to do? There are a lot of smart folks here, I'm sure someone can help. Thanks.

Jake

58D 01-05-2007 11:16 PM

1 Attachment(s)
Oops here is the screen shot.

58D 01-07-2007 03:18 AM

Any Ideas? Could really use some help understanding the proper way to do this.

Jake


All times are GMT. The time now is 02:49 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.01119 seconds
  • Memory Usage 1,706KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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