Try Free

Database Backup on Custom Installation Package on Windows

Backing up databases is required before performing any changes in your actiTIME installation: upgrading, moving to the new server, switching the database from MS Access to MySQL. To proceed with the database backup, follow the steps outlined below for your database type, MS Access or MySQL.

If you don’t know what database type you are running, check it as follows.

Open Help & Support menu:

Help & Support menu actiTIME

Select About actiTIME item and check your database in the System Info tab:

About actiTIME System Info

MS Access Database

Backup Procedure:

  1. Stop the Tomcat server.
  2. Go to the '<actiTIME installation directory>/database' folder and make a backup copy of the 'actitime.mdb' file.
  3. Start the Tomcat server.

Restore Procedure:

  1. Stop the Tomcat server.
  2. Go to the '<actiTIME installation directory>/database' folder and replace the 'actitime.mdb' file with its backup copy.
  3. Start the Tomcat server.

MySQL Database

Backup procedure:

  1. Stop Tomcat.
  2. Open Command Prompt.
  3. Go to the 'bin' folder in the directory where MySQL is installed.
  4. Create a dump of the existing actiTIME data by running the following commands:

    mysqldump -u <username> -p<password> -R [-h <host>] [-P <port>] --protocol=tcp <dbname> > actitime_data.sql

    where

    <username> is the name of the user who has all the necessary rights to administer the database.

    <password> is the password of the user (please note that there should be NO space between '-p' and 'password').

    <host> is the host name of the server where MySQL server is running. If not specified, the local host is assumed.

    <port> is the port used by MySQL. If not specified, the default MySQL port will be used.

    Square brackets [] indicate that the enclosed parameter is optional. Don't enter the square brackets themselves.

    Where can I find connection parameters to my database?

    <actitime installation dir>\WEB-INF\classes\com\actimind\actitime\AT.properties

    Your username and password are specified in the 'DBUser' and 'DBPassword' strings.

    The 'DBurl' line contains the port number:

    DBurl=jdbc:mysql://<host>:<port_number>/<dbname>

    After executing this command, MySQL will create a file with a dump of actiTIME data called 'actitime_data.sql'.

Restore procedure:

  1. Stop Tomcat.
  2. Open Command Prompt.
  3. Go to the 'bin' folder in the directory where MySQL is installed.
  4. Restore your actiTIME data by running the following commands:

    mysqladmin -f -u <username> -p<password> [-h <host>] -P [<port>] --protocol=tcp drop <dbname>

    After running the command above, the current data will be dropped.

    mysqladmin -f -u <username> -p<password> [-h <host>] [-P <port>] --protocol=tcp create <dbname>

    mysql -u <username> -p<password> [-h <host>] [-P <port>] --protocol=tcp <dbname> < actitime_data.sql

    where

    <username> the name of the user who has all the necessary rights to administer the database.

    <password> is the password of the user (please note that there shoold be NO space between '-p' and 'password').

    <host> is the host name of the server where MySQL server is running. If not specified, the local host will be assumed.

    <port> is the port used by MySQL. If not specified, the defaolt MySQL port will be used.

    <dbname> is the name of the MySQL database used by actiTIME. If you did not specify a custom database name when installing actiTIME, enter 'actitime' here.

    actitime_data.sql is the file containing the backup of your actiTIME data.

  5. Start Tomcat.