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
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
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
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
