This section describes backup and restore, when Garoon is installed in the following environment.

• On Windows:
  • Installation identifier: cbgrn
  • CGI directory: C:\inetpub\scripts
  • MySQL installed directory: C:\Program Files\Cybozu
• On Linux:
  • Installation identifier: cbgrn
  • CGI Directory: /var/www/cgi-bin
  • MySQL installation directory: /usr/local/cybozu

Before you can perform back up or restore, you must confirm the followings.

• Backup or restore operations should be performed by the following users.
  • On Windows:
    Users who have local Administrator rights on the server machine
  • On Linux:
    Users with root privilege
• Garoon cannot be used during data backup.
• Backups may take a long time, depending on the size of the data.
• Garoon version must be identical in backup source and in restore target.
• Do not store backup data in the following directory. Otherwise, you may lose data if upgrades or service packs are applied.
  • On Windows:
    • C:\Program Files\Cybozu and subdirectories
    • C:\inetpub\scripts\cbgrn and subdirectories
  • On Linux:
    • /usr/local/cybozu and subdirectories
    • /var/www/cgi-bin/cbgrn and subdirectories
• If the monitoring tool monitors the operation of each service or daemon, it is recommended to exclude Garoon from monitoring targets until the action is completed.

Back up the "data" directory and the "files" directory used by the database (MySQL).
Data stored in each directory is as follows.

• "data" directory:
  Data required for MySQL to work is stored.
  This includes database user passwords and data from Garoon applications.
• "files" directory:
  Data contained in attachment files, such as messages and bulletin board posts, is stored.

MySQL data and attachment file data are connected.
Data retrieved from the "data" directory and the "files" directory at the same time are required for the restore.
When backing up data, carefully plan backup to avoid data inconsistency.

MySQL used in Garoon can be selected during installation of Garoon.
Depending on the MySQL you are using, MySQL service name and the directory path that is being backed up are different.

• MySQL Service Name:
  Cybozu_Database_Engine_5_0
• Directory path to be backed up:
  • C:\Program Files\Cybozu\mysql-5.0\data
  • C:\Program Files\Cybozu\mysql-5.0\files

• MySQL Service Name:
  MySQL (version number)
• Directory to be backed up:
  • C:\ProgramData\MySQL\MySQLServer(version number)\data
  • C:\Program Files\Cybozu\mysql-5.0\files

• MySQL Service Name:
  cyde_5_0
• Directory to be backed up:
  • /usr/local/cybozu/mysql-5.0/data
  • /usr/local/cybozu/mysql-5.0/files

• MySQL Service Name:
  mysqld
• Directory to be backed up:
  • /var/lib/mysql
  • /usr/local/cybozu/mysql-5.0/files