The following data has to backed up periodically:

1. All files, which are stored in the Tricia folder, which contains the four subfolders /scripts, /data, /software, and /properties.
2. The content of the database, which if you are using MySQL is stored separately (see Installing MySQL):

• You can export the content of the database using the following command:
  mysqldump.exe -u root --password=%PASSWORD% %NAME_OF_THE_DATABASE% > dump.sql

Restoring Tricia from backup

You have to restore the content of the Tricia folder, and the content of the database. Restoring the Tricia folder is straightforward and is not described here.

Restoring the database

1. Connect to MySQL first:

C:\>mysql -u root -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 574
Server version: 5.1.41-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

2. Connect to the Tricia database:

mysql> connect tricia;
Connection id: 575
Current database: tricia

mysql>

3. Import the dump:

mysql>source C:/dump.sql;

It might be necessary to register Tricia as a service again to finish the restore operation.