MySQL backup and restore

Scheduled mysqldump backups with point and click backup restore.




AWS S3 folder segmentation

Add your own S3 folder organization at the backup job level.

All or individual databases

Setup an individual backup job for each database for back up all-databases in one job.

Streaming uploads

Choose to stream file uploads to Amazon S3 and bypass writing any data to your local hard drive.


Backup file rotation

Select how many backup copies to keep and automatically rotate files after each job completes.

Use our storage or yours

Get started quickly by storing your backup files on our built-in storage space, or bring your own AWS S3 account.

Configurable options

Configure the backup job with multiple options of how to export your data and structure.

ADVANCED FEATURES



Zero-downtime options

If you need to backup a large database, or a database for a very high traffic website, it may be unacceptable to have a read-lock on tables while the backup is processed. In these situations Ottomatik’s mysqldump zero-downtime options can help. With this feature you can enable a "quick" option for large tables, skip locking and do the entire operation in a single transaction to ensure the backup’s consistency.


Procedures, functions and events

Depending on how your applications use the database, backing up your structure and data may not be enough. Ottomatik’s mysqldump job configuration allows you to include database functions, triggers and stored procedures (1) in your backup as well. You can even include relevant data from the MySQL Event Scheduler (2) if your application and database is using it.

Flush binary logs with backup

If you are making backups of the MySQL Binlogs (and you should be), you will typically want to flush, or start a new binlog after each mysqldump operation. This 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.

Point and click restore

Sometimes once you have a mysqldump backup file, it can be a pain to get that file physically on a server and perform the correct restore sequence via the command line. 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.




Secure your data now
FREE 14 day trial, no credit card required