Posts

Showing posts from August, 2019

MySQL Export: One Table per File

Way to save a gzipped SQL dump of each table individually. Sometimes it’s useful to have separate table backups.

Magic with nginx geo and autoindex on/off

Image
Long story short: Nginx does not support .htaccess , which can be a problem when you want to restrict autoindex to specific IPs.

/var/run/mysqld not present after reboot

Symptoms: MySQL starts correctly after installation, but fails to start after the first reboot because it cannot create the PID/socket in /var/run/mysqld .