Take Database Backup

Owned by Kevin Pham (Deactivated)

Last updated: May 06, 2019 by Fernando Mattos (Deactivated)

1 min read

Table of Contents

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