Backups (SQL) TNG v14
- Item 100. Admin >> Utilities: Backups can now be created as SQL files (the old method will still be supported). They can also be downloaded with a download icon. Backups may also include DROP and CREATE table directives. A restore operation may be made to drop all existing records or not.
New options and actions
- The "Setup / Utilities" menu now lets you choose to save your tables as .bak files (as usual) or as .sql files.
Choosing the "Export as SQL" option also lets you include the "CREATE TABLE" and/or "DROP TABLE IF EXISTS" SQL commands.
- An additional option allows you to erase the current contents of the table before restoring your backup.
Note that the two forms of backup cannot coexist in your 'backups' directory. The latest backup will overwrite the previous one, regardless of what type of backup you use.
In other words, you can only have one backup set, possibly composed of .bak files and .sql files (Table by table backup)
It is however always possible to "cheat" by creating a set of files of backup in .bak then by modifying the extension, then to redo a backup in .sql...
You should however know that, unless changed, the backups in .bak are destined to disappear in one of the next versions of TNG.
- It is now possible to locally download the backups created on your server, thanks to a fourth action button: "Download".
Depending on the options chosen in your browser, the downloaded files will be copied to your usual 'Downloads' folder.
Other Features
If you are using a separate configuration folder (Admin >> Setup >> General Configuration >> Paths and Folders - See Move_your_configuration_files )
Your "backups" directory can now be migrated to your external configuration directory. Your "backups" directory should be a subdirectory of your external config directory.
You must:
1) move manually your "backups" folder to your external configuration directory
2) Report your change to TNG by checking the "Store in configuration path" box (Admin >> Setup >> General configuration >> Paths and folders
- Note : the same possibility exists for the gedcom folder. See Import_Improvements_TNG_v14.
The new screen for Backup Utility
Download Backups Button
Note that if you use the Store in Config Path option for backups, the download button will be suppressed. In order to download the backups you will need to temporarily uncheck the option, you can then take new backups, download them to your computer and then check the box to Store in Config Path option in Admin > General Settings > Paths and Folders for the backup folder to protect your backups
