| Anchor | ||||
|---|---|---|---|---|
|
| Column | ||||||
|---|---|---|---|---|---|---|
There are currently two objects that can be backed up:
Please ensure you are loggedintoin to the machine on which Zephyr Server is installed to accessattachment backup/the restore processes. You will need to be loggedintoin to your database server tobackupback up the database data separately. Attachment script files must be run with appropriate permissions.It is highly recommended that you consistently backup back up your Zephyr Attachments attachments and Databasedatabase. |
Backup & Restore
...
| Info | ||
|---|---|---|
| ||
Linux users note that all utilities must be run as root. Use the sudo command for root permission. |
The following steps will need to be followed to Backup, Restore and Schedule your database and attachments:
Step 1: Database Backup
Step 2: Database Restore
Step 3
...
Step 4: Attachment Restore
...
: Scheduling
| Anchor | ||||
|---|---|---|---|---|
|
Step 1: Database Backup
Backup: Instructions take a native backup from the database with out attachmentwithout attachments
MySQL
mysqldump -u [uname] -p[pass] db_name > db_backup.sql
...
Please contact your DBA for instructions or follow the steps mentioned in the link below for backup
...
Step 2: Database Restore
Restore: Instructions to Restore restore the native backup
MySQL
mysql -u [uname] -p[pass] db_name < db_backupfile.sql
...
https://technet.microsoft.com/en-us/library/ms188312(v=sql.105).aspx
| Anchor | ||||
|---|---|---|---|---|
|
Step 3:
...
Backup: Instructions for backup on windows/Linux for attachment
Windows
backupAttachment.bat location Y
Example:
backupAttachment.bat c:/users/abc Y
Provide the location of where the attachment backup will be stored.
Linux
Run dos2unix *.sh
Run backupAttachment.sh Y
By default, the backup file is present in Linux at: %Zephyr_Root%/ftp/backup/
...
Step 4: Attachment Restore
Restore: Instructions for restore on windows/Linux for attachment
Windows
restoreAttachment.bat -FORCE
Linux
Run dos2unix *.sh
Run restoreAttachment.sh -FORCE
Provide the location for the backup file after executing the command.
...
Scheduling
The sheduling utility that only backs - up the database without backing - up the repository and trend data. Use this utility only if instructed by Zephyr support.
...
C:\mybackup\partial-db-backup.sql C:\Software\Zephyr\