At 21:14 20/02/2002 -0800, Nilesh Deshpande wrote: Hi!
Very strange the printed messages you sent. What MySQL release version are you using ? I did the test with your start InnoDB set with 3.23.48 and got: c:\mysql\bin>mysqld-max --standalone --console InnoDB: The first specified data file c:\ibdata\ibdata1 did not exist: InnoDB: a new database to be created! 020221 2:42:46 InnoDB: Setting file c:\ibdata\ibdata1 size to 200 MB InnoDB: Database physically writes the file full: wait... 020221 2:42:59 InnoDB: Data file c:\ibdata\ibdata2 did not exist: new to be cr eated 020221 2:42:59 InnoDB: Setting file c:\ibdata\ibdata2 size to 200 MB InnoDB: Database physically writes the file full: wait... 020221 2:43:13 InnoDB: Log file c:\iblogs\ib_logfile0 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile0 size to 30 MB InnoDB: Database physically writes the file full: wait... 020221 2:43:15 InnoDB: Log file c:\iblogs\ib_logfile1 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile1 size to 30 MB InnoDB: Database physically writes the file full: wait... 020221 2:43:18 InnoDB: Log file c:\iblogs\ib_logfile2 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile2 size to 30 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 020221 2:43:30 InnoDB: Started mysqld-max: ready for connections Notice the paths of the files. You showed: /home/heikki/data/ibdata1 did not exist: The above is should be the Heikki's Unix machine !. Please send for us the release version and the complete configuration data file (my.ini/my.cnf). Regards, Miguel >Dear sir, > >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 > >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 c >reated >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 c >reated >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 c >reated >InnoDB: Setting log file >/home/heikki/data/logs/ib_logfile2 size to 5242880 >InnoDB: Started >mysqld: ready for connections > >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?? > >so any one can please tell me, if i missed any >steps???? > > > >__________________________________________________ >Do You Yahoo!? >Yahoo! Sports - Coverage of the 2002 Olympic Games >http://sports.yahoo.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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil <___/ 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
