Command Snips

For infrequent things I tend not to remember off the top of my head.

Shell

Linux Kernel CPU Reset

 echo 1 > /proc/sys/kernel/sysrq
 echo b > /proc/sysrq-trigger

Date String Stamp

`date '+%Y-%m-%d-%Hh%M'`

• For Example:

mysqldump ... > bleh.`date '+%Y-%m-%d-%Hh%M'`.sql 
zfs snapshot -r tank@copec-snap_`date '+%Y-%m-%d-%Hh%M'`

Lock gnome >3.8 remote

DISPLAY=:0 dbus-send --type=method_call --dest=org.gnome.ScreenSaver /org/gnome/ScreenSaver org.gnome.ScreenSaver.Lock

Re-Mount / RW (I always forget the exact syntax...)

• Might want to add standard mount options to the "-o" like "discard" or "noatime"

mount -o remount,rw /

MySQL

Create New Database and User

For database 'new_db_name' and user 'new_user':

mysql --defaults-file=/etc/mysql/debian.cnf 
CREATE DATABASE new_db_name;
CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'good_password';
CREATE USER 'new_user'@'%' IDENTIFIED BY 'good_password';
GRANT ALL PRIVILEGES ON new_db_name.* TO 'new_user'@'localhost';
GRANT ALL PRIVILEGES ON new_db_name.* TO 'new_user'@'%';
FLUSH PRIVILEGES;

Update User Password

SET PASSWORD FOR 'username'@'%.example.com' = PASSWORD('good_password');

Mysqlchecks

mysqlcheck --all-databases --repair
mysqlcheck --all-databases --optimize

Dumps

• For human consumption:

mysqldump --defaults-file=/etc/mysql/debian.cnf --skip-opt <databasename>

Binary Logs

• Purge all logs:

PURGE BINARY LOGS BEFORE now();

• Disable logging: /etc/mysql/conf.d/mysql_skip_log_bin.cnf:

[mysqld]
skip_log_bin

OpenSSL Testing

• https://easyengine.io/tutorials/mail/server/testing/smtp/

RAID

mdadm --create --verbose /dev/md0 --level=1 --raid-devices=2 /dev/sda2 /dev/sdb2
mdadm --detail --scan >> /etc/mdadm/mdadm.conf

Mirror Website

wget --mirror --convert-links --adjust-extension --page-requisites --no-parent http://example.org

Systemd

• Flush DNS cache using the systemd stub resolver:

systemd-resolve --flush-caches
systemd-resolve --statistics

MacOS

• https://apple.stackexchange.com/questions/48502/how-can-i-permanently-add-my-ssh-private-key-to-keychain-so-it-is-automatically

Linux kexec reboot

alias kreboot="echo Loading kexec; kexec -l /vmlinuz --initrd=/initrd.img --reuse-cmdline; echo Rebooting; kexec -e"