Many thumb drives are formatted with FAT32, making the maximum file size just shy 4GB. If you need to copy a large file like this to a thumb drive, follow the instructions below.

Read More

First, you should check to be sure that you have the same wireless card (BCM4306 rev 02) that I do using the lspci command:

Read More

SELECT
  CONCAT(table_schema, '.', table_name) AS tableName,
  CONCAT(ROUND(table_rows / 1000, 2), ' Thousand') AS numberOfRows,
  CONCAT(ROUND(data_length / ( 1024 * 1024 ), 2), ' MB') AS dataSize,
  CONCAT(ROUND(index_length / ( 1024 * 1024 ), 2), ' MB') AS indexSize,
  CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 ), 2), ' MB') AS totalSize,
  ROUND(index_length / data_length, 2) AS indexFraction
FROM information_schema.TABLES
ORDER  BY data_length + index_length DESC
LIMIT  5;

Read More

Ever wanted to know how to add a WordPress administrator from the command line? Here’s how to do it…

Read More

As a Systems Administrator, I often need to find out which version multiple websites are on. With Linux, this often can be achieved with a surprisingly quick one-liner:

Read More

Earlier this week, a couple of co-workers and I somehow got onto the topic of school songs.

Read More