Update on Database Coonversion
Submitted: Monday, Jan 09, 2006 at 19:40
ThreadID:
29515
Views:
1782
Replies:
5
FollowUps:
10
This Thread has been Archived
ExplorOz Team - David
Hi all,
Spent the whole day on the
forum DB conversion that has been mentioned in a few posts. Just to let you know that I may be able to get the conversion completed tonight. Depends on how long the data copy for the first 500MB takes. It is copy from my office machine to the new server and is dependant on the Internet connection performance. If this completes in reasonable time I will turn the
forum off about about 10PM WST (Midnight QLD, 1AM EST, 12:30AM SA, NT etc) and complete the remainder of the data copies and bring it up on the new DB.
There will be a few changes and I expect some early teething problems with large searches etc so please let me know how things are going. I will create a new post when the convert is completed for
feedback.
Reply By: Lone Wolf - Monday, Jan 09, 2006 at 20:04
Monday, Jan 09, 2006 at 20:04
Turning the
forum off, will be akin to turning off life support....
We will have to.... watch telly..... look at a .... what are they called? Oh yeah... books....
Bugger
Wolfie
AnswerID:
147464
Follow Up By: Member - Roachie (SA) - Monday, Jan 09, 2006 at 20:30
Monday, Jan 09, 2006 at 20:30
Or give our long-suffering spouse or girlfriend (may they never meet..hahaha) some long-overdue attention????
FollowupID:
400820
Follow Up By: Lone Wolf - Monday, Jan 09, 2006 at 20:33
Monday, Jan 09, 2006 at 20:33
Well Bill, it will be interesting to see if any EO babies are born on the 9th. September this year.
Imagine, we have Muddy & bride to be, and now.... a powercut.... whoops....
forum cut.
Cheers
Too old for wolf cubs Wolfie
FollowupID:
400822
Follow Up By: ExplorOz Team - David - Monday, Jan 09, 2006 at 20:59
Monday, Jan 09, 2006 at 20:59
You guys should be in bed at that time of day!!!!!
As for progress the copy is about 50% so it looks like I will be attempting to get the cut-over done tonight.
FollowupID:
400825
Follow Up By: Bonz (Vic) - Monday, Jan 09, 2006 at 21:35
Monday, Jan 09, 2006 at 21:35
Muddy has had the cut? Does Jude know?
FollowupID:
400837
Follow Up By: Truckster (Vic) - Tuesday, Jan 10, 2006 at 00:05
Tuesday, Jan 10, 2006 at 00:05
As long as your network doesnt run across a shoelace it should be no issues
FollowupID:
400869
Follow Up By: techie - Tuesday, Jan 10, 2006 at 23:41
Tuesday, Jan 10, 2006 at 23:41
you guys really crack me up! The comments are better than phriday phunnies.
10 mins later and I'm still chuckling - are you lot really like this in real life??
Gotta meet ya all one day.
Techie.
ps this is the first place I view after I log on - even before I check my eMail.
FollowupID:
401023
Reply By: Ruth from Birdsville Caravan Park - Monday, Jan 09, 2006 at 20:58
Monday, Jan 09, 2006 at 20:58
Just got the email from Michelle, David, and whatever you did seems to be working - I got straight in this time, thanks.
AnswerID:
147480
Follow Up By: ExplorOz Team - David - Monday, Jan 09, 2006 at 21:00
Monday, Jan 09, 2006 at 21:00
No worries Ruth, glad it is now working. Sorry for the delay.
FollowupID:
400826
Reply By: GOB & denny vic member - Monday, Jan 09, 2006 at 21:26
Monday, Jan 09, 2006 at 21:26
goodday david
forum seems to be answering a bit quicker and the reply box is also coming up
i gave up on 1 answer tonight it was so slow but i have been waiting to see how it goes with your upgrading
steve
AnswerID:
147487
Follow Up By: ExplorOz Team - David - Monday, Jan 09, 2006 at 21:33
Monday, Jan 09, 2006 at 21:33
If I don't drink too much and can see see the pixels (not the pixies) from about 10-12PM the system should be upgraded and tomorrow will be the big first test. As mentioned earlier I may have to tweek the search operations over the next few days to try to make it run OK but I am waiting to see what happens with the basic convert. I have converted the programs on my local system and done a fair amount of testing so all looks good from this end just waiting the get all the data up and available on the new online DB server.
PS: I expect the down time to be around 2 hours as I need to bring down to my local system the entire DB that is running live now (about 45-60mins) and then extract threads from the 1 Dec 05 till now (5 mins) and upload these parts to the new DB (10mins), test (a long time usually) and turn on (takes about 5 secs - no jokes please).
FollowupID:
400835
Follow Up By: Member - JohnR (Vic)&Moses - Monday, Jan 09, 2006 at 23:04
Monday, Jan 09, 2006 at 23:04
Doing well David. Hope it all works well.
Five seconds to turn on. I am a bit older now. I don't see the joke. LOL
FollowupID:
400858
Reply By: Member - JohnR (Vic)&Moses - Monday, Jan 09, 2006 at 23:07
Monday, Jan 09, 2006 at 23:07
I didn't notice the predjudiced title til just now. Next job to be able to edit your posts.....
AnswerID:
147514
Follow Up By: gramps - Wednesday, Jan 11, 2006 at 10:07
Wednesday, Jan 11, 2006 at 10:07
Well spotted John. Nothing wrong with your eyes :)))
FollowupID:
401052
Reply By: Member - JohnR (Vic)&Moses - Monday, Jan 09, 2006 at 23:08
Monday, Jan 09, 2006 at 23:08
I didn't notice the predjudiced title til just now. Next job to be able to edit your posts..... make em PC
AnswerID:
147516