Blog
Short guides from our daily work with databases, servers and version control. Every command here is one we use ourselves.
Our German blog holds 48 articles on AI, SEO, e-commerce and web development, including the German version of every guide here: read the German blog.
-
Force HTTPS in .htaccess, with one folder left on HTTP
Four lines of .htaccess redirect a whole site to HTTPS and keep one directory reachable over HTTP. The pitfalls are the prefix match, a proxy in front of Apache and HSTS, which quietly cancels the exception.
Read more → -
WooCommerce: attach your own files to order emails
One filter adds a PDF to WooCommerce emails. How to limit it to single email types, why the same hook also fires for stock notices, and the two mistakes that ship an email with a broken or missing attachment.
Read more → -
Fix: Unknown collation 'utf8mb4_0900_ai_ci' when importing a dump
A MySQL 8 dump will not import into MariaDB or MySQL 5.7. One sed command rewrites the collation in the dump file — on macOS and on Linux — and the import runs.
Read more → -
How to force a git pull and overwrite local files
git pull --force does not do what most people expect. Two commands reset a working copy to the remote branch, and a third removes the untracked files that block a merge.
Read more → -
MySQL binary logs: how to delete them and limit how long they are kept
Binary logs fill up the disk on long-running servers. How to purge them safely, which setting limits their lifetime in MySQL 8 and MariaDB, and why rm is the wrong tool.
Read more → -
How to check the size of a MySQL database and table
Three SQL queries that show the size of all databases, of one database, and of every table in it. Plus why the result differs from the file size on disk.
Read more →
Let's talk about your project.
Free initial consultation, reply within one business day.