Backup Procedure

To back up the Infobright databases, copy the entire directory containing the Infobright databases (usually the data subdirectory in your Infobright installation directory).

The safest methods of ensuring a complete backup of the database is:
1. Shut down the database before making a copy or,
2. Lock the tables and take a snapshot

You can take advantage of incremental backups, since only some of the database files are updated when new data is imported. Be sure to do a full backup occasionally.

Important: Some files in the KNFolder are updated when queries (using JOIN) are run so be sure to back up the KNFolder on a regular basis.

Restore Procedure

To restore the Infobright databases from a backup copy, do the following:
1. Replace the entire data directory (usually the data subdirectory in your Infobright installation directory) with the backup copy.
2. Replace the KNFolder with the backup copy (if the KNFolder is not inside the data directory).

Important: Do not manually modify database files or move them from one database to another—this may lead to data corruption and unpredictable results.