toolkitbox/mariadb repository overview

# Interactive mode
docker run -it --rm \
  ghcr.io/pabpereza/toolkitbox/mariadb:latest \
  mariadb -h my-server.com -u root -p

# Run single query
docker run --rm \
  ghcr.io/pabpereza/toolkitbox/mariadb:latest \
  mariadb -h my-server.com -u root -pPASSWORD -e "SHOW DATABASES;"

apiVersion: v1
kind: Pod
metadata:
  name: mariadb-client
spec:
  containers:
  - name: mariadb-client
    image: ghcr.io/pabpereza/toolkitbox/mariadb:latest
    command: ["sleep", "infinity"]
    env:
    - name: MYSQL_HOST
      value: "mariadb-service"
    - name: MYSQL_USER
      value: "root"
    - name: MYSQL_PWD
      valueFrom:
        secretKeyRef:
          name: mariadb-credentials
          key: password

mariadb -h hostname -u user -p

mariadb -h hostname -u user -p database_name

mariadb -h hostname -u user -p -e "SELECT * FROM table"

mariadb -h hostname -u user -p database < backup.sql

mariadb-dump -h hostname -u user -p database > backup.sql

mariadb-dump -h hostname -u user -p --no-data database > schema.sql