Find the collation of all tables within a mysql database

Needing to find a collation of a mysql database for a migration I went to google. Found several options, but the best was one from stack overflow. This will output something like: The first part of this shows the overall database collation. In this case, it is utf8_general_ci. Then the second part shows the collation Read more about Find the collation of all tables within a mysql database[…]

How to specify specific engine in Laravel 4 migration

Earlier today I needed to set up a specific database engine for a mysql table that wasn’t the databases’s default. In this instance, the default was INNODB and I needed it to be MyISAM. We could discuss the reasons why I shouldn’t use MyISAM but in this instance that’s what I needed. It’s fairly straight Read more about How to specify specific engine in Laravel 4 migration[…]

Using xargs to parallel a process in the command line

Most of us have multiple CPUs in our personal machines. I would also hope that your servers do too. If you’re running an intensive command line process, running them in parallel will speed it up by paralleling the process. Say you need to find a string in all of your log files. On any server Read more about Using xargs to parallel a process in the command line[…]