MyISAM and InnoDB co-existance
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? regards shann ___ What is the largest island in the Mediterranean Sea? http:// -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyISAM and InnoDB co-existance
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]
Re: MyISAM and InnoDB co-existance
hi, thnaks for the speedy reply. I already have both the DBs in my server. is there any way/method that the DB2 which needs transaction support can be converted from myisam to innodb format without any hitch regards shann ___ Which famous author was once captured by pirates and sold as a slave? http:// -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyISAM and InnoDB co-existance
PRASHANT N wrote: thnaks for the speedy reply. I already have both the DBs in my server. is there any way/method that the DB2 which needs transaction support can be converted from myisam to innodb format without any hitch http://dev.mysql.com/doc/mysql/en/alter-table.html I would strongly recommend that if you are running a MySQL server in a production environment you familiarise yourself with the above manual, or you *will* run in to problems. -- Jasper Bryant-Greene Freelance web developer http://jasper.bryant-greene.name/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]