Re: mysql and innoDB

[Heikki Tuuri]

Stefan,
InnoDB is included in all MySQL-4.0 downloads from http://www.mysql.com. I 
do not know if it is included in the mysqld binary that comes with the SuSE 
Linux 9.0 distro.

If you are using a download from www.mysql.com, you probably have the line
skip-innodb
in your my.cnf, or it may also be that InnoDB is not able to create its 
ibdata and ib_logfiles. Look what mysqld prints when it starts.

Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM 
tables
http://www.innodb.com/order.php

Order MySQL technical support from https://order.mysql.com/
----- Original Message ----- 
From: "Gary Richardson" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, October 21, 2004 7:46 PM
Subject: Re: mysql and innoDB


Is there any output from the command? Any errors?
Try SHOW CREATE TABLE xxxxx. It should show you the TYPE=3D at the end.
out.
On Thu, 21 Oct 2004 11:10:10 +0200, Stefan Gnann
<[EMAIL PROTECTED]> wrote:
Hi all,
=20
I have a mysql database 4.0.15 on a suse linux 9.x system running.
Now we have to use the features of InnoDB tables (rollback, a.s.o.).
Up to now we use the standard table type MyISAM.
Now I want to change the tabel type with the command "ALTER TABLE xxxxx 
T=
YPE
=3D InnoDB".
The command doesn=B4t show any effect !!!
=20
What can I do to change the table type?
What did I have to do to change the table type??
=20
best regards
=20
   Steve
=20
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]
mail.com
=20
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]