[rt-users] rt3 db backup script

[Covington, Chris]

Hi all,

What is the proper mysqldump command for the rt3 database?  I have been
using:

mysqldump --opt rt3 | bzip2 -c >rt3$DATE.sql.bz2

But this seems to corrupt attachments and perhaps other things upon
restore using:

cat rt3$DATE.sql | mysql -hlocalhost --max_allowed_packet=16M  

---
Chris Covington
IT
Plus One Health Management
75 Maiden Lane Suite 801
NY, NY 10038
646-312-6269
http://www.plusoneactive.com