://order.mysql.com/
- Original Message -
From: "Chris Seidel" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, January 05, 2004 11:07 PM
Subject: mediumtext crash on strings > 1MB?
> Hello,
>
> I have a table in which one of the column
On 5 Jan 2004 at 14:18, Chris Seidel wrote:
> Thus I had to reset the max_allowed_packet size to allow for larger
> packets by restarting the server with
>
> /usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --set-variable
> max_allowed_packet=10M >/dev/null 2>&1 &
>
> To do this I edited the mys
Keith was right, the error on inserting large strings into mediumtext had
to do with the variable max_allowed_packet. The defualt value can
be seen by:
mysql> show variables like "max_allowed_p%"
and the default value was 1048576.
Thus I had to reset the max_allowed_packet size to allow for large
Ah yes. From Perl I got the "server went away" error when inserting large
entries. From the command line, I simply got "ERROR at line 1:"
when I would construct the insert statment and place it in a text
file to be run as: mysql -p -D myDBm < mybiginsert.sql
I didn't realize there was a max_allowe
On 5 Jan 2004 at 13:06, Chris Seidel wrote:
> However, I found my inserts failing when some of my
> strings exceeded 1 MB (e.g. a string of 1125921 bytes fails, while a
> string of 1009684 bytes succeeds).
What error are you getting? It sounds like you haven't changed
max_allowed_packet from th
Hello,
I have a table in which one of the column types has been
declared as mediumtext to hold blocks of text averaging 250k
in size. A mediumtext datatype should be able to hold > 16 million
characters. However, I found my inserts failing when some of
my strings exceeded 1 MB (e.g. a string of 11
