AMT Guns forum

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

new database

 Post Reply Post Reply
Author
Message
TRX302 View Drop Down
Callahan's Auto Mag
Callahan's Auto Mag
Avatar

Joined: 02 Dec 2011
Location: Arkansas
Status: Offline
Points: 592
Post Options Post Options   Thanks (1) Thanks(1)   Quote TRX302 Quote  Post ReplyReply Direct Link To This Post Topic: new database
    Posted: 18 Aug 2014 at 3:16am
Quote
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


Thanks, Ian! It looks like everything was successful.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.066 seconds.

 - amtguns.info All rights reserved