On 5/8 at approx 10AM CT Motoring Alliance will be down for hopefully no more than a few hours to fix some odd database issues that cropped up during the migration back in January. Thanks for your understanding and continued support, Nathan
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 Mark
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.
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
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.
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:
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 Mark