The Database plug-in allows backing up and restoring different databases through the use of standard ODBC (Open Database Connectivity) drivers.
To use the plug-in, you need to have the respective ODBC driver installed on your system.
You may need a 32-bit version of Handy Backup to work properly with some databases, including versions of MS Access etc. To ensure that the plug-in will work properly, please force the 32-bit installation of Handy Backup!
File system of the plug-in is organized as follows:
When you open a folder, the program connects to the respective ODBC data source. If it is for some reason not valid (e.g. if you change a password), the program opens a configuration dialog.
See instructions on adding ODBC data sources below.
To add a new ODBC data source, follow these steps:
Note: The above instructions are valid for Windows 7, and may slightly vary for other systems.
Then you need to configure a data source for your database. For example, the MySQL configuration dialog looks as follows:
The Database plug-in creates files that are named similarly to the names of tables. Each file stores data in a binary format provided by the ODBC connector.
To create a backup task with the use of the Database plug-in, follow these steps:
Next steps are common for all backup tasks and are not specific to the Database plug-in. For detailed instructions on creating backup tasks, refer to Backup Task.
To restore a backup made with the Database plug-in, follow these steps:
For example, if your backups are stored on a local hard disk, then you need to select Computer in the Storage Destinations pane to the left, and then browse for backup.hbi in the Index File Selection pane to the right.
In this dialog, you can uncheck data that you don’t want to restore. At present, backups made with the Database backup plug-in can be restored only to their original locations, and you can’t change it.
In the next steps of the New Task Wizard, you need to specify restoration options and name the tasks. They are not specific to the Database plug-in. To learn more, please see Restore Task.