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

This documentation is part of the Advanced usage guide. View the full 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 like mysql and mysqldump are very useful for tasks such as importing and exporting data.

One easy way to access these tools is by running them inside a Docker container. This approach keeps your local setup clean and avoids the need for manual installations.

If Docker is not part of your workflow, this is absolutely fine. You might want to check out Code-Hero on Stackhero. This browser-based development platform lets you work directly in your browser, so you do not need to install anything locally. You can learn more and try it out in just a couple of minutes by visiting Code-Hero on Stackhero.

To get started with Docker, you can spin up a MySQL container by running:

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

Replace <MYSQL_VERSION> with the version you need. For example, if you are running MySQL 8.0.36-0 on Stackhero, use 8.0.36 (leave off the -0 at the end).

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

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

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

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