Frequently Asked Question

MySQL

You can use following commands to perform these tasks.

backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
Example: mysqldump -uroot -p KRYSTALDB2019 > KRYSTALDMS_BACKUP.SQL

restore:# mysql -u root -p[root_password] [database_name] Example: mysql -uroot -p KRYSTALDB2019

Microsoft SQL Server

You can use following T-SQL commands to perform these tasks.

backup: Backup database to disk = ''
Example : Backup database KRYSTALDB2019 to disk = 'D:\KRYSTALDMS_BACKUP.bak'

restore: Restore database from disk = ' ' with replace
Example : RESTORE DATABASE KRYSTALDB2019 FROM DISK = 'D:\ KRYSTALDMS_BACKUP.bak'

You can also use SQL SERVER Management Studio to take backup and restore database.

Please Note : You must stop KRYSTAL DMS service before taking backup of the database.