How To Backup SVM-Onpremise Database

How To Backup SVM-Onpremise Database

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>

   

Was this article helpful? Yes No
No ratings
Version history
Revision #:
2 of 2
Last update:
‎Nov 27, 2020 04:08 AM
Updated by:
 
Contributors