Database Backup Instruction
|
|
Auto-installation package with MS Access database
Backup procedure:
- Stop actiTIME
- Go to the '<actiTIME installation directory>\database' folder and make a backup copy of the 'actitime.mdb'
file
Restore procedure:
- Stop actiTIME
-
Go to the '<actiTIME installation directory>\database ' folder and replace the
'actitime.mdb' file with its backup copy
Auto-installation package with MySQL database
Backup procedure:
- Start actiTIME.
- Open CMD.
- Go to the '<actiTIME folder>/database/MySQL/bin' folder.
-
Create a dump of the existing actiTIME data by running the following command:
mysqldump -u <username> -p<password> -P <port_number> actitime > actitime_data.sql
where
<user> is the name of the user who has all the necessary rights to administer the database.
<password> is the password of this user (please note that there should be NO space between
'-p' and 'password')
<port_number> is the port used by MySQL
You will find these parameters in the '<actiTIME installation directory>\actitime.config' file.
They are specified in the strings "DBUser" and "DBPassword".
The port number is specified in the line "DBurl":
DBurl=jdbc:mysql://<host>:<port_number>/<dbname>
After the execution of this command MySQL will create a file with dump of actiTIME data
called 'actitime_data.sql'
Restore procedure:
- Start actiTIME.
- Open CMD.
- Go to the '<actiTIME folder>/database/MySQL/bin' folder.
-
Restore your actiTIME data by running the following commands:
mysqladmin -f -u <username> -p<password> -P <port_number> drop actitime
After this command the current data will be dropped.
mysqladmin -f -u <username> -p<password> -P <port_number> create actitime
mysql -u <username> -p<password> -P <port_number> actitime < actitime_data.sql
where
<user> is the name of the user who has all the necessary rights to administer the database.
<password> is the password of this user (please note that there should be NO space between
'-p' and 'password')
<port_number> is the port used by MySQL
You will find these parameters in '<actiTIME installation directory>\actitime.config'
file.
They are specified in the strings "DBUser" and "DBPassword".
The port number is specified in the line "DBurl":
DBurl=jdbc:mysql://<host>:<port_number>/<dbname>
actitime_data.sql is the file containing the backup of your actiTIME data.
Custom package with MS Access database
Backup procedure:
- Stop actiTIME
-
Go to the '<actiTIME installation directory>' folder
and make a backup copy of the 'actitime.access97.mdb' file
Restore procedure:
- Stop actiTIME
-
Go to the '<actiTIME installation directory>' folder
and replace the file 'actitime.access97.mdb' with its backup copy
Custom package with MySQL database
Backup procedure:
- Open CMD
- Find the folder where MySQL is installed and go to the 'bin' folder.
-
Run the following command:
mysqldump -u <username> -p<password> -P <port_number> actitime > actitime_data.sql
where
<username> is the name of the user who has all the necessary rights to administer the database
(you can also use 'root' for it).
<password> is the password of this user (please note that there should be NO space between
'-p' and 'password')
<port_number> is the port used by MySQL
Executing this command you will create a dump of your database.
Restore procedure:
- Open CMD
- Find the folder where MySQL is installed and go to the 'bin' folder.
-
Run the following command:
mysqladmin -f -u <username> -p<password> -P <port_number> drop actitime
After this command the current data will be dropped.
mysqladmin -f -u <username> -p<password> -P <port_number> create actitime
mysql -u <username> -p<password> -P <port_number> actitime < actitime_data.sql
where
<username> is the name of the user who has all the necessary rights to administer the database
(you can also use 'root' for it).
<password> is the password of this user (please note that there should be NO space between
'-p' and 'password')
<port_number> is the port used by MySQL
|
