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, optimize, export, or import MySQL data.

👋 Welcome to the Stackhero documentation!

Stackhero offers a ready-to-use MySQL 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 MySQL cloud hosting solution!

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

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

If Docker is not part of your workflow, that's absolutely fine. You can check out Code-Hero on Stackhero. This browser-based development platform lets you work directly online, with no need to install anything locally. You can learn 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 need. For example, if you are using MySQL 8.0.36-0 on Stackhero, use 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