Rt3 db backup script

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

This is what we use at work:

Mathew Snyder

Covington, Chris wrote: