Backup & Restore Database

Top  Previous  Next


Features of CodedColor that ensure database integrity


1.Automatic broken link detection and correction.
2.Automatic saving of changes
3.Automatic datafile backups and restoration
4.Manual database backups and restoration
5.Clear Thumb Cache
6.Cleanup database


The backup options in detail:


2. Automatic saving of changes


In the Program Settings > Database tab you can define the Autosave interval in minutes, in which changes to the database are automatically written to the disk. If you are planning on adding many keywords and annotations to your images in a single session, then we advise you to turn this setting on. As an alternative, you can also press Save Database Now in the annotation dialog, while you are adding descriptions to your images.


3. Automatic datafile backups and restoration


In the Program Settings > Database tab you can enable Automatic datafile backups. Whenever you terminate CodedColor, a backup of the last correct database file is made in the Workdirectory\Backup folder, BEFORE the current changes are written to the disk. If anything goes wrong during shutdown of CodedColor, your database file could become corrupted. Thus, when you start CodedColor the next time and the database cannot be loaded for some reason, the last automatically backed file is used. (This feature is similar to the Windows backup of the registry.)


4. Manual database backups and restoration


In regular (monthly) intervals - depending on your database usage - you should call the menuitem Backup database. All database relevant files from Workdirectory\Data are then copied to a folder beneath Workdirectory\Backup. This includes the database definition files and image editor settings, which are stored in binary files. If you later experience database corruption or data loss, you can restore these files. Note however, that calling the Restore function looses all changes of the current CodedColor session.


5. Clear Thumb Cache


Calling this function in the Program Settings > Database tab removes all thumbs from the thumb database. You may need to do this, if your image database and the thumb cache become asynchronous, for instance after calling Restore Database. Deleting all thumbs has no effekt on CodedColor or your image archives, other than temporarily slowing down the explorer, since all thumbs now have to be recreated when browsing the image folders.


icon_tip Important


You should do manual backups at least once a month, or after you have added many annotations (title, description and keywords) to your images.


You should set the Automatic datafile backup option, if you regularly add annotations and keywords to your images. You can also call Save database now, after adding many annotations.


Your images are never backed, only the corresponding database records. To backup your images, you should burn CDs of finished collections, for instance of all images taken in a certain year.


If you have checked the Automatic datafile backup option in the Program Settings, and you are experiencing a database problem while running CodedColor, try restarting Windows and CodedColor BEFORE calling the Restore Database menuitem. The manual restore facility only restores your last manual backup, whereas the autobackup option uses the database file from your last successful CodedColor shutdown.


icon_tip Related topics


Database tab
Why does the program stay active in the tray?
How stable is the database?
Is the database compatible with other programs?
Can I view the contents of the database?
Are my images stored in the database?
Database definition





CodedColor PhotoStudio © 2023 1STEIN GmbH

CodedColor PhotoStudio by 1STEIN is an award-winning Windows photo viewer and editor to organize, edit, resize, reformat, correct, compare, sort, watermark, annotate and print digital images, and to edit EXIF and IPTC data in digital photos. You can rename multiple images, remove scratches, stich panoramas, convert RAW photos (from Canon, Nikon, Olympus, etc. cameras), burn digital watermarks, correct colors, batch convert and correct images and generate a web album in HTML5. The software is easier to use than Photoshop, but more versatile than ACDSee, Picasa, Irfanview or Gimp. Many magazines consider it to be the Swiss Knife of Image Editing. Have a look at our Before / After tutorials to get an idea of the powerful capabilities. The software comes with a detailed handbook and a fast database to store EXIF/IPTC data and color information. CodedColor PhotoStudio is the ideal image editing tool for every-day and professional digital camera users. The user friendly interface combines features like expert photo editing & printing, layer editing, web album galleries, slide shows, photo management & cataloging, custom sorting, IPTC & EXIF editor, GPS tagging, perspective correction, barrel distortion, effects, thumbnail generation, resize & resample images, batch conversion, database keyword searching, red eye removal, color/sharpness/brightness & contrast correction, artifact removal, clone brush, scanner & TWAIN import, screen capture, lossless JPEG rotation, transparency (alpha channel) and layers, gamma correction, screen shows with many transition effects, watermark text, image annotations, panorama stitch & animation, video capture, PDF album export, photo layouts, collages, frames, shadows, histograms, automatic white balance, photo sharing, etc. Opens and converts all common image formats: BMP, WMF, GIF, JPEG, JPEG2000, TIFF, PCX, PNG, PSP, PSD, PCD, HEIC, HEIF, AVIF and all current RAW formats. The installation includes our the CodedColor Publisher, a versatile photo layout and DTP tool to create individual and rich photo books.