Are you wondering how to  backup MySQL to DigitalOcean Spaces? Our DigitalOcean Support team is here to lend a hand with your queries and issues.

Backup MySQL to DigitalOcean Spaces

Basically, with SimpleBackups, you can backup MySQL database to any cloud storage provider.

Today, let us see how to configure your MySQL backup and store it on DigitalOcean Spaces.

1. Create your DigitalOcean Spaces

• Sign in your DigitalOcean account
• Create a new “Spaces” using the create menu at the top right
• Fill in the “Create Spaces” form
• Pick the region you need (think about GDPR rules, if you’re an EU company)
• Select “Restrict File Listing”
• Pick a name you like and link it to your DigitalOcean project (doesn’t really affect us)

  That’s it! Your DigitalOcean Spaces is now created.

Don’t leave the DigitalOcean interface, we’ll now have to create your credentials.

Information you’ll need in step 3:

• Your “Spaces” name, in this case “myacme-space”
• Your “Spaces” Region, in this case “San Francisco 2”, which you can also see in your DO Space url

2.Create your DigitalOcean Credentials

Getting your DigitalOcean Spaces setup was easy and so will be getting your credentials.
We’ve covered how to get this done in a how to create a DigitalOcean Spaces credentials.

3.Connect your Space to SimpleBackups

• Log into SimpleBackups and head to the connect your storage page
• Pick “DigitalOcean Spaces” as storage provider and fill in the “Connect your storage” form with the information from step 1 and 2.

You’ll have to input :

• Key: Key described in (step 2)
• Secret: Secret described in (step 2)
• Region: Spaces region described in (step 1)
• Bucket: Spaces name described in (step 1)
• Give your storage a name (usually we like to use the Spaces name) and click on “Save new storage”.

You’ll be redirected to the list of storage where you’ll find your newly connected storage.

4.Final step: Create your MySQL backup

Let’s now go to SimpleBackups and get that backup configured.

From this screen you’ll be able to configure what data you’re backing up (MySQL in this case), where you want it to be saved (in this case your DigitalOcean Space), and how often you want this to be done.

Conclusion

To conclude, our Support Engineers demonstrated how to backup MySQL to DigitalOcean Spaces.