AMT Guns forum

Forum Home Forum Home > Auto Mag Pistol > Announcements
  New Posts New Posts RSS Feed - Database move
  FAQ FAQ  Forum Search   Register Register  Login Login

Database move

 Post Reply Post Reply
Author
Message
Ian View Drop Down
Admin Group
Admin Group
Avatar

Joined: 07 Mar 2008
Location: England
Status: Offline
Points: 544
Post Options Post Options   Thanks (0) Thanks(0)   Quote Ian Quote  Post ReplyReply Direct Link To This Post Topic: Database move
    Posted: 24 Jul 2014 at 10:08pm
Hi everyone, 

I am sorry that the forum has been down for the last 20 days but we had yet another database corruption. 

When the forum was first set up we used a database called MS Access and over the years it has done us proud, MS Access is a free database and as we have grown it is sadly a story of you get what you pay for and as such we have had two database corruptions in the past few weeks. 

With that in mind I decided to get an upgrade to the forum from MS Access into mySql, the problem is that there is direct upgrade form the two different database vendors so I have spent the last couple of weeks in the evenings writing a set of custom migration scripts so we did not suffer a loss of all of fantastic information that we have built up over the years. 

And I am happy to say that after quite a bit of working and testing the script is complete and the migration has taken place tonight and is now complete.

What does this mean?

Well as far as users of the forum are concerned there should be no  change (if I have done my job correctly) but instead of the database being run from the free MS Access we are not running on a real relational database server (mySql) that can cope with the number of users, topics, replies and PM's that we are using.

For those who are interested this is the stats as I type:

Number of Topics 1,724
Number of Posts 15,939
Number of Members  793
Number of Private Messages 5,429
Number of Polls 2
 
The move to mySql should give us a robust platform going forward, like I have said I am sorry for the disruption to the forum but we should be good from this point on. 

All the best. 

Ian 


Back to Top
AMTFAN44 View Drop Down
International Auto Mag
International Auto Mag
Avatar

Joined: 14 Dec 2011
Location: Kalifornia
Status: Offline
Points: 133
Post Options Post Options   Thanks (0) Thanks(0)   Quote AMTFAN44 Quote  Post ReplyReply Direct Link To This Post Posted: 24 Jul 2014 at 10:24pm
Great job Ian!

I'm glad to see the forum back up and running
"Maybe we could build a fire, sing a couple of songs, huh? Why don't we try that?"
Back to Top
Luc V. View Drop Down
Admin Group
Admin Group
Avatar

Joined: 09 Mar 2008
Location: Belgium
Status: Offline
Points: 1023
Post Options Post Options   Thanks (0) Thanks(0)   Quote Luc V. Quote  Post ReplyReply Direct Link To This Post Posted: 25 Jul 2014 at 10:23am
Thank you for your work Ian.
If you need a contribution to help support the forum, just ask and I would be glad to help.
 
Luc V. 
Back to Top
robocop View Drop Down
180 Auto Mag
180 Auto Mag
Avatar

Joined: 14 Jul 2012
Location: Orange County
Status: Offline
Points: 25
Post Options Post Options   Thanks (0) Thanks(0)   Quote robocop Quote  Post ReplyReply Direct Link To This Post Posted: 25 Jul 2014 at 9:20pm
Great job Ian.  If it weren't for you there would not be a forum for all the experts to help
with their input for us novices.
 
Back to Top
AutoMagyar View Drop Down
Callahan's Auto Mag
Callahan's Auto Mag


Joined: 20 Jul 2012
Location: The Big Smoke
Status: Offline
Points: 304
Post Options Post Options   Thanks (0) Thanks(0)   Quote AutoMagyar Quote  Post ReplyReply Direct Link To This Post Posted: 25 Jul 2014 at 10:40pm
Way to go Ian. 
Congrats on successfully fixing the problem.
You da man. Big smile

Cheers.
"Are you gonna pull those pistols or whistle Dixie?"
Back to Top
AutoMagyar View Drop Down
Callahan's Auto Mag
Callahan's Auto Mag


Joined: 20 Jul 2012
Location: The Big Smoke
Status: Offline
Points: 304
Post Options Post Options   Thanks (0) Thanks(0)   Quote AutoMagyar Quote  Post ReplyReply Direct Link To This Post Posted: 25 Jul 2014 at 10:46pm
Ian,
I forgot to ask:   One thing I noticed is that the " latest posts" thread/heading is gone.
Is that going to be brought back or no?, just curious.

Cheers.
"Are you gonna pull those pistols or whistle Dixie?"
Back to Top
paul v. View Drop Down
International Auto Mag
International Auto Mag
Avatar

Joined: 10 Mar 2008
Location: western ny
Status: Offline
Points: 86
Post Options Post Options   Thanks (0) Thanks(0)   Quote paul v. Quote  Post ReplyReply Direct Link To This Post Posted: 26 Jul 2014 at 7:34pm
Ian,
Time, effort and dedication much appreciated!
Paul V.
Back to Top
tgt40 View Drop Down
Callahan's Auto Mag
Callahan's Auto Mag
Avatar

Joined: 05 Jan 2009
Location: Calgary
Status: Offline
Points: 462
Post Options Post Options   Thanks (0) Thanks(0)   Quote tgt40 Quote  Post ReplyReply Direct Link To This Post Posted: 27 Jul 2014 at 1:30pm
Good work, thanks so much!  I was missing this a bit!!!
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.129 seconds.

 - amtguns.info All rights reserved