Hi all , I am trying to get transactions support in MySQL , I am trying to get this so that we can use the rollback feature .
here are some technical details that may help u help me , We are using MySql version 4 (which supports Innodb ) O/s : Windows 2000 professional ( Dont kill me for that , i know this is linux forum , but i thought someone might still know ) base dir : C:/mysql data dir : C:/mysql/data I am using this code in my.ini file ------------------------------------------------- [mysqld] innodb_data_home_dir = C://mysql//data ( have tried with single forward slash to , somewhere google said use 2 slashes so tried that too) innodb_data_file_path = ibdata1:10M:autoextend ----------------------------------------------- the error file -------------------------------------------- Mysql error file MySql: ready for connections Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 030504 19:21:00 MySql: Normal shutdown 030504 19:21:00 MySql: Shutdown Complete Thanks in advance for all your help , Nikhil Bhaskaran The 6m Group - Mumbai http://www.the6mgroup.com For cheapest and best webhosting http://webhosting.the6mgroup.com -- http://mm.ilug-bom.org.in/mailman/listinfo/linuxers
