SWKM operations

Backuping the data

Step by step instructions to backup the data.

  1. Connect the server
    1. Use ssh
    2. Use webtool
  2. Locate the data
  3. Backup
    1. Automated script
      Please note that the path information should be set according to your system installation instructions
date=$(date +%d-%m-%Y)
echo $(/opt/pgsql/bin/pg_dump kplab_db > /mnt/DatabaseBackup/$date'_Database.out')
    1. Manual
pg_dump kplab_db > textfile.out

Restoring the data

Step by step instructions to restore the data.

  1. Connect the server
    1. Use ssh
    2. Use webtool
  2. Locate the data
  3. Restore
    1. Automated script
    2. Manual
dropdb kplab_db\\
createdb kplab_db\\
psql -d kplab_db -f textfile.out


Development Development tools

  Page Info My Prefs Log in
This page (revision-10) last changed on 18:24 25-Mar-2017 by Dimitris Kotzinos.
 

Referenced by
...nobody

JSPWiki v2.4.102
[RSS]