here the problem wasn't from mysql command it was from perl it doesn't seems like to split string that is large over 20,000 arrays or about 5MB of string passed to a form the and using split function to organize it - any one know how i can split such big string - thanks - i commented the mysql command and still had error 
my @txtquearr = split('~', $txtque);
######################################################################
+#########
#my $count = 0;
foreach $txtque (@txtquearr){
#$count = $dbh->do('INSERT INTO ques (username,userque,userquedetail,u
+serquecatgory,userresponsecount,quegood,quebad,queid,userquedate,quev
+ideo,queaudio,quepic,email)values(?,?,?,?,?,?,?,?,?,?,?,?,?)',undef,$
+usernamenow,$txtque,$txtdetail,$cat,$userresponsecount,$quegood,$queb
+ad,$aaqueid,$userquedate,$txtvideolink,$txtaudiolink,$txtpicturelink,
+$txtemail);
#print "Ques Inserted inoto Data\n";
print $txtque;
}

[download]
server error says 
Internal Server Error
The server encountered an internal error or misconfiguration and was u
+nable to complete your request.

Please contact the server administrator, and inform them of the time t
+he error occurred and anything you might have done that may have caus
+ed the error.

More information about this error may be available in the server error
+ log.

[download]

In reply to please how can i split string that is over 5MB by askgetanswer
in thread Inserting large chunks of data into MySQL by askgetanswer

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.