Backing up Ephesoft

 

At times, you may wish to backup Ephesoft. Whether it is before an update, or just a weekly backup, backing up Ephesoft may be required for your specific disaster recovery plan. There are a few recommendations and tips for backing up Ephesoft.

!! Since these files can change and be locked while Ephesoft is running, it is required to shutdown the Ephesoft Application/Service before making any backups.

The items that you will want to update:

1. Ephesoft Application Folder (This folder holds settings for the application and supporting applications)

2. Ephesoft SharedFolders Folder (This folder holds all of the working files for running batches and by default holds the output files from Ephesoft)

3. Ephesoft EphesoftReports folder(4.0.x based versions) (This folder holds some settings used to connect to the reports database)

4. ephesoft and report databases

5. Batch Classes (export)

 

Backing up folders:

If storage space is not an issue, it is simplest to backup the full Ephesoft folder. If storage is an issue, we recommend that you backup the applications above and you can exclude the Ephesoft\Application\native folder in this backup

 

Backing up databases:

MariaDB (4.0 based installs):

When backing up your database in MariaDB, you will use a command from the command line using the following syntax: mysqldump -u username -ppassword –databases db_name1 db_name2 > backup-file.sql

example

mysqldump -u ephesoft -pephesoft--databases ephesoft report > backup-file.sql

 

 

MSSQL:
To back up a database in MSSQL:

  1. Open the SQL Server Management Studio which hosts your ephesoft and report databases
  2. Run the following command for each database changing the output file for your preferred backup location and filename. (we recommend including a date in the filename so that you can have multiple backups.)
    BACKUP DATABASE ephesoft
    TO DISK = 'C:\Backups\ephesoft.BAK'
    GO
  3. Press enter.

 

 

 

MySQL (< 4.0 based installs):

When backing up your database in MySQL, you will use a command from the command line using the following syntax: mysqldump -u username -ppassword –databases db_name1 db_name2 > backup-file.sql

example

mysqldump -u ephesoft -pephesoft--databases ephesoft report > backup-file.sql

 

 

 

Backup Batch Classes:

It is recommended that you use the export functionality in the Ephesoft Batch Class Management. Once exported as zip files, these files will act as your backups. It is also recommended that you export the batch classes with sample files.

 

Was this article helpful to you?

J.D. Abbey

Comments are closed.