MySQL 5.7 set datetime column to NULL from 0000-00-00 00:00:00
How to change a datetime or date column in MySQL to default NULL.
[…]
Continuous download of remote files with «rsync» from the macOS Terminal
A better alternative to «scp» when transferring multiple large files – which continues where it stopped in case of interrupted connectivity.
Fix PHP Warning: session_start() with MAMP on macOS 11 Big Sur
Got a «PHP Warning: session_start() failed: No such file or directory» with MAMP PHP on macOS Big Sur – but found a way to make session storage work again
Starting MAMP MySQL in macOS Big Sur errors «mysql.pid ended»
Solutions how to fix the issue with MAMP on macOS Big Sur Beta that the MySQL service cannot be started – with /tmp/mysql/mysql.pid ended
$ brew doctor «A newer Command Line Tools release is available» but Software Update cannot find it
What to do when Homebrew says «A newer Command Line Tools release is available» – but macOS Catalina doesn’t confirm that?
Live edit texts on any website — a helpful browser bookmarklet
Ever thought it would be helpful if you simply could just change that text on a website, to bring across your point? Well that’s possible – at least temporary: by using a modern web feature, you can basically edit any… Continue reading » “Live edit texts on any website — a helpful browser bookmarklet”
Use this AppleScript for repeating batch file renaming jobs in macOS
A simple AppleScript for macOS to easily batch rename files sequentially to a user specific name.
Unix Bash Shell script to fetch a list of Websites using CURL
This Unix Bash Shell script was designed to fetch a list of website URLs using curl, returning – upon success – the HTTP status code and the final URL retrieved following redirects.
Fix local WordPress updates stuck in Maintenance Mode on macOS with MAMP
When you are running a local copy of Wordpress in a MAMP development environment on your Mac, you might have run into troubles with Wordpress being “stuck” in maintenance mode after trying to update Wordpress (plugins, themes or core updates). In order to fix this – and have your precious Wordpress updates run through smoothly again locally – you can use a chmod-command with the Terminal.app in macOS.
MySQL SQL-dump export & import with MAMP on macOS
In order to export & import an SQL dump using MAMP on macOS, the following Terminal.app commands can be used with the “mysqldump” (export) & “mysql” (import) tools located in MAMP’s /bin/ folder: MAMP MySQL dump export Alternatively – in order to… Continue reading » “MySQL SQL-dump export & import with MAMP on macOS”