In this "Getting Started" article, I'll show you how to configure your first MySQL database backup using SimpleBackups.
We'll start as if you had already configured your storage (SimpleStorage, AWS S3, DigitalOcean, Wasabi, Dropbox...) if you don't know how to do this please check our "Get started with Cloud storage for backups".
If you're starting from a fresh account check this article on how to start with SimpleBackups first.
Create your Database backup
Click on "Create backup" from the backups page or access the create backup page directly with this link.
What would you like to back up?
- Select "Database"
- Select the server on which your database is hosted (if you haven't configured your server yet please check this article first)
How often should we make this backup?
- Select your schedule option
You can select a pre-defined schedule (daily, weekly, monthly) or a custom option allowing you to schedule it whenever you want using CRON syntax.
Example of CRON schedule for "22:00 every Wednesday" = 0 22 * * 3
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
Choose the database you need to backup
- Select the type of your database, in this case "Mysql"
- Fill in the database connection form.
Note: In order to backup all databases of your server at once, you'd need a Standard or upper plan
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.
If you haven't configured a storage before check this article.
That's it, your MySQL backup is now ready.
One quick advice, run it once manually (using the "Run" backup button from the backups list).
Don't hesitate to reach out if you have any questions.