PRASHANT N wrote:
hi,
I need to have 2 DB in our development/production environment which
require both InnoDB and MyISAM engines. This is bacasue, DB1 contains
spatial/geom data which has to be on MyISAM engine and DB2 which
needs transactional support has to be InnoDB.
Now how to achieve this co-existance of both the MyISAM and InnoDB
engines on the same server?
You don't need to do anything special. As long as you enable InnoDB
support (MyISAM is in by default) then just use the TYPE=InnoDB option
on CREATE TABLE or select InnoDB when creating the table in your chosen
GUI admin tool. Tables for which you don't select that will be MyISAM.
--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/
If you find my advice useful, please consider donating to a poor
student! You can choose whatever amount you think my advice was
worth to you. http://tinyurl.com/7oa5s
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
