Backup SVM-On-premise Database
To backup your SVM-On-premise Database:
mysqldump -u [user] -p [database_name] > [filename].sql
- Replace [user] with your username and password (if needed).
- The [database_name] is the path and filename of the database.
- The > command specifies the output.
- [filename] is the path and filename you want to save the dump file as.
To backup of an entire Database :
mysqldump --all-databases --single-transaction --quick --lock-tables=false > full-backup-$(date +%F).sql -u root -p
To include more than one database in the backup :
sudo mysqldump -u [user] -p [database_1] [database_2] [database_etc] > [filename].
sql
Important: If you have dual SVM-on-premise Application and DB server setup. Then edit the following part of the above commands to take the backup.
mysql -u [user] -p -h <Database Sever Name>
