Category: SQL

How to recover you blog posts!

Paul2 Replies

Source: singingthroughtherain.com via Kathryn on Pinterest Source: singingthroughtherain.com via Kathryn on Pinterest

If I’d Only backed up!

That’s probably what you are thinking right now. Most hosting providers like Hostgator will allow you to backup your content for free but do we ever really do that every week. I’ve learned my lesson on this because of what happened last week. Let’s go back in time shall we!

The Back story.

After some really hard considerations with both my tech-linkblog site and this site, I recently decided I need to merge them into one BIG site because I felt that the ones who were coming to my old site were not really seeing the potential of my new site. So After searching bing on how to merge two domains, I found some articles that would help me do that!

I started off merging!

Yep you guessed it, I thought why would I need to worry about having backups when all I am going to do is merge two different databases into one. The Problem with that is that you never quite understand that doing that is a risky situation and thus you won’t know how to fix it until it is too late. That is where we come to this article for. I lost like 100 articles that were REALLY important I don’t say that lightly, people who have websites for SEO traffic know all to well the importance of some BIG articles. I’m no exception because it helps your ranking and Authority.  These articles actually are the ones that bring in some good links and even helps support my blog.  So you can imagine how I felt and my horror when I found out some of my blog entries were GONE and couldn’t get them back!!

How did I get my blog posts back?

You’re probably wondering how I got some of my really important blog posts back.   I know your really curious as to how I got them back without a backup.    In this article I will give you two or three sites that can help you get your blog posts back, but remember it is going to be a long process.   If you had a lot of blog posts then you may never get all the back but you can at lease get some of them back.     Before i begin though, I must tell you that if you are worried about your hard drive you should try Crashplan [Affiliate Link], they give a free trial and can run on Windows/Mac’s/and Linux. I don’t want anyone loosing their Photos, Videos, or Anything else that is important to you.

Google Cache

If you can grab the cache page before it gets erased then you can use that to replace the content that you’ve lost.  You’ll have to search for it then once you find it, just click the Cached link.   It however isn’t going to be a good solution if everything get’s removed.   Nothing in the article will prevent that unless you do a complete restore and thus you need to keep backups.

Now this is good to point, if you use the Internet Archive, but remember they will not index all your pages and if you only have excerpts on your home page then you really can’t use this service but it is something to consider if your do have one or two posts that might need to be replaced.

I however think if your are smart, to have your web hosting provider like Hostgator to keep backups.   That is why I like Hostgator when the next time I have a problem with my SQL database it will be backed up with Hostgator and all is good!

If you don’t have a backup, you should start backing up and if you have a back up then you need to come up with a good restoration plan for when you need it.   I’ve begun to do that with this site and I hope this helps others with the problem I have had!

Paul Sylvester

Related articles

Microsoft issues Vista patches out of Monthly Patch Cycle!

Paul3 Replies

KB957321,KB959108,KB959130


Microsoft issues Out of cycle patch for Vista.   These patches are as Followed:
[ad#ad2-right-1]

Kb957321

An update rollup is available for the Microsoft Windows Imaging Component (WIC) in Windows Vista or in Windows Server 2008. This update rollup resolves the problems that are documented in the following articles in the Microsoft Knowledge Base:

954708 An update to add support for the serialization of complex Extensible Metadata Platform (XMP) data types in the Windows Imaging Component

945060 There may be inconsistencies in the Extensible Metadata Platform (XMP) and Exchangeable Image File (EXIF) values for an image file in Windows Vista and in Windows XP

KB959108

The Windows Portable Device (WPD) API collects and transfers Software Quality Metrics (SQM) data to Microsoft servers. The SQM data is collected only on an opt-in basis through the Microsoft Customer Experience Improvement Program. An update is available that disables the collection and transfer of SQL data to Microsoft servers.

This update affects Windows Vista-based computers, Windows Vista Service Pack 1 (SP1)-based computers, and Windows Server 2008-based computers that are in the Microsoft Windows Media Player Customer Experience Improvement Program.

KB959130

On a Windows Vista-based computer or on a Windows Server 2008-based computer, you install a third-party Web browser. You set the third-party Web browser as the default Web browser. Then, you run the Connect to the Internet Wizard. However, if you select the Browse the Internet now option, Windows Internet Explorer starts instead of the third-party Web browser that you set as the default Web browser.


[ad#ad2-right]This seems to be not so important.  All of these are not really security related but it does surprise me that Microsoft wanted to release these out of Cycle.   If your planning on using your Vista laptop during the holidays you might want to update your vista machine before you go.  I don’t think there is going to be any major issues with this but if there is, you can always remove these updates later.