Bloggers Nightmare
Open topic | February 25th, 2008 | 7 CommentsAsk any blogger you want that has been blogging for almost a year, or has became addicted to his blog what is his/her worst nightmare he/she will answer you “To get my blog screwed up and my database corrupt”.
Well this nightmare, I dreamed this last week. You have most likely notice the blog going off, showing a fresh new installation, then back again showing all posts and again showing just half post. Well all those were my attempts to recover my blog and have it work as it should.
After I installed the SABRE plugin everything start to act weird. In the admin’s dashboard I was able to see the 404 error page of the blog, and all those messy things. A real mess to be honest, a mess I would never want to have again. My main concern was to keep the database safe and the wordpress theme design. Thanks god I always keep my design works backed on my desktop, pen drive and even in a server uploaded (yeah..too much I know, i should also keep them on emails?:P).
Anyway, I did not had backed up the database for awhile. And as you can notice there are numerous posts dated at 24th February, posts which I could recover manually from the old database as I did not purged.
Now I would not want to blame SABRE plugin, but neither can say it wasn’t really SABRE’s fault. But believe is that something wrong happened with Apache and PHP/MySQL install on the server (since it was moved just 10 days ago). After several emails asking the support staff of the old hosting what exactly is going on since this was affecting all the blogs I have on that same server, answer which I never managed to obtain and after losing already rankings for my homepage and for some other internal pages I decided that I had no more time for their support staff and it was time to move server.
After a small research on the web and after few positive testimonials (and some other bad reviews as well, but that is normal with web hosting companies) I decided to pack my stuff and move over at HostNine. The reasons were mainly two, 1). did not wanted to waste my time any longer and lose all my rankings and 2). the hosting plans with HostNine were (it would be mean to say reasonable) really cheap and the features were exactly what I needed for my seo blog (just In case you have intentions to order a hosting with HostNine, you can use the coupon code H9 during the order and get 50% discount on the first order, this does not recur on next billing. So for example if you order for 12 months hosting you pay only 6 months).
The order was pretty easy and the account was setup after few hours (reasonable time really, but not instant) and I was ready to install the new version of WordPress and use the backup SQL database for all my content and other features. Apparently the backup was not as I expected and there were bugs, mainly..the categories I had were not included in the database so all posts were marked under “uncategorized” category.
Considering the amount of posts the blog has, it would have been a real pain to assign each post to its proper category manually. Then I came to knowledge (Thanks to Google search engine heh) about this really useful plugin for these cases, it is called Batch Categories. With the use of Batch Categories plugin I was able to assign multiple posts at once to the proper category. The options are simple but useful, you can filter posts by title and use wildcards as well. Once the posts are filtered you can check box for the posts you want to assign to a category, and then just click on Submit to category…Done. This plugin saved me a lot of working hours and made everything less stressful than what actually could be doing it manually.
In simple words, SEO Optimization blog was saved, the old hosting company already created doubts to me about their reliabilities after years I have been with them, but will still give them a second chance. This is just what has happened to me during this past week, I struggled much more to save this blog as it sits in my heart and left behind my hands and refused customers during this period, but finally it is saved and rolling again 😉
If you liked this post subscribe to my RSS feed or have the new posts delivered via email in your inbox.
Yep, I got this e-mail. Hopefully this business model change works out well…
It is a drastic change when i saw that it will stop on Feb 20th midnight, but i think the people who didn’t get a chance to get the book missed out on alot. I think aaron is looking for his own financial benefit and i think it will be a smart business strategy to go onto monthly subscribing.
I think something still might be messed up in the DB structure. Your comments are not registering properly. On the front page, for this post, it shows Zero comments however this will actually be the third. Additionally above the comments on this page is says that there are No Comments.
Additionally, just to thwart this all happening to you again I would recommend using the WP DB Backup Plugin found here: http://www.ilfilosofo.com/blog/wordpress-plugins/
You can set it to just compress and email you a backup so it’s completely hands off and at the worst if it all tanked again you’d only miss a day or 2. It can handle extra DB fields too so if you’re running non-standard plugins on your database, that info will be archived too.
Cheers!
Greg you are right, I also believe the previous two comments are of the “SEO Book Changes Business Model” and not to this post.
Thank you for the plugin, I will take a look at it just now. (and will also move the comments to the proper post page)
Only 4 days ago I ftp’d into the wrong account and deleted all the files, the backup was so-so, loads of ongoing changes, now I’m running backwards.
yeah ive read that article too
I have been backing up my site like crazy. Now that i have a site that is doing well i dont want anything to happen to it. How does a database become corrupt anyway?