[rt-users] rt3 db backup script

[Mathew]

This is what we use at work:

http://sourceforge.net/project/showfiles.php?group_id=101066&package_id=108655


Mathew Snyder

Covington, Chris wrote:
> 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
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
> 
> 
> We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
> 
>