MySQL - Running multiple version of mysql using Docker

In case to run multiple versions of MySQL, we can do in several ways. In this article, I'm going to run MySQL multiple versions using Docker & using MariaDB instead of mysql.

1. Install Docker

since we're going to use docker, of course we need to install docker. Please to follow official documentation by Docker to install on your machine.

2. Run The mysql Version

You can choose between MySQL, MariaDB, or other version. in this case I'm going to use MariaDB, so I need to run this:

docker run -d --restart=always --name mariadb-10.4.20 --env MARIADB_ROOT_PASSWORD=root -p 1042:3306 mariadb:10.4.20

Descriptions:

--detach, -d Run container in background and print container ID
--restart Restart policy to apply when a container exits
--name Assign a name to the container
--env, -e Set environment variables
--expose, -p Expose a port or a range of ports
mariadb:10.4.20 Package-Name:version

3. FAQ:

3.1. How to ByPass password?

try to ssh on the running database by running:

docker exec -it mariadb-10.4.20 bash

then try to move to HOME directory by running

cd

and then add new file called .my.cnf, and the content are:

[client]
user=root
password=root
host=localhost

[mysqldump]
host=localhost
user=root
password=root

3.2. How to Run Execute?

docker exec -it mariadb-10.2.44 mysql

Once you configured 3.1. you don't need to type the password.

3.3. How to Import Database

docker exec -i mariadb-10.2.44 mysql -u user -p database_name < database.sql

Or if you want to have the progress bar whilst importing database, you can use this command: (don't forget to install pv if you don't have this package)

pv databse.sql | docker exec -i mariadb-10.2.44 sh -c 'mysql database_name'

3.4. How to export Database

docker exec -i mariadb-10.4.20 mysqldump database_name > database.sql

If you want to directly compress the file for the output, you can run this: (don't forget to install gzip if you don't have it.)

docker exec -i mariadb-10.4.20 mysqldump database_name | sed -e 's/\sDEFINER=`[^`]*`@`[^`]*`//g' | gzip -c > database.sql.gz

3.5. Remove DEFINER?

sed -e 's/\sDEFINER=`[^`]*`@`[^`]*`//g' -i database.sql

MySQL - Running multiple version of mysql using Docker

Comments

More from this blog

Changing SSH Port on Oracle Cloud Ubuntu: The Complete Guide

Setting Up Local HTTPS with mkcert on macOS

Magento 2 - How to Test Success Page Without Repeatedly Placing Orders

How to Downgrade Magento from Commerce to Open Source Using Opengento's Tool

Fixing Apache’s “Permission Denied: Search Permissions Missing” Error on Linux

1. Install Docker

2. Run The mysql Version

3. FAQ:

3.2. How to Run Execute?

3.3. How to Import Database

3.4. How to export Database

3.5. Remove DEFINER?

Preferences:

Command Palette

Comments

More from this blog

1. Install Docker

2. Run The mysql Version

3. FAQ:

3.2. How to Run Execute?

3.3. How to Import Database

3.4. How to export Database

3.5. Remove DEFINER?

Preferences: