October 11, 2017

Get rid of .DS_Store files from GIT Repo on Mac OS X

Whether you are new to GIT repositories or an experienced developer, I am sure, at some point in using GIT, you must have come across these annoying .DS_Store files that seem to populate out of nowhere. It is a much apparent problem if you have enabled viewing hidden files. What are they? DS_Store is a – Read More-

February 7, 2017

You do not have the SUPER Privilege and Binary Logging is Enabled

Recently while trying to upgrade our project management app, I encountered this error, “You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)”. What we initially thought was the lack of TRIGGER privileges for that MySQL user. But even after giving the MySQL – Read More-

April 18, 2016

Linux/Unix Commands for Unzip GZ Files

GZ is no doubt one of the best choices for database compression. We use it quite often when importing and exporting files. In fact, we recently used it for migrating our MySQL databases to Amazon RDS. To extract a GZ file, use Gunzip command: gunzip file.gz If that had no success, try this: gzip -d – Read More-