How I lost 120 lbs. and have been able to keep it off

With the end of the year coming up, lots of people are going to start trying to lose some weight. If you're one of them, here are some things that worked for me.

Get the IP address of your VirtualBox guest VM

Make sure you have VirtualBox's Guest Additions installed on the VM and then simply run the following command from your host:

VBoxManage guestproperty get 'CentOS 6' '/VirtualBox/GuestInfo/Net/0/V4/IP'

Subversion log by user name

Ever wanted to know how to get a subversion log by user name? Here's how to do it...

Burning a CD from the command line

Find your CD drive

cdrecord --devices

Burn your CD

cdrecord -v --dev='/dev/sg1' ~/Downloads/ubuntu-12.04-beta1-alternate-amd64.iso

How to split a large file into several smaller files

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.

Get wireless working on a Dell Inspiron 8500 in Ubuntu

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

[email protected]:~$ lspci -vvnn | fgrep 14e4
02:00.0 Ethernet controller [0200]: Broadcom Corporation BCM4401 100Base-T [14e4:4401] (rev 01)
02:03.0 Network controller [0280]: Broadcom Corporation BCM4306 802.11b/g Wireless LAN Controller [14e4:4320] (rev 02)

If everything matches, you should be able to follow the steps below to get wireless working on your laptop.

Find the top 5 largest MySQL tables on your server

  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

Adding an admin user to WordPress from the Command Line

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

Finding version numbers for multiple websites

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:

Colorado School of Mines Fight Song

Colorado School of Mines LogoEarlier this week, a couple of co-workers and I somehow got onto the topic of school songs.

I still had a copy of a small portion of the song from the '' t-shirt that was popular with computer science majors; however, I wanted to find the rest of the song. It took a little digging, but I was eventually able to find a cached copy of the song from the old CSM Alumni site. I thought I would post a copy online to make it easier for anyone else who may be looking for a copy.


Subscribe to TechNickal Solutions, LLC. RSS