Go to this page: http://www.innodb.com/howtouse.html and have a look under: How to create tables in the InnoDB format.hi, i have installed mysql3.23.54 on windows and have followed all instructions as required for using mysqld-max to have transaction support. i have created a table using TYPE=INNODB, but cannot use rollback on it. the error i get in my jsp is "transactions not supported". please advice me on how i can use commit - rollback on mysql database tables. I am connecting to the mysql database thru my java web-app. thank you in advance. regards, nirmal (23 jan 03)
Basically you will at least have to specify this line in C:\WINDOWS\my.ini and restart your mysql-max server:
innodb_data_file_path=ibdata1:30M
All the best,
Pål Arne Hoff
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
