Update on Database Coonversion

Submitted: Monday, Jan 09, 2006 at 19:40
ThreadID: 29515 Views:2001 Replies:5 FollowUps:10
This Thread has been Archived
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.
David (DM) & Michelle (MM)
---------------------------------
Always working not enough travelling!

Lifetime Member
My Profile  My Blog  My Position  Send Message
Moderator

Back Expand Un-Read 0 Moderator

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????
0
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
0
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.
David (DM) & Michelle (MM)
---------------------------------
Always working not enough travelling!

Lifetime Member
My Profile  My Blog  My Position  Send Message
Moderator

0
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?
.
Time is an illusion produced by the passage of history
.

Lifetime Member
My Profile  My Blog  My Position  Send Message
Moderator

0
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
0
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.

0
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.
David (DM) & Michelle (MM)
---------------------------------
Always working not enough travelling!

Lifetime Member
My Profile  My Blog  My Position  Send Message
Moderator

0
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).
David (DM) & Michelle (MM)
---------------------------------
Always working not enough travelling!

Lifetime Member
My Profile  My Blog  My Position  Send Message
Moderator

0
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
0
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 :)))
0
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

Sponsored Links