Super Simple Automated MySQL Backups
Select your storage location, run the one-line install command on your server and confirm the auto-detected settings for the database credentials and backup jobs to be created. The whole process can be as simple as 4 clicks and one CLI command.
When creating backups, sensible defaults are used to save time on configuration. If you'd like to change the settings or schedule of your automated backup process, you can edit them individually to your liking.
We offer our own server space for your online backup at a small cost and also support Amazon S3, Google Drive, Dropbox and Backblaze. Our compression enabled backups also help you save on storage space and data transfer times.
Painless server configuration
The installation script automatically installs your SSH Key, software dependencies, detects your user, IP address, SSH port and home directory, then verifies the SSH connection from our servers.
For advanced users who prefer to manually specify server information and not use the script, we support that workflow as well.
A flexible tool for disaster recovery in under 1 minute
Should you need to access a backup database, the recovery process is quick and easy. You can select the backup you want to restore and the server and database name you'd like to restore to.
You can even restore to a different server on your account or to a database that doesn't currently exist. This makes it extremely simple to test previous backups, or to migrate your data from one server to another - especially important if your primary server is damaged or offline.
In essence, Ottomatik is an automated MySQL backup tool. The product has been designed for minimum interventions and maximum peace of mind. Backups run according to schedule going straight from your database servers to the storage of choice with no steps in between. The data undergoes automatic compression and is then uploaded to the storage server of choice. Your protection from data loss is ensured repeatedly, seamlessly and reliably without the need for you to manually export files or manage the process in any way.
All-in-One MySQL Backup Solution
Ottomatik has been designed with all the primary functions needed for robust database management. The setup is uncomplicated, the system automated and needs no monitoring. Set it, forget it and know that it will always be there if and when needed.
Ottomatik is designed to help you save time, protect your data and leverage technology to allow you to focus on making your products great with the reassurance of our MySQL backup utility that simply works.
With this feature you can enable a "quick" option for large tables, skip read-lock on tables and do the entire operation in a single transaction. This ensures the backup’s consistency and saves you time should you need to recover a backup from storage.
Procedures, functions and events
Ottomatik’s MySQLdump job configuration allows you to include database functions, triggers and stored procedures in your backup process as well. You can even include relevant data from the MySQL Event Scheduler if your application and database is using it. This allows the backup to be relevant to the exact processes you use and avoids the headache of reconfiguring these settings when recovering your data.
Point and click restore
When talking about data recovery, speed is one of the important factors. Using the point-and-click restore feature you can easily restore any backup in 3 clicks. You can even restore to a different server and provide alternative connection credentials if you like, allowing you to be flexible with your storage choices across Ottomatik, Amazon S3, Google Drive, Dropbox and Backblaze.
Flush binary logs with backup
This feature will give you a complete "Logical Backup" of your database in the mysqldump file, and a transactional log of all changes that occurred after that via the new binlog. This configuration is a simple checkbox when setting up a mysqldump backup on Ottomatik.