Backup database

Backup is an absolutely vital part of a sound disaster recovery strategy. Using the Backup database feature, you'll get your ERA database backed up and stored in MySQL backup file named era-backup.sql located in the root folder.

icon_details_hoverNOTE

An alternative to database backup is to create snapshots of the VM. It will preserve whole ERA VA, all it's settings as well as ERA database. However, if you restore a snapshot of your VM, you need to run Reset after snapshot revert.

validation-status-icon-warning IMPORTANT

We recommend you to backup your ERA database frequently and save the backup file on an external storage. This is important because you'll have a copy of the whole ERA database stored elsewhere (not locally on your ERA VA) should a disaster happen. For example in case your ERA VA gets broken, deleted or otherwise destroyed. Having a recent ERA database backup, you'll be able to restore ERA VA to the same state it was in not long before the disaster. For detailed procedure see ERA VA disaster recovery.

1.Enter management mode by typing your password and pressing Enter twice. Select Backup database using the arrow keys and then press Enter.

backup_db

2.You will be prompted to type in your database root password before the database backup can begin.

icon_details_hoverNOTE

If you do not remember database root password, you can change it and run the database backup again.

backup_db_02

This process can take anywhere from a few seconds to a few hours depending on the size of your database.

icon_details_hoverNOTE

Always check screen for errors. If there are error messages, the database backup cannot be considered successfully completed. Try running Backup database again.

You'll find the database backup here: /root/era-backup.sql

validation-status-icon-warning IMPORTANT

Download the backup file using Webmin File manager to a safe location.