mysql

Remote MySQL Dump and Local Restore… With Progress!

by  • February 20, 2014 • 0 Comments

Requires zcat and pv.

Dump remote DB to local machine:

[ssh user] = SSH user name

[remote server] = Server hosting the MySQL DB that you want to dump

[remote mysql user] = MySQL user that has read access to the DB

[remote mysql password] = Password for aforementioned user

[remote db] = Remote DB name

ssh -l [ssh user] [remote server] "mysqldump -u [remote mysql user] --password=[remote mysql password] --single-transaction --quick --lock-tables=false [remote db] | gzip -3 -c" | pv > [remote db].sql.gz

Import local dumped DB to local MySQL instance:

[local db] = Local DB name

[local mysql user] = MySQL user that has write access to the DB

[local mysql password] = Password for aforementioned user

zcat [remote db].sql.gz | pv | mysql -u [local mysql user] --password=[local mysql password] [local db]

mac

Mavericks Broke My Apache!

by  • October 23, 2013 • 7 Comments

Note: Instead of doing everything below, you could just restore the backup of your httpd.conf that the Mavericks install created at /etc/apache2/httpd.conf~previous. Wish I knew that 8 hours ago.

Because I like shiny new things, I decided to upgrade to Mavericks (OS X 10.9) last night.  The upgrade finished around 1am, at which point I was tired, so I went to sleep.  I woke up this morning to start my day, only to realize that all of my Apache Virtual Hosts were throwing 403: Forbidden errors.  After a couple hours of chmod, chown, editing conf files and banging my head against the wall, I finally got it working.  So if this happened to you, hopefully the following steps will help.

Read more →

beaglebone black

Kali Linux on Headless BeagleBone Black via OS X

by  • September 13, 2013 • 4 Comments

I recently purchased a BeagleBone Black.  The OS and configuration it ships with is nice and friendly, but I wanted something that I can have real control over.  I went with Ubuntu 13.04 at first, but then I thought about BackTrack, which I quickly realized is now Kali.  And there’s a BBB distribution available.  So after a few days of sleepless nights and lost hair, I present you with my guide to getting Kali Linux working on a headless BeagleBone Black via OS X.

sdxcOne of the first questions I asked myself (and Google) was:  Does the BeagleBone Black support 32 GB microSD cards / SDXC?  I know the SDHC spec says it supports up to 32 GB, but it appears that the 32 GB card I bought is actually SDXC.  At any rate, even though not explicitly stated ANYWHERE (and trust me, I searched), it turns out that the BBB does indeed support 32 GB SDXC cards.  If your 32 GB microSD card isn’t working, it’s likely that there’s a different problem, so read on…

Read more →

tips

Update Gmail Contact/Hangout Picture on Android

by  • June 17, 2013 • 1 Comment

Recently one of my Gmail contacts changed her picture on Google+.  This change came through immediately in the web version of Gmail, but after days it still hadn’t found its way to the contact on my phone.

It seems that the issue is that Gmail (or Android?) doesn’t consider a Google+ picture change to be a change in the contact itself.  In order to get this to flow down to my phone, I simply edited the Notes field in the Gmail (web) contact.  Within seconds the picture (and Notes field) were updated on my device.

Google:  Please fix this.  I shouldn’t have to “touch” a contact when their G+ picture changes.  It should just flow down to all my Googley devices.

tips

Google Now (Android) Home & Work Locations

by  • February 18, 2013 • 0 Comments

google-now-cardsI just moved, and I noticed that all of my Google Now addresses were wrong (i.e. “7 minutes to home” was actually pointing to my old address).  I updated my Google Contact, but it didn’t seem to take.  It turns out you need to go to Google Maps and update it from there.

Click My Places and you should see Home and Work.  Click the downward pointing triangle to the right of each of these, click Edit, and enter your new address.

Google, if you’re listening, this should be more intuitive.  Why don’t those values get pulled from the Google Contact that I’ve identified as me?  Then just propagate those changes outward.