On 18 Nov 2008, at 3:27 pm, Asif Iqbal wrote: > What switches did you use to dump the mysql? I see few gotcha's about > using binary characters > and separate dump for attachment table and stuff
I haven't tested the attachments thoroughly yet, so I don't know whether it worked. I just used one of our regular backup dumps, which isn't massively complicated. Our RT instance is replicated, and we back up off the slave using: mysqldump --defaults-extra-file=/mysql/data_3307/slave.cnf --single- transaction --flush-logs --master-data=2 --all-databases -q | gzip > backup.gz Are there particular attachment types I should look for to check whether things are working? Tim -- The Wellcome Trust Sanger Institute is operated by Genome Research Limited, a charity registered in England with number 1021457 and a company registered in England with number 2742969, whose registered office is 215 Euston Road, London, NW1 2BE. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com