Optional - If you have created any scripts, these can be selected to run before the backup (Pre-backup) or after the backup (Post-backup) by selecting them from the given dropdowns.Give the schedule a name - make this something relevant to the backup configured such as "FS, SS & MyS 9pm".You can create multiple schedules for each device, for example if you want Files and Folders to run at 9am but you want Files and Folders, System State and MySQL to run at 9pm. The most convenient method of configuring backups is to set up a backup schedule which will automatically run the backups without requiring you to intervene. If you clear your backup selection after at least one backup has been completed, you will be offered to remove all backup copies of these files from the Cloud. You can click on the name of the data source at any time to be sure all necessary data has been included in the backup selection Once the selection is complete, the MySQL datasource will now show as added and editable. Make the selection for backing up the MySQL databases.Enter the details for an administrator login for the MySQL server.Click Add next to the MySQL data source.Open the Backup tab in the Backup Manager.Launch the Backup Manager for the device.Create the backup schedule to run automated backups.Configuring the backup selection to include MySQL. The type of backup is MySQL version dependent: MySQL versionīackup through the Backup Manager Enabling schedule-based backupsįirst enable schedule-based backups on the backup device by: Hot backups - the MySQL server keeps functioning while a backup session is running.Warm Backups - the MySQL server is locked for write operations for some time while the backup session runs, but is still accessible for read operations.Cold backups - the MySQL server is stopped for some time while the backup session runs it is necessary that no third-party applications should be keeping the database forcibly open at that time.macOS - Backup Manager handles MySQL versions:.Windows & Linux - Backup Manager handles MySQL versions:.The Percona version must be the same as the MySQL server you are trying to backup.On Linux, glibc 2.5 or higher is required.Full permissions (with all privileges) are required to a MySQL database to backup the MySQL data source.MySQL backups depend on VSS Snapshots, so VSS must be available on the system.The MySQL service must be started at the time a backup session starts.Backup Manager must be installed on the MySQL server that you want to back up.It is possible to add multiple MySQL instances to your backup selection (if they are installed on the same machine). Backup Manager offers a backup and recovery service for MySQL databases on all the supported operating systems.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |