Asep Andria I.W. wrote:

I have MySQL Server 3.23.xx running on RedHat Linux 9 with 40GB
harddrive and 256 RAM. I'm using MyISAM table type with around 157
tables. I think i decided to change MyISAM table to InnoDB table. But, I don't
know how to do that for the first step. I have read a section on MySQL
documentation about InnoDB but still not clearly about that. My existing
database is still 40 Mb but would be growing fast. This database have
been running about 6 month and used for critical production.


Thanks in advance and for your help.



Itīs simple to convert a table to innodb.
Just do this:

alter table your_table type=innodb;

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



Reply via email to