Command Snips

Shell

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';
GRANT ALL PRIVILEGES ON new_db_name.* TO 'new_user'@'localhost';
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>

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