How to backup MySQL to SimpleStorage

MySQL database backup stored in your SimpleStorage account.

Let's see how we can easily schedule MySQL backups and store them on SimpleStorage.

SimpleStorage is our backups storage solution included in all our paid plan. SimpleStorage leverage AWS S3 behind the scene, so your data will be hosted on Amazon data centers (you have the choice between the US and Europe for where to store your backups).


1. Connect to SimpleStorage

  • Log into SimpleBackups and head to the Connect a Storage page
  • In the storage provider list select "SimpleStorage", and choose a region and input the name of your storage. An then hit on Save Storage button.

Connect SimpleStorage to SimpleBackups

And your storage is now connected!

Storage list with newly created SimpleStorage storage

2. Final step: Create your MySQL backup

Last step is obviously to schedule your backup.

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 SimpleStorage storage), and how often you want this to be done.

FYI this section will be the same, no matter what storage you pick. And that's the beauty of it, if you want to change storage, just select another one from the list (Backblaze, AWS, or whatever you might prefer) and you'll be good to go.

Configuration form, for a MySQL database backup connected to your SimpleStorage storage

What would you like to back up? (A)

  • Select "Database" (in this article we're creating a MySQL backup only)
  • Select the server on which your database is hosted (if you haven't yet configured any server check our "get your server configured" article first)

How often should we make this backup? (B)

  • Select your schedule option (here we picked a daily schedule)

    You can select a pre-defined schedule (daily, weekly, monthly) or a custom option allowing you to schedule it whenever you want to use CRON syntax.

  • Example of CRON schedule for "20:00 every Tuesday" = 0 22 * * 2

    Finally, the "On demand" option won't schedule anything but will allow you to trigger the backup manually or using our API.

  • Define the backup retention, which is the number of backups you want to keep (kind of the history length of your backup if you prefer)

Choose the database you need to backup (C)

  • Select the type of your database, in this case "MySQL"
  • Fill in the database connection form

Finalize and create

  • Pick the name of your backup (this is how it will be displayed in SimpleBackups interface) and where you want to store it.
  • Select your Storage (step 3)

That's it, your MySQL backup is now ready and connected to SimpleStorage.

Run it once manually (using the "Run" backup button from the backups list) and you'll trigger your first backup!

Ready to automate your backups?

Sign up for FREE. Get started in less than one minute.

Secure your backups

No credit card required. Free 7-day trial.