Jacob, ----- Original Message ----- From: "Devore, Jacob" <[EMAIL PROTECTED]> To: "'Heikki Tuuri'" <[EMAIL PROTECTED]> Sent: Friday, August 16, 2002 12:20 AM Subject: RE: Losing data
> can one change a table from MyISAM tables into something else on the fly? ALTER TABLE tablename TYPE = sometype > Thanks, > > jake Regards, Heikki > -----Original Message----- > From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 2:10 PM > To: [EMAIL PROTECTED] > Subject: Re: Losing data > > > Anna, > > please check with > > SHOW VARIABLES > > if InnoDB is enabled in mysqld. > > Also check with > > SHOW CREATE TABLE tablename > > that your tables really are of the InnoDB type. Error 127 means the 'table > is crashed', and I think only MyISAM type tables can return that error > number. > > An upgrade to 4.0.2 is recommended because 4.0.1 is an alpha version, and > already 8 months old. > > Best regards, > > Heikki Tuuri > Innobase Oy > --- > InnoDB - transactions, row level locking, and foreign key support for MySQL > See http://www.innodb.com, download MySQL-Max from http://www.mysql.com > > > ----- Original Message ----- > From: ""Anna Carlsson"" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.mysql > Sent: Thursday, August 15, 2002 11:33 PM > Subject: Losing data > > > > Hej > > > > I have several databases with several tables in them and all works fine > > except for one database that loses data. > > I'm running mySQL 4.0.1-alpha-nt and the tables are all INNODB. > > The problem is as follows: > > > > Table B references table A by a foreign key. I've filled table A with all > the > > data I want and are adding data to table B. After a couple of items, only > a > > few of the items are still in the table. Sometimes the other items > reappear > > after a couple of minutes, in other cases all items dissapear. Sometimes > when > > I run a select statement I get an error message from the table handler > error > > code 127. But I have no idea what that means. > > > > Has anyone experienced anything like this!? It's just to weird! I have no > > idea what to do and are ready to give up and export it all to linux and > > postgreSQL instead. > > > > Anna > > > > ________________________________________________________________ > > > > This message was sent using SkyBURST Mail Center. > > http://www.skyburst.net > > > > > > > > --------------------------------------------------------------------- > > 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 > > > > > > --------------------------------------------------------------------- > 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 --------------------------------------------------------------------- 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