At 21:14 20/02/2002 -0800, Nilesh Deshpande wrote: Hi, Now I assume that the text you sent is from our documentation. For to build an InnoDB table:
mysql> create table table_name (id int)type=innodb; Query OK, 0 rows affected (0.14 sec) 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
