Steve, >Date: Mon, 12 Nov 2001 08:52:54 >To: [EMAIL PROTECTED] >From: Heikki Tuuri <[EMAIL PROTECTED]> >Subject: Re: Cannot add blob data to innodb table > >Stephen, > >>Hi, >> >>I have an Access97 table containing binary fields (gifs) that I would like >>to migrate to an innodb format via MyODBC (2.50.39) and MySQL-Max (3.23.44). >>The MySQL query log shows binary-like characters being received but there >>never seems to be progression to the next record. After 5 or so minutes, the >>append query in Access97 quits and an ODBC error window complaining about a >>lost connection pops-up. When I convert the table to myisam type, the append >>query works. Is there something in my.cnf I need to adjust to fix thisproblem? > >inserting binary BLOBs should work. What is an 'append' query in MS Access? Is it translated to an INSERT in MySQL? Could you paste a copy of what the MySQL query logs shows? > >How big is the BLOB? What is the CREATE TABLE statement? Note that a BLOB bigger than > 64 kB needs to be defined a MEDIUMBLOB or LONGBLOB in the CREATE TABLE statement. > >If you try inserting an ASCII text file does that work? > >How big you have set > >max_allowed_packet > >in my.cnf? That restricts the size of rows communicated from a client to the server. > >>Thanks, >>Stephen > >Regards, > >Heikki >http://www.innodb.com
actually, are you running MySQL on Windows? Then the problem might be the bug introduced in 3.23.42: to access InnoDB tables you must use the same case of letters in the database name as you used in the CREATE TABLE statement. Make sure you consistently use lower case in database names. The bug is fixed in upcoming 3.23.45. Does mysql.err contain anything? Regards, Heikki --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
