Backing up the TASSTA server database
Important: |
Database backups contain copies of sensitive data and should be secured. |
There are several ways to back up the TASSTA server database.
Using mysqldump utility
The mysqldump client utility produces a dump of MySQL database (as a set SQL statements) that can be executed to reproduce the original database and table data. Run the following command to back up a server database:
mysqldump --single-transaction tcommander > tcommander_backup_date.sql
Using TASSTA toolset
T.Lion offers built-in shell utility for backing up a server database. Run the following command on the T.Lion server:
tassta-dump
– or –
/usr/local/tassta/tools/vmysqldump.sh
The database backup is created in /var/backups.
It is highly recommended to keep backups on a different machine, so they are not affected by a potential server failure. Use a secure file transfer utility (such as scp / WinSCP) to transfer backups to the remote host.