After running 'show create table Attachments', I ran the alter table statement alone and figured out my problem:
mysql> ALTER TABLE Attachments DEFAULT CHARACTER SET utf8, MODIFY Subject VARBINARY(255) NULL DEFAULT NULL, MODIFY ContentType VARBINARY(80) NULL DEFAULT NULL, MODIFY Filename VARBINARY(255) NULL DEFAULT NULL, MODIFY Headers LONGBLOB NULL DEFAULT NULL, MODIFY MessageId VARBINARY(160) NULL DEFAULT NULL, MODIFY Content LONGBLOB NULL DEFAULT NULL, MODIFY ContentEncoding VARBINARY(80) NULL DEFAULT NULL; ERROR 1114 (HY000): The table '#sql-3cf9_2' is full Time to find a bigger partition. Hopefully, that will allow the upgrade to proceed. Thank you for your assistance. Regards, Shane ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Ruslan Zakirov Sent: Thursday, April 07, 2011 2:54 PM To: [email protected] Subject: Re: [rt-users] Error Upgrading MYSQL from 3.6.3 to 3.8.9 On Fri, Apr 8, 2011 at 12:22 AM, Kevin Falcone <[email protected]> wrote: > On Thu, Apr 07, 2011 at 12:38:35PM -0700, Shane Becker wrote: >> I'm trying to upgrade from RT 3.6.3 to 3.8.9 and I'm running into a MYSQL issue: >> >> [error] RT since version 3.8 has new schema for MySQL versions after 4.1.0\nFollow >> instructions in the UPGRADING.mysql file. at /opt/rt3/bin/webmux.pl line 160.\nCompilation >> failed in require at (eval 2) line 1.\n > > This error message implies that your Attachments table still contains > a Blob, which implies that this step: typo, *still contains a text instead of blob* > >> mysql -u root -p rt3 < queries.sql > > failed in some manner. > > You probably want to look at the results of show create table > Attachments; > > -kevin > -- Best regards, Ruslan. ________________________________ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1204 / Virus Database: 1435/3555 - Release Date: 04/06/11 This email, its contents and attachments contain information from j2 Global Communications, Inc. and/or its affiliates which may be privileged, confidential or otherwise protected from disclosure. The information is intended to be for the addressee(s) only. If you are not an addressee, any disclosure, copy, distribution, or use of the contents of this message is prohibited. If you have received this email in error please notify the sender by reply e-mail and delete the original message and any copies.
