pne: Pixels with random colours (random)
[personal profile] pne

I don't know whether this is a bug in PhpMyAdmin or whether I really did something wrong, but I tried to create a stored function in my MySQL database.

Things seemed fine at first; it said it created the function successfully.

But then I quickly found that I couldn't see anything else: just the information_schema database and the database I had created the function in. All of my other databases seemed to be gone. And in the one remaining database, I could only see the function - none of my tables!

Time for panic.

I had a database backup from a while ago, but I wasn't sure whether simply restoring that would work... I could imagine that the problem might be hiding in the mysql database, or in some corner of the database which wouldn't get cleaned properly when just restoring.

So I hoped, and submitted an urgent support ticket to my hosting provider, NearlyFreeSpeech.NET (NFSN), asking them to restore the database from backup - I had read in their FAQ that if you contact them shortly after an "accident", they can sometimes get your stuff back from a recent backup (if you wait too long, the accident gets backed up, too...), and hoped that might apply not just to the file system but also to databases.

And this was on a Sunday morning, US time, well outside the normal support hours. But just a few minutes later, I get a response telling me that the database had been restored from a backup dated about two hours before the problem. So, fresh enough that the new Klingon words I had entered this morning were already present, yet old enough to pre-date the problem. Awesome!

A quick check: things look fine again.

Thank you very much, NFSN support, for saving my day!

(will be screened)
(will be screened if not validated)
If you don't have an account you can create one now.
HTML doesn't work in the subject.
More info about formatting

If you are unable to use this captcha for any reason, please contact us by email at support@dreamwidth.org

Profile

pne: A picture of a plush toy, halfway between a duck and a platypus, with a green body and a yellow bill and feet. (Default)
Philip Newton

June 2015

S M T W T F S
 12 3456
78910111213
14151617181920
2122232425 2627
282930    

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Thursday, 10 July 2025 18:47
Powered by Dreamwidth Studios