Backup & Restore
Periodic backups are an essential part of running an information database software.
The backup process is described on this document in two levels: Local and External.
Automatic Local Backups (Snapshots)
SpeedBase automatically creates a backup of your database file on a daily basis. Backup files are also stored in the same data folder of your database.
Daily backups protect your data from an unlucky database failure or loss of data due to accidental user action.
They also help you to make some experimental changes on your database with confidence
since you can quickly roll back your database to an earlier state if you are not satisfied with the result.
This type of backup is done silently in the background and you do not have to do anything about this process.
How to Take a Local Backup Manually?
Although SpeedBase takes daily database backups in the background, there might be cases when you need to backup the very last state
of your database manually just before making some critical changes on your database or importing a large amount of data.
To do this, open connection settings window from database menu
and click "Backup Now" button.
How to Restore from a Local Backup?
You may return to an older state of your database. To do this, open
connection settings window from database menu, select the backup file
you wish to restore from the list and click "Restore" button.
Note that, once you restore from an older backup, you will lose all data created/updated after the creation time of backup to now.
Manual External Backups
There are several situations which happen rarely but having daily snapshot backups does not help (e.g. hard drive failures, virus attacks, fire, theft...).
In order to minimize the damage in such conditions, you are recommended to take backups of your data folder to an external media
within reasonable time intervals.
Since SpeedBase keeps all data under a single data folder, it is also the only folder which needs to be simply copied to some physically external media
like a shared folder on your network, flash memory, cd, dropbox etc. You may manually copy the data folder to the backup media or, if you have a backup
software, you can configure it to include your data folder as well during periodic backups.
To find out the location of your data folder, open connection settings from database menu.
The path is displayed in the box labeled as local data folder location.
For maximum protection against viruses or other malicious software, you are recommended to use a backup media that is normally NOT connected to your computer
between backup processes.
Beware that, SpeedBase only takes automatic backups on your local disk. You should remember to (externally) backup your data folder just
as you do for other important files on your computer. SpeedBase however makes this easier for you by keeping all data under a single folder.
Backup to Cloud
To protect your data against physical threats, you may consider to use an online backup service like Dropbox or Google Drive.
If you want to do so, remember that SpeedBase data folder should never be placed in a cloud backup folder. You may manually
take a backup copy of your data folder and paste it into e.g. Dropbox folder.
How to Restore from an External Backup?
Remember that you are much more likely to find a recent local backup than an external one.
So you are recommended to restore your database from a local backup as described above unless they are unavailable or damaged for some reason.
Follow the steps below to restore from an external backup:
- Locate the data folder in your backup media and copy it to the desired location on your hard drive.
- Open connection settings from database menu.
- Change your data folder location to the new one. SB will now search for existing database files under the new data folder.
- Select your database file from the drop down box.
Tip: If the database selection box remains empty, you have most possibly selected the wrong folder as data folder.
Try choosing either the parent or sub folder. Remember also that data folder has not the same path as your database folder.
- Save changes and exit. SB will connect to the new database at this point.
- Check your data to make sure you are connected to the correct backup.
- You may consider to delete or move the older data folder to somewhere else for cleanup purposes and prevent any mistakes in the future.
Do not confuse the data folder ("data") with the database folder ("db").
The database folder is just one of the four subfolders found under the data folder and you should deal with (i.e. copy or move) the "data folder".