You may need to schedule an automated database backup that will recur periodically. To do this, first of all, you will need to create a project file, containing backup settings. Once the project file is created, you have to schedule Windows task that will perform actions at a specific time or when a certain event occurs.
In the Database menu, select Backup and Restore, and then click Backup Database. Database Backup Wizard opens.
On the General tab of the wizard, specify Connection, Database, Path, Output filename. Click Next.
On the Backup content page, select database objects to backup. Click Next.
On the Options page, specify detailed options of how the backup should be performed. Click Next.
Set the Errors handling and Log settings options. Click Save Project.
Enter path to the schemacompare.com file in Program/script (The default path is C:\Program Files\Devart\dbForge Schema Compare for MySQL\schemacompare.com
).
Also, make sure to specify arguments in the Add arguments field as follows:
/backup /connection:"User Id=root;Host=db;Port=3309;Database=sakila;Character Set=utf8;" /projectfile:"C:\Users\Documents\dbForge Schema Compare for MySQL\Export\sakila.backup"