Dietrich Rordorf rordi

MariaDB / MySQL Cheatlist

Import a dump file:

mysql -u userName --password=yourSecret dbName < ./path/to/dump.sql

Run command non-interactive:

mysql -u userName --pasword=yourSecret dbName -e 'SELECT * FROM my_table;'

Change root password in MariaDB Docker container running with docker-compose

Override the entrypoint in docker-compose.yml for the MariaDB Docker container by adding:

entrypoint: mysqld_safe --skip-grant-tables --user=mysql

The start up the Docker Compose stack:

$> docker-compose up -d

Commands to get basic info about a git commit

Deploy Timestamp: date +"%Y-%m-%d %H:%M:%S"
Git Repo: basename `git rev-parse --show-toplevel`
Git Branch: git rev-parse --abbrev-ref HEAD
Git Commit Long Hash: git rev-parse HEAD
Git Commit Short Hash: git rev-parse --short HEAD

Tensorflow & Keras in RStudio on Apple M1 or M2 (arm64) Chips

The problem is not M1 or M2 (arm64) chipset. The problem is keras installation that installs tensorflow-metal, which makes Keras to choose GPU over CPU, even if Sys.setenv("CUDA_VISIBLE_DEVICES" = -1) is set. However, Apple's GPUs are not supported yet by tensorflow-metal. Thus, we have to get rid of tensorflow-metal! Combined with R / RStudio, the trick is to use a dedicated r-reticulate environment to run python and to manually uninstall tensorflow-metal again, which is installed automatically whenever we install and load the keras package in R.

Install Anaconda for arm64 first: https://docs.anaconda.com/anaconda/install/mac-os/

	<?xml version="1.0" encoding="UTF-8"?>
	<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
	<plist version="1.0">
	<dict>
	<key>Ansi 0 Color</key>
	<dict>
	<key>Alpha Component</key>
	<real>1</real>
	<key>Blue Component</key>
	<real>0.35364818572998047</real>

	<?php
	/**
	* Configuration hardening for PhpMyAdmin
	*
	* This file is included at the end of the main PhpMyAdmin configuration file. We thus here override
	* any potential config value that was previously set.
	*
	* @author Dietrich Rordorf
	* @date 2018-11-05
	* @see https://docs.phpmyadmin.net/en/latest/config.html