IP Concert: How to back up a Concert Server database
How to back up a Concert Server database
BACKING UP THE DATABASE1. To back up the Concert database, first log in the Concert server PC as “root”. This is the main PC login (default user = root, default password = concert)2. Open a terminal window and then type the following command:# service ems backupThis command will create a compressed file containing the entire contents of the Concert database. The backup file will be placed in the directory: “/var/lib/pgsql/backups”. The filename will be in the format “[Date_Time].sql.gz”.The backed up file can then be copied
RESTORING THE DATABASE1. To restore the database using the backup file created in the above procedure, execute the following command:# service ems restoreThis will prompt you to enter the full path of the backup file from which to restore the database.Note: This procedure will wipe out any information currently contained within the database and replace it with the information contained within the backup file.