Question

Mysqldump on Cloud App server

In order to do my backups, I have to make a dump of the database and upload it to my Space. However, I’m struggling to figure out, how to install mysqldump?

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

App Platform works a bit differently than droplet. It runs each component of your application as a separate, ephemeral container on the platform. When a container is unhealthy or updated, we launch a new instance and destroy the old. To that end, we don’t recommend installing tooling on running containers. You could also use a Dockerfile to build an image which combines mysqldump and your application, though we generally would recommend running this type of maintenance in a separate container.

Scheduled job containers are on our roadmap, and would be the right type of component for running periodic, scheduled backups. For this, we’d recommend using a Dockerfile to build an image which includes your back up script and mysqldump. The mysql docker image could be a good base (FROM) image for this specialized short-lived container.

Until we release schedule jobs, we’d recommend doing manual backups locally or from a droplet.