Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Oct 2002
Posts: 165
Member
Member
Offline
Joined: Oct 2002
Posts: 165
I have a live forum and wanted to install a fresh 6.4 to play with. 2 questions:

- as long as I create a new database and program/data file paths I should have no problems... correct?

- I'm currently running 6.2 with some hacks. I know what I have hacked and their have been some DB changes (such as birthdays/calendar). Would it be possible to imprt my old DB into 6.4 and runi it without hacking the 6.4 (I would restor a mysql dump into the new DB).


Sponsored Links
Joined: Apr 2001
Posts: 3,266
Member
Member
Offline
Joined: Apr 2001
Posts: 3,266
Okay your site is here

http://www.blahblah.com/threads

make a new database for the test site

install a fresh threads to a new directory say

http://www.blahblah.com/test

and complete the install and play. make sure the test one points to the new database. You can even import a backup of users posts in the new forum. If you do this do not run the createtables on the treads install. At this point you would upload your backup and then Make sure to run all altertables on the database.

Joined: Oct 2002
Posts: 165
Member
Member
Offline
Joined: Oct 2002
Posts: 165
thanks!

What happens to the birthdays and calendar information in the DB from the hacks? Will that just be ignored?


Joined: Apr 2001
Posts: 3,266
Member
Member
Offline
Joined: Apr 2001
Posts: 3,266
Actually if you do not want errors on the altertables it is best to delete those fields on your test forum database before running the altertables

Joined: May 2002
Posts: 362
Junior Member
Junior Member
Offline
Joined: May 2002
Posts: 362
[On that note, can one of the gurus put something together to let us know how to delete the calendar hack fields and stuff that were on there for the big upgrade to 6.4 ?]

Sponsored Links
Joined: Apr 2001
Posts: 3,266
Member
Member
Offline
Joined: Apr 2001
Posts: 3,266
Well do you have PHPMYAdmin?

It is as simple as clicking and dropping the 3 birthday fields in the w3t_Users table and the U_Calendar one in w3t_Boards. Althought I think the only one that causes an error from my personal experience is the first birthday table in users table.

Joined: May 2002
Posts: 362
Junior Member
Junior Member
Offline
Joined: May 2002
Posts: 362
Okay cool, thanks!

Joined: Aug 2000
Posts: 1,609
Addict
Addict
Offline
Joined: Aug 2000
Posts: 1,609
I just share my database with 6.3.2 and 6.4b1 Works groovily, and I can see exactly how 6.4b1 is interfacing with my database, to see if everything will work.

Joined: Jun 2003
Posts: 131
Journeyman
Journeyman
Offline
Joined: Jun 2003
Posts: 131
DLW: if you share the database, that means each time you do something with ONE of your boards the data in your daabase is altered, doesn't it? Then when you go to the other board, it shows up with those changes...right? This doesn't cause any problems? Maybe there would only be problems is you had a hack that added a field to the database on one, and not the other?

Tony

Joined: Jul 2003
Posts: 19
Newbie
Newbie
Offline
Joined: Jul 2003
Posts: 19
I don't know the inside workings of how he did it or whatnot, but I can tell you that there is no problems. And yes, I use the test board daily now and it's like I'm on the normal board; changes on one takes place on the other ie new threads, new posts, etc.

Sponsored Links
Joined: Aug 2000
Posts: 1,609
Addict
Addict
Offline
Joined: Aug 2000
Posts: 1,609
[]TonyN said:
DLW: if you share the database, that means each time you do something with ONE of your boards the data in your daabase is altered, doesn't it? Then when you go to the other board, it shows up with those changes...right? This doesn't cause any problems? Maybe there would only be problems is you had a hack that added a field to the database on one, and not the other?

Tony [/]

Yes. Yes. No.

The only changes being made are posts and the like. Nothing in the database is being changed any differently whether accessing it from 6.3.2 or 6.4b1. The only difference in the database is the birthday fields. And since nothing in 6.3.2 calls this, it's totally transparent.

Joined: Aug 2002
Posts: 1,191
Kahuna
Kahuna
Joined: Aug 2002
Posts: 1,191
Surely though there is some degredation in performance for one of the two versions. 6.4 drops some indexes (especially the one in the w3t_Last table) and creates a new one. If you have done that then expect the 6.3 access on that area and perhaps others to be slower than what it would have been.


Nikos
Joined: Apr 2001
Posts: 3,266
Member
Member
Offline
Joined: Apr 2001
Posts: 3,266
Bingo. There are alot more changes to the tables than just the additions to the user table.

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
Yes I would not run 2 different versions off the same database. That can set you up for all kinds of headaches.

Joined: Aug 2002
Posts: 1,191
Kahuna
Kahuna
Joined: Aug 2002
Posts: 1,191
And the problem is that you might find an error in the dev site or the live site purely because of that. If you want to test a new version or a beta before releasing it to the public you must have two databases. Alternatively use your own pc for testing and install the boards with a snapshot of the db.


Nikos
Joined: Aug 2000
Posts: 1,609
Addict
Addict
Offline
Joined: Aug 2000
Posts: 1,609
Leave me alone... I'm happy in my blissful ignorance.

But yeah, I guess for the next beta version (7.0?) I'll install php and mysql on my machine and do it that way.

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
Or you can use the same database (if your host only gives you one)... just create new tables for the beta version with a different table prefix.

Joined: Feb 2002
Posts: 2,286
Veteran
Veteran
Joined: Feb 2002
Posts: 2,286
I suppose the best solution is to make a copy of your existing database, so that you have some real data to play with.


Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....)

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Posts: 70
Joined: January 2007
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)