I am new to MYSQL want to ask following.:
In our application we are using MYISAM tables but now we are planning to convert all these MYISAM tables to InnoDB tables.Currently we are using MYSQL 3.23 and will be upgrading to 4.0
1. Is there any good documentation available for this i.e.documents for data migration and upgrade??
2.Also what the problems we may come across ??
3.Is it possible that we can have combination of MYISAM as well as Innodb in our application for example If we are having 100 table then out of 100 some may be of MYISAM type and some are of InnoDB type ??