In this example we will create the sakila database backup.
To backup the database:
Set up some optional settings such as: append time stamp to the file name, auto delete old files, use compression etc, at your own decision. Click Next.
Select database objects to backup. Click Next.
Specify detailed options on how backup should be performed. Click Next.
Select the Write a report to a log file check box to save the backup process information to a log file. Enter the path where to store the file, for instance C:\Backups\Backup.log.
As soon as the backup process has finished, click Save Project.
A project file contains all the information that you have entered while walkthrough the wizard pages.
To run a backup from the command line:
Type cmd in the Search programs and files text box and press the ENTER button.
To run the Command Line in Windows 8, Windows 10:
From the Desktop Mode
- Move the mouse cursor to the exact lower left corner until the desktop shortcuts menu appears.
- Right-click to see the shortcut menu and than click Run
From the Charms Bar
- Move your mouse to the upper right corner until the Charms Bar appears.
- Select Apps from the list and type run in the search box.
- Click Run from the search results.
Use Windows + R Shortcut Keys
- In desktop mode, press the Windows key and R at the same time to show the Run command line.
Enter the command line as follows: c:\Program Files\Devart\dbForge Studio for MySQL\dbforgemysql.com /backup /projectfile:c:\Backups\sakila.backup. Press ENTER.
After the process ends, a backup file appears in the specified directory.
You can use the Windows Task Scheduler to create and manage backup tasks that your computer will carry out automatically at the times you specify.
To create Windows task:
Run the Windows Task Scheduler.
To run the Windows Task Scheduler:
- Click Start and then click Control Panel.
- Click Administrative Tools.
If your current view is Category, click System and Security, and then click Administrative Tools.
- Click Task Scheduler.