----- Original Message ----- From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 04, 2004 1:24 PM Subject: Re: Major problem converting MyISAM to InnoDB
> Cliff, > > ----- Original Message ----- > From: ""Cliff"" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Thursday, March 04, 2004 7:07 PM > Subject: Re: Major problem converting MyISAM to InnoDB > > > > Hi, I ran CHECK TABLE with the EXTENDED option on the table and it reports > > everything ok: > > > > mysql> check table allusa extended; > > +-----------+-------+----------+----------+ > > | Table | Op | Msg_type | Msg_text | > > +-----------+-------+----------+----------+ > > | bb.allusa | check | status | OK | > > +-----------+-------+----------+----------+ > > 1 row in set (4.74 sec) > > hmm... then the table most probably is not corrupt inside InnoDB. > > > I am running FreeBSD 4.9-STABLE. The error log did not show anything while > > or after the query ran: > > > > 040304 09:09:32 mysqld started > > 040304 9:09:33 InnoDB: Started > > /mnt/disk2/mysql/bin/mysqld: ready for connections. > > Version: '4.0.18-standard-log' socket: '/tmp/mysql.sock' port: 3306 > > > > If I do a select statement inside of mysql into an outfile, the server > > crashes. However if I do a select on the same data to stdout, it works > fine > > most of the time. I am having my terminal program capture the screen > output > > from mysql to a file for each field and editing the records to a format > that > > is easy to insert back in. As you can imagine this is less than ideal, but > > it is the only solution I can come up with at this point. Thanks for your > > help, if you need anything else let me know. > > This sounds strange. I cannot recall a case where a simple SELECT > consistently crashes, while CHECK TABLE reports the table as ok! > > An explanation might be that the .frm file is not the right one for the > table, though I do not understand how the mysql client then could work. > > Best regards, > > Heikki Tuuri > Innobase Oy > http://www.innodb.com > Foreign keys, transactions, and row level locking for MySQL > InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM > tables > > Register now for the 2004 MySQL Users Conference! > http://www.mysql.com/events/uc2004/index.html > This is what I was thinking. I recreated the .frm file after having the problems by creating a new innodb table with the same structure as the original. I was told by someone else the frm for myisam and innodb are the same file. I found the field names in the innodb file by catting through the data file searching, but they are very scattered obviously. I am almost positive I am not missing any fields or even that the field definitions are different because I have a table with the exact same setup. I will keep poking around to see if I can find anything new, but at this point I am almost out of ideas. Thanks for the help. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]