Pre Migration Most liked posts in thread: 5/8 - Site to be down for maint...

  1. KittyMini

    KittyMini Club Coordinator

    Jun 24, 2009
    3,271
    1,183
    0
    Ratings:
    +1,183 / 0 / -0
    #2 KittyMini, May 7, 2010
    NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO!!!!!!!!!
    :frown2:

    JK- thanks for the heads up Nathan. :D
     
  2. Metalman

    Metalman Well-Known Member
    Lifetime Supporter

    Sep 29, 2009
    12,714
    7,659
    113
    Ex-Owner (Retired) of a custom metal fab company.
    Columbus, Ohio
    Ratings:
    +7,916 / 1 / -0
    #3 Metalman, May 7, 2010
    Ahhhhh......... Do a save......... Then a backup.......... Then cross your fingers :lol::lol::lol:
     
  3. RonsMinnie

    RonsMinnie New Member
    Lifetime Supporter

    Jul 28, 2009
    449
    5
    0
    Sugar Land, TX
    Ratings:
    +5 / 0 / -0
    #4 RonsMinnie, May 7, 2010
    Then check that the backup is good!
     
  4. lotsie

    lotsie Club Coordinator

    May 5, 2009
    3,922
    401
    83
    stagehand/part time detailer
    Right here
    Ratings:
    +401 / 0 / -0
    #5 lotsie, May 7, 2010
    I will never catch-up to Blimey's post count if we lose data again:nonod::lol:.

    Thanks for the heads up, and keeping things running great Nathan:Thumbsup:

    Mark
     
  5. Nathan

    Nathan Founder

    Mar 30, 2009
    25,144
    10,052
    113
    Writer
    Short North
    Ratings:
    +10,069 / 0 / -0
    #6 Nathan, May 7, 2010
    Last edited: May 7, 2010
    Not to worry, backups are the first order of business after I turn off access. After being verified, then work shall commence.

    Now for the geek part...

    We did figure out exactly what caused the previous loss of data. Besides the production site there is a test site, both run off a different database. Somehow a line was added to a config file to point the production site to the test database during the migration. This was not found before as it was not in an area of the config file where one visits often. When I ran a script the copy the production db and rename to the test db it did so, however the site had been running for ~1.5 months on the test db. The script did the right thing but with the wrong data.

    To fix this the plan is to bring the site down, back everything up, move the back ups to the desktop and verify. Once verified the config will be edited to point to the proper location again and the test db will loaded to production. This will also fix an issue where we lost a sponsor or two from the directory. In fact, when trying to figure out that issue we found the db naming issue.

    Mystery of why the data was lost in the Great Data Debacle of '10 solved.
     
  6. lotsie

    lotsie Club Coordinator

    May 5, 2009
    3,922
    401
    83
    stagehand/part time detailer
    Right here
    Ratings:
    +401 / 0 / -0
    #7 lotsie, May 7, 2010
    ^^^ Say what:crazy::lol:

    Mark
     
  7. docv

    docv Well-Known Member
    Lifetime Supporter

    Aug 30, 2009
    818
    280
    63
    moble auto paint tech ( PTU )
    Central Missouri
    Ratings:
    +280 / 0 / -0
    #8 docv, May 7, 2010
    Too geeky for my dusty mind to wrap around, I'm from the tube genaration..:lol:
     
  8. Metalman

    Metalman Well-Known Member
    Lifetime Supporter

    Sep 29, 2009
    12,714
    7,659
    113
    Ex-Owner (Retired) of a custom metal fab company.
    Columbus, Ohio
    Ratings:
    +7,916 / 1 / -0
    #9 Metalman, May 7, 2010
    OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOkay, I was thinking that was the problem all along. Yep, that's it. we're good to go. I can sleep tonight now.

    Good luck Nathan:Thumbsup:
     
  9. versus

    versus Active Member

    Sep 8, 2009
    553
    87
    28
    North Carolina
    Ratings:
    +87 / 0 / -0
    #10 versus, May 7, 2010
    :eek:ut: Nathan, I'm glad you understood what you just said because I sure didn't, and I like to think of myself as a geek at times. +1 for you on keeping M/A ship shape. :Thumbsup:
     
  10. Nathan

    Nathan Founder

    Mar 30, 2009
    25,144
    10,052
    113
    Writer
    Short North
    Ratings:
    +10,069 / 0 / -0
    #11 Nathan, May 8, 2010
    Ok, that went very well. Took the site down a few minutes before 10AM CT and we made the changes needed. Site back up as of 10:07AM CT.

    Didn't lose anything either. :cornut:
     
  11. lotsie

    lotsie Club Coordinator

    May 5, 2009
    3,922
    401
    83
    stagehand/part time detailer
    Right here
    Ratings:
    +401 / 0 / -0
    #12 lotsie, May 8, 2010
    About 10 minutes ago the site was down, now it's back up. Does that mean everything went OK?

    Mark
     
  12. lotsie

    lotsie Club Coordinator

    May 5, 2009
    3,922
    401
    83
    stagehand/part time detailer
    Right here
    Ratings:
    +401 / 0 / -0
    #13 lotsie, May 8, 2010
    Guess I posted just as you did:lol:. Good to hear it went well, so none of us will be vellicating waiting for the site to come back:Thumbsup:

    Mark
     
  13. Metalman

    Metalman Well-Known Member
    Lifetime Supporter

    Sep 29, 2009
    12,714
    7,659
    113
    Ex-Owner (Retired) of a custom metal fab company.
    Columbus, Ohio
    Ratings:
    +7,916 / 1 / -0
    #14 Metalman, May 8, 2010
    Way to go Nathan:Thumbsup: