Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
4 registered (capnbob, id242, johnH, Mike L), 41 Guests and 19 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 04/12/04
Posts: 154
Top Posters (30 Days)
Ruben 49
DennyP 24
Gizmo 23
Dunny 18
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 2 1 2 >
Topic Options
#180675 - 03/14/07 06:27 PM Set up forum on new machine with old data
weerdboil Offline
stranger
Registered: 03/14/07
Posts: 21
Hello.

I am trying to install a UBB Forum for a friend of mine whose hosting has just gone down. I am from a .net background (hopefully this doesn't count against me) and I'm struggling with the config somewhat.

The old version was running from 6.1 and mysql 4.0.
I have mysql 4.1 and 5.0 running on my machine and I have a copy of ubb 7 installed at this location - http://www.talkmorgan.co.uk/forums/ubbthreads.php

I have the old database, or at least I think I have, installed into the mysql 5.0 folder and I can query the contents from the command prompt.

So my question is how can I get the new ubb 7 forum to see the old mysql data.

Thanks very much for your help.

Yours,
Dave
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#180681 - 03/14/07 07:04 PM Re: Set up forum on new machine with old data [Re: weerdboil]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
I'd think that each mysql process has its own port on the same server, if so then it's just a matter of updating the configuration file to read from one location vs the other.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#180700 - 03/15/07 03:58 AM Re: Set up forum on new machine with old data [Re: Gizmo]
weerdboil Offline
stranger
Registered: 03/14/07
Posts: 21
Hi.

Is the configuration file you are referring to you includes/config.inc.php?

If so, which property should I be editing?
If not, which config file are you referring to?

Thanks again.
Dave
Top
#180701 - 03/15/07 04:04 AM Re: Set up forum on new machine with old data [Re: weerdboil]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
There is only one config file:
includes/config.inc.php

The top area should deal with connection information; I'm not entirely sure if Rick allows specifying a specific port in the configuration however... if it doesn't then you may have to edit the mysql lib file.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#180702 - 03/15/07 04:05 AM Re: Set up forum on new machine with old data [Re: Gizmo]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Before I say anythimg more, i figure I should ask, how do you connect to the OTHER mysql server? is it a seperate port, or a seperate hostname, or what?
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#180704 - 03/15/07 04:47 AM Re: Set up forum on new machine with old data [Re: Gizmo]
weerdboil Offline
stranger
Registered: 03/14/07
Posts: 21
Hello.

I have the error message up now -
Table 'morgan.w3t_user_profile' doesn't exist

This is presumably because there is database schema changes in ubb 7?

I seem to be going round in circles. Have you any advice about how I can best get the old forum up and running?

Thanks,
Dave
Top
#180705 - 03/15/07 04:55 AM Re: Set up forum on new machine with old data [Re: weerdboil]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Umm, you're not just throwing up the new files and trying to shove in the old database info are you?

IIRC UBB6 uses w3t as the standard table prefix, whereas UBB7 uses ubbt, hence the question.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#180706 - 03/15/07 05:01 AM Re: Set up forum on new machine with old data [Re: Gizmo]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
I think a better question is, what version of the UBB is your "old" database? Is it UBB7 or UBB6?

If it's UBB6 you'll need to install the latest 6.5.5 then import to UBB7 as there has been a complete rewrite from the ground up.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#180707 - 03/15/07 05:39 AM Re: Set up forum on new machine with old data [Re: Gizmo]
weerdboil Offline
stranger
Registered: 03/14/07
Posts: 21
Yes. The old database is version 6.

I tried doing it this way round initially but was told at the end of the installation that ubb 6 does support mysql 5.

So basically I need to install ubb 6.5.5 to mysql 4x and then upgrade?

Thanks,
Dave
Top
#180708 - 03/15/07 06:54 AM Re: Set up forum on new machine with old data [Re: weerdboil]
Mark S Offline
Carpal Tunnel
Registered: 07/04/06
Posts: 4447
Loc: Liverpool : England : UK
Yep \:\)
_________________________
Version v7.5.6 smile smile < Threads satisfaction status
People who inspire me Rick Gizmo Ian David jgeoff ntdoc
Oooo i hear 8 is coming? just after 7 my friend.
Top
Page 1 of 2 1 2 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33841 Topics
181698 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image