[SPAM?] [rt-users] Backup Procedure

[Ruslan Zakirov]

On 10/28/05, Danial Klimkin <klimkin at falkag.com> wrote:
>
> Greetings!
>
> Kaplan, Andrew H. wrote:
> > I thought I would combine the best of both approaches in the following manner:
> >               1. Cron job /etc/init.d/mysqld stop
> >               2. mysqldump --opt --add-drop-table --single-transaction
> >                     -u <rt_user> -p <rt_password> - h <databasehost>
> > rt3 > rt3-mysql-backup
> >               3. Backup of the filesystems on the RT server including the
> > directory where the flat file from step 2 is sent.
> >               4. Cron job /etc/init.d/mysqld start
> >
> > Your thoughts?
>
> You will loose any email arrived between mysql stop and mysql start.
no, because while mysql is stopped RT web server reports errors to
mailgate and mailgate exits TEMP_FAIL, MTA should resubmit mail
latter. IMHO other behaviour is bug.

> IMHO, "--single-transaction" should be enough, so steps 1 and 4 can be
ditto.

> skipped. Also, check default-charset options, I have troubles with
> binary file attachments in backups until set it to "binary".
+1, IMHO you should always create binary backups of the RT DB, without
any specific charset.

>
> I am also using gzip -9 on result file and scp to backupserver.
>
>
> SY, Danial.
> - --
> Danial Klimkin,
> Falk eSolutions AG Russia


--
Best regards, Ruslan.