I ran into a strange situation with WordPress where the MySQL server did not support utf8mb4. I needed to quickly convert the tables back to utf8 to get the site running again. Though this script does work I highly recommend if you are running WordPress that you upgrade your MySQL server to support utf8mb4 for

If you need to convert all the MySQL tables in a database from InnoDB to MyISAM here is a handy script to automate the process for you. [bash] #!/bin/bash DB=’your_database_name’ USER=’your_db_user’ PASS=’your_db_pass’ TABLES=$(mysql -p$PASS -u $USER –skip-column-names -B -D $DB -e ‘show tables’) for T in $TABLES do mysql -p$PASS -u $USER -D $DB -e

If you have need to get rid of a bunch of files that are in your git repo but not yet tracked it can be tedious to do the job one file at a time. Git has you covered with the git clean command. Warning: This is a permanent loss of files. Always use –dry-run

When you add your Google account to an iPhone or CalDAV enabled device by default you will only see events from your calendar. If you someone has shared a calendar with you there is no clear way to make it available on your phone. Google has a tool to enable shared calendars to synch however

This will allow you to quickly and easily select a list of column names from a MySQL table. SELECT distinct column_name FROM information_schema.columns WHERE table_name='{YOUR TABLE NAME}’