jonathanstegall

nohup nice mysqldump -uusername -ppassword databasename tablename | gzip -9 > tablename.sql.gz

jonathanstegall

scp username@servername:/path/to/remote/file.ext /path/to/local/file.ext

jonathanstegall

="Insert into `table` (column1,column2,column3) values('" & A1 & "','"& B1 & "','" & C1 & "','" & D1 & "','" & E1 & "');"

jonathanstegall

SELECT count(*) as count, DAY(FROM_UNIXTIME(created)) as day
FROM users
WHERE created >= UNIX_TIMESTAMP('2015-06-22 00:00:00')
GROUP BY day;

jonathanstegall

use DATABASE_NAME;
source path/to/file.sql;

jonathanstegall

.hide-text {
  text-indent: 100%;
  white-space: nowrap;
  overflow: hidden;
}

jonathanstegall

ssh me@myserver.com
screen               #start a screen session
run-a-long-process

CTRL+a , d to detatch from your screen session

exit                 #disconnect from the server, while run-a-long-process continues

When you come back to your laptop:

jonathanstegall

<?php namespace GM\WWWPostThumbnail;
/**
 * Plugin Name: WWW Post Thumbnail
 * Description: Allow to use an external image url as featured image.
 * Plugin URI: https://gist.github.com/Giuseppe-Mazzapica/928bc22e5f49a654cf7c
 * Author: Giuseppe Mazzapica
 * Author URI: https://github.com/Giuseppe-Mazzapica
 * License: MIT
 * Version: 0.1.1
 * Modified by Jonathan Stegall

jonathanstegall

Keybase proof

I hereby claim:

• I am jonathanstegall on github.
• I am jonathanstegall (https://keybase.io/jonathanstegall) on keybase.
• I have a public key whose fingerprint is F8B8 8A81 ABEB ADAF DEAC B6E8 3550 F7E1 B00D D33A

To claim this, I am signing this object:

jonathanstegall

SELECT MONTH(FROM_UNIXTIME(timestamp)) as month, YEAR(FROM_UNIXTIME(timestamp)) as year, count(cid) as comment_count
FROM comments
WHERE timestamp >= UNIX_TIMESTAMP('2014-07-15 00:00:00')
GROUP BY year, month;