
14 Jul
2008
14 Jul
'08
1:58 p.m.
Steve Rizkalla wrote:
Can anyone make a suggestion on how and what to back up on a Redhat based OTRS 2.2 machine? I am thinking we’ll need a MySQL agent for BackupExec or Bakbone and simple file system backup the rest….
Sound right?
Always create SQL dumps from your databases and back those up instead of the live database files (which may not work after restoring them). For MySQL you can use the mysqldump command. Our backup software lets you set a command to run before starting the backup, so we created a pre-backup script that creates SQL dumps for all databases. There is a also a backup script in the OTRS distribution that packs the application and the database I believe. I have never used it though. Nils Breunese.