Take Database Backup

Owned by Kevin Pham (Deactivated)
Last updated: Oct 10, 2024 by Dominik Trygar
1 min read

Starting October 11, 2024 (Zephyr Enterprise 8.2), the Zephyr Enterprise documentation moved from its current location on Atlassian to a dedicated, standalone Zephyr Enterprise documentation page. Please see: https://support.smartbear.com/zephyr-enterprise/docs/en/zephyr-enterprise/zephyr-installation---upgrade-guides/upgrade-zephyr-enterprise/zephyr-on-premise-upgrade-instructions/take-database-backup.html


MySQL 
#To make a backup of the DB
mysqldump -u [uname] -p [pass] db_name > db_backup.sql
 
#To restore the backup
mysql -u [uname] -p [pass] db_name < db_backupfile.sql
Oracle
# To make a backup of the DB
exp username/password file=xyz.dmp
 
# To restore the backup
imp target_username/password FULL=Y file=xyz.dmp