Some handy MariaDB commands

MariaDB.md

To run MariaDB in docker (quickly) 🛢

Create a docker volume for MariaDB 🏐

# Make sure to persist the data by creating a volume first
docker volume create mariadb-volume

Run a docker container 🛳

docker run --name mariadb-instance \
  -v mariadb-volume:/var/lib/mysql:Z \
  -e MARIADB_DATABASE=<database-name> \
  -e MARIADB_ROOT_PASSWORD=<password> \
  -p 3306:3306 \
  -d mariadb:latest

To dump a MariaDB database ☔

docker exec <container-name> \
  mysqldump --skip-column-statistics \
  --user <username> \
  --password=<password> <schema-name> > <filename>.sql

To restore from a dump.sql ↩

mysql -u root -p <database-name> < <dump-file>.sql