My DingBat SQL Moment

Sometimes you can just outsmart yourself. I do this a lot lately. I spend the afternoon deactivating all my plugins, removing all the used widgets, went to the basic default theme, and took a coffee break. I then tried to access my database via the PHPMyAdmin application. Of course, as usual, my yahoo dashboard made me reinstall it again. Once connected to the database I deleted all table entries that were left over from long ago used plugins. So far, so good. I then changed back to the theme I am using, and individually activated on plug in at a time checking if the theme would break in IE. After checking every plugin, every widget, the blog was not broken on IE anymore WOO HOO I am thinking.
.
I read my newsreader feeds and then went back to the blog. Instead of a login page I got the dreaded unable to connect with the database error. Eh? I have not done a thing. Maybe it was a cookie thing so it worked and then when I came back it was broken?
.
Went back to PHPAdmin and guess what – no connect to the database. After much help file reading etc. I came to the conclusion the mysql was just not there.
.
I finally gave up and called the help desk. Usually this is not a good thing – push button – then the next button – hold -listen to awful music – hold – and so it goes. But, this time when I did get a tech they were actually nice – nice and helpful. After I convinced him that I thought the database the actual MySQL was gone he looked and went ugh did you delete it? He said he would have the engineers give me a call in the next 24hrs.
.
Now, I am not wanting to wait no? So I chatted it up with him and finally convinced him that I really wanted the database reset. He was not wanting to do this as it really is a site reset and he thought I would get wacky I am sure if my site went bye bye. I explained and convinced him that I had backups and would not mind restoring everything. Site reset. Passwords verified to work -all is good.
.
I restored my database for WordPress and viewed my site – yeah – it is all there up except maybe a few comments that were left after the backup. Dinner, television, time to write a post. Now I go to log on and it says: no such user password whatevers. …
.
I open the database and find that the tables do not have all the rows like my other sites database – mysteriously missing: user meta data and users. Well, I guess if the database say I don’t exist …..
So, more reading, going nuts, I found an old backup I did that was text and scrolled through a zillion lines till I luckily found the table entries for the missing data. I followed some instructions I found on the net and recreated the entries. Re importing the backup was no joy so I had to do it via the sql quires.
.
All looks good for now except – AUGH the dang theme is broken in IE again – the Gods have spoken – it is gonna stay that way. So get Firefox, Netscape, Chrome, or deal with it LOL.
.
So to Ranehir in India – thank you – you were super – you were the best tech I have ever dealt with. I sent a letter to your boss telling them how great you were too.
.
To Me: how the heck did I delete MySQL???? I think I am turning into a dingbat. Like Edith. And I just noted that all my categories are gone – – – Ding Bat – – –

One Comment

  1. Geez, just reading that makes my head spin. I get befuddled and confused every time I have to do anything to my Blog. So congrats to you (with help from Ranehir in India) for getting the job done. I’m just trying to figure out how to delete all the past posts on my Blogger Reader thingamajig. Over a 1000 entries that I have already read is ridiculous to keep on anyone’s server.

Comments are closed.