[SPAM?] [rt-users] Backup Procedure

[Danial Klimkin]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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.
IMHO, "--single-transaction" should be enough, so steps 1 and 4 can be
skipped. Also, check default-charset options, I have troubles with
binary file attachments in backups until set it to "binary".

I am also using gzip -9 on result file and scp to backupserver.


SY, Danial.
- --
Danial Klimkin,
Falk eSolutions AG Russia
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFDYiP02ce6OqXQ52QRAt5fAJ98UI9SRRmnkFZIvV0auKIRou0SbwCfSyPv
Sx9gJj/bGwky0iSJF1Y/V9k=
=EBXp
-----END PGP SIGNATURE-----