<div class="gmail_quote">On Wed, Nov 19, 2008 at 10:08 AM, Tim Cutts <span dir="ltr"><<a href="mailto:tjrc@sanger.ac.uk">tjrc@sanger.ac.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im"><br>
On 18 Nov 2008, at 4:47 pm, Tim Cutts wrote:<br>
<br>
</div><div class="im"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
What switches did you use to dump the mysql? I see few gotcha's about<br>
using binary characters<br>
and separate dump for attachment table and stuff<br>
</blockquote>
<br>
OK, yes, I've just looked at an attachment to one of our tickets, and<br>
yes, it's corrupted. Bugger. So I've obviously missed something. I<br>
thought that all one needed to do was to apply the mysql 4.0->4.1<br>
patches at the appropriate point, but clearly something is wrong. Or<br>
is it what you allude to above, and we need to do something smarter<br>
when dumping the Attachment table? Can you give me some references to<br>
where you've seen the gotchas?<br>
</blockquote>
<br></div>
OK, I'm now getting a bit concerned, because I've re-done my upgrade procedure based on dumping with --default-charset=binary, but I've still got a problem with corrupted attachments. I imagine there's a huge amount of past material on this list about this problem - are there any good summary documents somewhere? The procedure I'm trying to follow is:<br>
<br>
1) mysqldump my RT 3.4.2 instance, which is running on a MySQL 4.1.11 database (maybe this is my problem? Maybe I don't need the 4.0->4.1 update at all?)<br>
<br>
2) Load that dump into a new MySQL 5.0 database on my new system<br>
<br>
3) Apply the 3.4.2 -> 3.8.0 update<br>
<br>
4) Apply the MySQL 4.0->4.1 patch, if necessary (I'm now wondering whether it is, or whether applying it is actually causing the problem)<br>
</blockquote><div><br>It completes after 918 mins with this error message<br><br># time mysql -u root -p rt3 < sql.queries<br>Enter password:<br>ERROR 1062 (23000) at line 210: Duplicate entry '' for key 2<br>
<br>real 918m45.115s<br>user 0m0.088s<br>sys 0m0.072s<br><br><br> <br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
5) Apply the 3.8.0 -> 3.8.1 update<br>
<br>
Any ideas?<div><div></div><div class="h5"><br>
<br>
Tim<br>
<br>
<br>
-- <br>
The Wellcome Trust Sanger Institute is operated by Genome ResearchLimited, a charity registered in England with number 1021457 and acompany registered in England with number 2742969, whose registeredoffice is 215 Euston Road, London, NW1 2BE.<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Asif Iqbal<br>PGP Key: 0xE62693C5 KeyServer: <a href="http://pgp.mit.edu">pgp.mit.edu</a><br>A: Because it messes up the order in which people normally read text.<br>
Q: Why is top-posting such a bad thing?<br><br><br>