Backing up the TASSTA server database

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.