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 – – –