Swiss Mac User 
  • Header Image

    Category: MySQL

    Dive into MySQL, the open-source relational database management system essential for managing and organizing data.

Blog posts

Symbolic visualisation of the migration path from MAMP to Docker on macOS

Make the switch from MAMP to Docker: how to migrate existing web projects

Guide & examples for a successful transition for local web development on Mac.

Oliver 22. March 2023
  • 4.8K
  • 2
Symbolic screenshot showing the Docker Logo and dotenv database connection variables

Docker on Mac: how to automatically resolve another service’s IP and add it to the .ENV

With two simple commands in docker compose

Oliver 29. December 2022
  • 903
  • 0
MySQL 5.7 Logo

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.

[…]
Oliver 23. March 2021
  • 6.3K
  • 0
MAMP4 Logo

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”

Oliver 6. January 2017
  • 21.8K
  • 1
MAMP4 Logo

macOS: how-to sync MAMP across multiple devices

In this article I describe, how you can keep a MAMP installation with all web-project files & folders in-sync across multiple Macs with macOS.

Oliver 19. September 2016
  • 13.4K
  • 2
MAMP Elephants

Create a local copy of your public WordPress Blog

Recently I struggled a little with un-publishing my public Wordpress Blog to a local MAMP environment, for local testing purposes, before I apply big changes (as it should be). There are actually some minor things to consider, so you can properly get your Wordpress installation running locally.

Oliver 6. November 2011
  • 2K
  • 0

OS X: Connect to the MAMP MySQL Server via Terminal

When you have installed MAMP (Mac Apache, MySQL, PHP) on your Mac, you may want to connect to it’s MySQL Server using the OS X Terminal.app. I describe here, how this can be achieved.

Oliver 6. November 2009
  • 2.1K
  • 0

Footer widgets

Written with ♥ in Switzerland.
Hero images via Unsplash.

Please read our privacy policy, thank you.