7374756666

Articles in the Scripts category

Setting all MySQL autoincrement values to next value

I recently had to migrate multiple MySQL databases using AWS DMS which only does the bare minimum of schema support. (Tip create the schema manually and then import the data …

Automatically fsck motioneyeos data partition on boot

One of my motioneyeos cameras was stuck in a boot loop due to a corrupt /data partition. The usual kernel fsck parameters didn't work so I modified /etc/init.d …

Fixing immediate wake from sleep on a Mac Book Pro 2015

I have a late 2015 Mac Book Pro running KUbuntu (19.10 at time of writing).

When closing the lid or choosing sleep from the KDE menu it will wake …

A script to convert an entire MySQL/MariaDB charset from one charset to another

I recently had to add emoji support to a site which used the utf8 charset on a MariaDB 10.1 server.

To do this I needed to change the charset …

Optimizing images for Google PageSpeed Insights

Google Page Speed Insights often advises to optimize images to reduce the page size, this is often easier said than done especially for sites that allow user uploads such as …

Making Ubuntu the default boot option on a dual boot Mac

I have a late 2015 Mac book pro with Ubuntu 16.04 Mate as the default OS and Mac High Sierra as the secondary OS.

When upgrading to High Sierra …