<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3059" name=GENERATOR>
<STYLE>@font-face {
font-family: SimSun;
}
@font-face {
font-family: @SimSun;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: #606420; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: #606420; TEXT-DECORATION: underline
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=#606420 link=blue>
<DIV dir=ltr align=left><SPAN class=439310703-29032007><FONT face=Arial
size=2>Hi,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=439310703-29032007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=439310703-29032007><FONT face=Arial
size=2>Use mysql to connect to the database that your rt instance runs on. Then,
run the following command:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=439310703-29032007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=439310703-29032007><FONT face=Arial
size=2>SELECT id,Subject,Filename,ContentType,ContentEncoding,Content,Headers
FROM rt3.Attachments WHERE ContentType LIKE '%pdf' ORDER BY id DESC;
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=439310703-29032007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=439310703-29032007>As you can see, the
file is kept in the 'Content' container.</SPAN></FONT></DIV><!-- Converted from text/rtf format -->
<P align=left><SPAN lang=en-us><FONT face=Arial
size=2>Regards,<BR>Sasha</FONT></SPAN> </P>
<P><SPAN lang=en-us><FONT face=Arial size=2>Sasha Gerrand</FONT></SPAN>
<BR><SPAN lang=en-us><FONT face=Arial size=2>Web & Database
Developer</FONT></SPAN> <BR><SPAN lang=en-us><FONT face=Arial
size=2> </FONT></SPAN> <BR><SPAN lang=en-us><B><FONT face=Arial
size=2>Austbrokers Holdings Limited</FONT></B></SPAN> <BR><SPAN lang=en-us><FONT
face=Arial size=2>Level 21, 111 Pacific Highway</FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>North Sydney NSW 2060</FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>PO Box 1813 North Sydney NSW
2060</FONT></SPAN> <BR><SPAN lang=en-us><FONT face=Arial
size=2> </FONT></SPAN> <BR><SPAN lang=en-us><FONT face=Arial size=2>Ph:
02 9935 2230</FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=2>Mobile: 0431 895 718</FONT></SPAN>
<BR><SPAN lang=en-us><FONT face=Arial size=2>Email:
sashag@austbrokers.com.au</FONT></SPAN> <BR><SPAN lang=en-us><FONT face=Arial
size=2>Web: <A
href="http://www.austbrokers.com.au/">http://www.austbrokers.com.au</A></FONT></SPAN>
<BR><SPAN lang=en-us><FONT face=Arial size=2> </FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=1>NOTICE</FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Arial size=1>If you are not an authorised recipient of
this email, please contact Austbrokers Holdings immediately by return e-mail or
by telephone on +61-2-4920-6117. In this case, you should not read, print,
re-transmit, store or act on this e-mail or any attachments. Please destroy the
message and attachments. This e-mail and any attachments are confidential and
may contain legally privileged information and/or copyright material of
Austbrokers Holdings or third parties. You should only re-transmit, distribute
or commercialise the material if you are authorised to do so. Internet e-mails
are not necessarily secure, Austbrokers Holdings does not accept responsibility
for changes made to this message after it was sent. This Notice should not be
removed.</FONT></SPAN></P>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <B>On Behalf Of </B>Firas
Batal (QA/EMC)<BR><B>Sent:</B> Thursday, 29 March 2007 1:25 AM<BR><B>To:</B>
rt-users@lists.bestpractical.com<BR><B>Subject:</B> [rt-users]
RAM<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Hi,<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">I do not know if this is the
right forum for my question. I will try to see if someone has DB
experience.<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">I have RT 3.2.1 running with
</SPAN></FONT><FONT face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">MySQL 4.0.21.
</SPAN></FONT><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">I use MYSQL with RT, and I
have just created a ticket that contains a .zip attachment with a size of
11MB. I wonder if one could guide me through the following: I know
that MYSQL need lots of RAM to breathe properly. But, where is the file
kept? Is in stored in records in RAM or its stored on the hard drive with a
pointer of the location of the file stored in RAM? </SPAN></FONT><FONT
face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thank you for your time and
help</SPAN></FONT><BR><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Firas</SPAN></FONT> <o:p></o:p></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P></DIV></BODY></HTML>