Lowercase in VIM

Want to lowercase an entire section in VIM?

Use: gu<movement>

So, from cursor to end of line: gu$

From cursor to begining of line: gu^

For uppercase, same thing, just: gU<movement>

---

Command Line Fu - MySQL - find last update per database

Want to find the last time a database was updated?

SELECT MAX(UPDATE_TIME), TABLE_SCHEMA as last_update from information_schema.tables GROUP BY TABLE_SCHEMA;

---

Livereload JS Snippet

Just a snippet to keep handy for livereload.

    <script>document.write('<script src="http://' + (location.host || 'localhost').split(':')[0] + ':35729/livereload.js?snipver=1"></' + 'script>')</script>

---

Command-Line Fu: mysqldump | gzip one-liner

Quick MySQL / gzip one-liner for backups, including current date/time filename

For reference, here’s a quick MySQL and gzip one-line terminal command, useful for a scheduled backup

/usr/bin/mysqldump --opt -u <username> -p<password> <DATABASE> | gzip -9 > /data/backup/sql_backup_`date +'%Y%m%d%H%M'`.sql.gz

Notes:

• gzip -9 is maximum compression
• date is in the ‘201801011355’ format (where current date is January 1st 2018 at 1:55pm)

---