Here's one of the side projects I've been working on, it's called "Girls hitting themselves in the head with pillows repeatedly in broad daylight on the I-94 exit ramp during rush hour." I bet you can't guess what it's about???

Sorry it's so short, but I can't let the project leak out before it's ready. This is going to be a masterpiece!!!

Often times people are faced with the cumbersome task of moving an entire database from one environment to another, usually by creating a dump file of the database, moving it across from one database server to another, and re-running the script on the destination. This is irritating in that it requires one to create a file that is immediately disposed of, and to transfer that file one or two times over the wire. It is also prone to error in that it entails many distinct steps that each have their own glitches or mistakes to make. The good news is that the easy, one-step solution exists in a product you just haven't tried yet.

Sometimes Magento Community Edition version 1.7.0.2 (and perhaps other versions) throw an error when you try to use the built-in product export feature. I've been able to find the particular product SKU's in my catalog that are causing the export routine to bomb, but I couldn't for the life of me figure out what was wrong with these records. I could not trace a specific condition back to the problematic records for something to blame, such as simple versus complex product types, attribute sets, funky characters or encoding, missing values - nothing. It seemed as if there was some sort of invisible problem with certain records that would cause the product export to fail.

I looked in the exception log and saw this super-helpful error message:

Disable translation cache.

Are you seeing tons of impressions but only five clicks per day in your Google Analytics graphs? Millions of people every day load up their Google Analytics dashboard and congratulate themselves for ranking number-one or in the top-ten for a specific keyword, thinking they've made it - they are now the "King of the Internet" for that keyword. What nobody seems to understand yet is that Google has gotten very smart in their ripe old age at "gauging" your website and testing you at how much people care to visit your site. Proof of this is when you see yourself ranked really high for a spectacular keyword that is getting a phenomenal number of clicks across the web every day, but then you go into your "Queries" tab and see that you're getting only five clicks regardless of how many impressions you are getting!