mysql "out of memory" errors (was: Re: mysqldump with BLOB)

2002-02-21 Thread shawn
I've encountered a similar problem which seems to stem from a "larger" problem of MySQL thinking it's out of memory. It manifests itself in several ways: - when INSERT'ing a row into a table which stores binary data in a LONGBLOB column, I get one of several "out of memory" errors ("Out of memory

Re: mysqldump with BLOB

2002-02-21 Thread Shankar Unni
Dennis Wu wrote: > I have a table with a column defined as BLOB. However, when I dump > this table using ./mysqldump, the dump file cannot be imported. Is > that because a binary field cannot be dumped into a text file? Any > solution if I really need to do the backup by dumping the table? W

mysqldump with BLOB

2002-02-20 Thread Dennis Wu
Hello, I have a table with a column defined as BLOB. However, when I dump this table using ./mysqldump, the dump file cannot be imported. Is that because a binary field cannot be dumped into a text file? Any solution if I really need to do the backup by dumping the table? Cheers! Dennis W