MySQL: Using MySQL command-line tools (mysql, mysqldump, etc.)

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

👋 Welcome to the Stackhero documentation!

Stackhero offers a fully managed MySQL cloud service that streamlines deployment and management for your production workloads:

• Unlimited connections and data transfers.
• Integrated phpMyAdmin web interface for simplified database management.
• Effortless updates with one-click upgrades.
• Consistent performance and enhanced security on a private, dedicated infrastructure.

With Stackhero, you have a reliable MySQL database ready within minutes. Reduce the time spent on installation and maintenance, and focus on developing your applications. Try MySQL cloud hosting on Stackhero today.

MySQL command-line tools such as mysql and mysqldump are very convenient for importing or exporting data.

A straightforward way to access these tools is to use them within a Docker container. This approach keeps your local environment clean and avoids any manual installation.

If Docker is not part of your workflow, there is no problem at all. You may want to explore Code-Hero on Stackhero. This browser-based development platform allows you to work directly online, with no need to install anything locally. You can find out more and try it out in just a few minutes by visiting Code-Hero on Stackhero.

To get started with Docker, launch a MySQL container with the following command:

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

Replace <MYSQL_VERSION> with the version you require. For example, if you are using MySQL 8.0.36-0 on Stackhero, specify 8.0.36 (without the -0 at the end).

Once the container is running, you can test the connection with this command:

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

Your current directory is mounted to /mnt inside the container (thanks to the $(pwd):/mnt argument). This setup makes it easy to transfer files between your computer and the container. For example, to back up a database to your machine, use:

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