Hi Nilesh, On Thu, 2002-02-21 at 15:14, Nilesh Deshpande wrote: > I am using MySQL database & > I just wanted to use transaction.so as per manual i > have to make table type as Innodb. > > Then i had set Innodb startup options as follows > > innodb_data_file_path = ibdata1:2000M;ibdata2:2000M > innodb_data_home_dir = c:\ibdata > set-variable = innodb_mirrored_log_groups=1 > innodb_log_group_home_dir = c:\iblogs > set-variable = innodb_log_files_in_group=3 > set-variable = innodb_log_file_size=30M > set-variable = innodb_log_buffer_size=8M > innodb_flush_log_at_trx_commit=1 > innodb_log_arch_dir = c:\iblogs > innodb_log_archive=0 > set-variable = innodb_buffer_pool_size=80M > set-variable = innodb_additional_mem_pool_size=10M > set-variable = innodb_file_io_threads=4 > set-variable = innodb_lock_wait_timeout=50
Ok, by the looks of this you're running on Windows (I see c:\.... etc), right? > After this i gave command as > > mysqld-max --standalone --console > > Then it printed somthing like this > > InnoDB: The first specified data file > /home/heikki/data/ibdata1 did not exist: > InnoDB: a new database to be created! > InnoDB: Setting file /home/heikki/data/ibdata1 size to > 134217728 > InnoDB: Database physically writes the file full: > wait... > InnoDB: Data file /home/heikki/data/ibdata2 did not > exist: new to be created > InnoDB: Setting file /home/heikki/data/ibdata2 size to > 262144000 > InnoDB: Database physically writes the file full: > wait... > InnoDB: Log file /home/heikki/data/logs/ib_logfile0 > did not exist: new to be created > InnoDB: Setting log file > /home/heikki/data/logs/ib_logfile0 size to 5242880 > InnoDB: Log file /home/heikki/data/logs/ib_logfile1 > did not exist: new to be created > InnoDB: Setting log file > /home/heikki/data/logs/ib_logfile1 size to 5242880 > InnoDB: Log file /home/heikki/data/logs/ib_logfile2 > did not exist: new to be created > InnoDB: Setting log file > /home/heikki/data/logs/ib_logfile2 size to 5242880 > InnoDB: Started > mysqld: ready for connections Here's where things start getting curious.... I see Unix-style pathnames here, with a /home/heikki/ etc. I don't see that happening on a Windows system, so the question is: where did you start the server? Like by chance on a *nix system you were connected to from the Win box? See, the printed info does not even match up with the config info you posted above.... you configured 2x 2GB data files, but the first one is initialised to something like 134 MB and the second one to 262 MB. I think you're looking at a completely different server there! > After that i tried to create one table by specifying > type as Innodb as follows. > > CREATE TABLE test1 (Id INT, Name CHAR (20)) TYPE = > InnoDB; > > But it is still creating tables in MyISAM? > and even i cant't change table type to INNODB using > alter query?? This is typical of a server that does not have InnoDB support built-in or enabled. I think you have to sort out what you're doing where, make sure you're configuring, starting, and connecting to the same server, and I'm confident that once that is the case, the above problem will disappear. Do let us know on the list how you fare with this.... Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com --------------------------------------------------------------------- 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
