External Backup Procedure
For the purpose of having a backup in the case of a disaster, we propose the following simple and fast procedure:
- Back up of the database tables. To this end, automatic backups can be defined in the configuration section of the data sources. Furthermore, the Save SQL Backup button allows saving the tables manually.
Another alternative is to directly backup the relevant SQL database directory, in Windows for example:
C:\Pmod3.4\data\DATABASES\dbname for JavaDB databases
C:\Program Files\MySQL\MySQL Server 5.0\data\dbname for mySQL databases. - Back up of the data directory. All data files reside under a common directory. So after the database tables have been saved, copy this directory to a different disk as a data backup.