[rt-users] attachment corruption, 3.4.1 => 3.4.4 - UPDATE

Danial Klimkin klimkin at falkag.com
Thu Sep 22 05:08:34 EDT 2005


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

Greetings Paul!


Paul Grondahl wrote:
> i copied the database back to the original system (with rt 3.4.1) and did a
> full restore.  attachments were still corrupt. i then restored a backup from
> a few days back, attachments are still corrupt!
> 
> i must be doing something wrong in the backup/restore procedure.
> 
> i backup nightly with this command: 
> mysqldump -p --opt rt3 | gzip > /home/backup/rt3.dump.gz
> 
> and i restored with: 
> gzip -dc /home/backup/rt3.dump-saturday.gz | mysql -p rt3
> 
> i also verify the md5sums for the file, both before and after it goes to
> tape. 
> 
> any idea what could be happening?

Yep, I have a guess as I lost attachments the same way.
Probably you lost it while were dumping db. You should use:

> mysqldump *--default-character-set=binary* -p --opt rt3 | gzip >
/home/backup/rt3.dump.gz

Fortunately, in my case I kept binary db backups before moving.
I hope you done so too.

May be we should place it on wiki or in FAQ? I spent some time studyed
it and could not find anything on wiki/google.


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

iD8DBQFDMnSS2ce6OqXQ52QRArpLAJ99k0raF5qZ7bIymln4T21QMX+Z7QCbBD9Z
dQL2mK+NhEjp015+Bz2DOzI=
=aiv/
-----END PGP SIGNATURE-----



More information about the rt-users mailing list