The official Docker mariadb image will run all *.sh and *.sql scripts in its /docker-entrypoint-initdb.d directory automatically when it starts. Table of contents: 1. Create an init.sql 2. Run an init script for Docker MariaDB 3. Access the MariaDB running container 4. References Technologies used: Docker 24.0.5 Official Docker mariadb image (latest tag) 1. Create […]
This article shows how to use Docker to run MariaDB as a container. Tables of contents: 1. Run MariaDB as a container 2. Specify the MariaDB version 3. Access the running MariaDB container 4. MariaDB Persistent Storage with Volume 5. Access the MariaDB container log 6. Stop the MariaDB Container 7. Start the MariaDB Container […]
This tutorial shows you how to install MariaDB on Debian 11. Table of contents: 1. Install MariaDB 2. Verify MariaDB 3. Secure the MariaDB 3.1 Enter current password for root (enter for none): enter 3.2 Switch to unix_socket authentication [Y/n] n 3.3 Remove anonymous users? [Y/n] y 3.4 Disallow root login remotely? [Y/n] y 3.5 […]
In the terminal, we can type mariadb -V (uppercase V) to display the current MariaDB version installed on the server. Terminal $ mariadb -V mariadb Ver 15.1 Distrib 10.5.19-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper The above output show MariaDB version 10.5.19 is installed on the server. Server System Variables Alternatively, we can connect to […]
This article shows a shell script to backup or export a MySQL / MariaDB database, gzip the exported file, and upload the gzipped backup file to Amazon S3. Table of contents 1. Install AWS CLI 2. Backup MySQL/MariaDB database to S3 (Shell Script) 3. How to run the backup script? 4. Run the backup script […]
