MariaDB: Using MariaDB CLIs (mysql, mysqldump, etc.)

This documentation is part of the Advanced usage guide. You can view the complete guide here: How to configure, optimize, export, or import MariaDB data.

👋 Welcome to the Stackhero documentation!

Stackhero offers a ready-to-use MariaDB cloud solution that provides a host of benefits, including:

• Unlimited connections and transfers.
• phpMyAdmin web UI included.
• Effortless updates with just a click.
• Optimal performance and robust security powered by a private and dedicated VM.

Save time and simplify your life: it only takes 5 minutes to try Stackhero's MariaDB cloud hosting solution!

MariaDB command-line tools such as mysql and mysqldump are essential for tasks like importing or exporting data.

Running these tools inside a Docker container simplifies setup, especially if you prefer not to install software directly on your computer.

If Docker is not part of your workflow, no problem! You can try Code-Hero on Stackhero instead. Code-Hero is a complete development platform that runs directly in your browser, so there is no need for local installation. Discover all its features and get started in just a few minutes by visiting Code-Hero on Stackhero.

To get started with Docker, you can launch a MariaDB container with the following command:

docker run -it -v $(pwd):/mnt mariadb:<MARIADB_VERSION> /bin/bash

Replace <MARIADB_VERSION> with the specific MariaDB version you need. If your application uses MariaDB version 10.11.6-0 on Stackhero, for example, you can use version 10.11.6 (just omit the -0 suffix).

Once your container is running, you can check your connection with:

mysql -u root -p -h <XXXXXX>.stackhero-network.com -P <PORT>

When the container starts, your current directory is mounted to /mnt inside it (thanks to $(pwd):/mnt). This means any files in your current directory on your computer will be accessible in /mnt inside the container. For example, to back up a MariaDB database to your machine, run this command inside the container to save the backup as /mnt/<DATABASE>.sql:

mysqldump -u root -p -h <XXXXXX>.stackhero-network.com -P <PORT> <DATABASE> > /mnt/<DATABASE>.sql