Sorry,
Alter table toto ENGINE=innodb.
You don't must, you can. You can also have differents storage ENGINES in
the same mysql database.
With innodb, you will earn ROW level locking.
Best Regards
--------------------
Mathias FATENE
Hope that helps
*This not an official mysql support answer
-----Original Message-----
From: mathias fatene [mailto:mfatene@stripped]
Sent: lundi 25 avril 2005 19:33
To: 'Carl Riches'; 'mysql@stripped'
Subject: RE: Converting to InnoDB?
Yes, but your myIsam Tables stay myisam ones.
After restarting, you must change them to innodb by :
Alter table toto storage=innodb.
For new tables, they will have innodb storage.
Best Regards
--------------------
Mathias FATENE
Hope that helps
*This not an official mysql support answer
-----Original Message-----
From: Carl Riches [mailto:riches@stripped]
Sent: lundi 25 avril 2005 19:26
To: mysql@stripped
Cc: Carl Riches
Subject: Converting to InnoDB?
We are running MySQL on Red Hat Enterprise Linux 3, using the Red Hat-
supplied RPM file mysql-server-3.23.58-2.3. Our current MySQL
configuration has MyISAM as the default database file type. I would
like
to change this such that InnoDB is the default. My understanding of the
documentation says that, after changing the configuration file and
restarting the MySQL server, there will be no problems using the
existing
MyISAM databases.
Is that correct?
Thanks,
Carl G. Riches
Software Engineer
Department of Mathematics
Box 354350 voice: 206-543-5082 or 206-616-3636
University of Washington fax: 206-543-0397
Seattle, WA 98195-4350 internet: riches@stripped
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
