Try Free

Database Backup on Custom Installation Package on Unix

Backup procedure:

  1. Stop Tomcat.
  2. Start Shell.
  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 name of the user who has all the necessary rights to administer the database.

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

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

    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. Start Shell.
  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> 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 will be assumed.

    <port> is the port used by MySQL. If not specified, the default 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.

    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>

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

  5. Start Tomcat.