Database Backup
The program features a special plug-in to backup databases that support Open Database Connectivity (ODBC) driver. The most popular ODBC compatible databases are Oracle, MySQL and MS SQL.
Note: The latest version, Handy Backup 7.4.0 has individual plug-ins for MS SQL, MySQL, PostgreSQL, Oracle, DB2 and other. They provide much more accurate results than the ODBC plug-in.
To back up data from databases using ODBC connectivity, follow these steps:
- Launch the New Task Wizard.
- Select Backup Task, and then click Next.
- Click Add to open the shortcut menu. The list of available for backup items will appear.
- Select Database. Data Source Selection window will appear.
- Select File Data Source or Machine Data Source by clicking the respective tabs.
File Data Source is stored as a regular file on your local computer. Machine Data Source is stored as the system source in the System Registry.
6a. On the File Data Source tab, click the Size arrow to select file data sources created earlier on your computer or remote computer. If there are no data sources for your database, create a new one. To learn more, refer to File Data Source.
6b. On the Machine Data Source tab, select the desired data source from the list or create a new machine data source. To learn more, refer to Machine Data Source.
- Select the desired data source, and then click OK. The data from the database will be added to the backup set.
Note: The ODBC plug-in can only back up tables. It cannot back up store procedures, views, functions, triggers etc from the database.
- If you want to exclude one or several database tables from the list, expand the tree panel and uncheck the respective boxes.
- When finished, click Next.
The subsequent steps are identical to usual backup task creation. For more details, refer to Backing up data.
Related Feature Pages