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