InnoDB Table Type?!!

[Ritesh]

SQLyog logs all the query it executes in the History Tab. Please check the query which SQLyog generates in the History tab for creating the table.

We checked your problem on our side and we are able to create InnoDB table without any fuss.

In the Create Table dialog…there will be a Other Properties… button. Please click on it and in the Advanced Table Properties dialog select InnoDB table type.

Hope it helps.

[said_fox]

What's this?

When I create a new table and set its type as InnoDB, then I come back to check its type, I find it as MyISAM type. This means SQLyog cannot create InnoDB table Type?!!

I use Version 3.0 of SQLyog and Version 3.23.54 of MySQL on WinME

So Please any one can Help me?

[said_fox]

Ok, I had already choosed the table type from the advanced table properties, and the situation remains as it is. i.e No InnoDB table type formed. So I'd like to ask, if there any thing may be related with MySQL server itself can adjacet this.

This's a copy of my.ini

#This File was made using the WinMySQLAdmin 1.4 Tool

#22/01/2003 01:24:20 Õ

#Uncomment or Add only the keys that you know how works.

#Read the MySQL Manual for instructions

[mysqld]

basedir=C:/MYSQL

#bind-address=127.0.0.1

datadir=C:/MYSQL/data

#language=C:/MYSQL/share/your language directory

#slow query log#=

#tmpdir#=

#port=3306

#set-variable=key_buffer=16M

[WinMySQLadmin]

Server=C:/MYSQL/bin/mysqld-max.exe

user=saidool9

password=foxhjh2

QueryInterval=10

# You can write your other MySQL server options here

# …

#

innodb_data_home_dir=c:ibdata

# Datafiles must be able to

# hold your data and indexes

innodb_data_file_path=ibdata1:200M;ibdata2:200M

# Set buffer pool size to 50 – 80 %

# of your computer's memory

set-variable=innodb_buffer_pool_size=100M

set-variable=innodb_additional_mem_pool_size=10M

innodb_log_group_home_dir=c:iblogs

# .._log_arch_dir must be the same

# as .._log_group_home_dir

innodb_log_arch_dir=c:iblogs

innodb_log_archive=0

set-variable=innodb_log_files_in_group=3

# Set the log file-size to about

# 15 % of the buffer pool size

set-variable=innodb_log_file_size=10M

set-variable=innodb_log_buffer_size=8M

# Set ..flush_log_at_trx_commit to

# 0 if you can afford losing

# a few last transactions

innodb_flush_log_at_trx_commit=1

set-variable=innodb_file_io_threads=4

set-variable=innodb_lock_wait_timeout=50

The above is a copy of my.ini file in windows

[Ritesh]

Even if you write RAW SQL to create a table of InnoDB type, are you are able to do that?

After creating the table try changing its table type to InnoDB using Change Table Type To option from the table menu.

Hope it helps.

[said_fox]

I have done that ” table>Change table type to>InnoDB”, but also nothing.

When I try to “Manage Relationships” a message is prompt tell

“The Selected table does not have InnoDB table Handler

You cannot manage relationships for the table”

:huh:

[CalEvans]

What does the output of

mysqladmin variables

say? (Only the InnoDB stuff?)

Also, immediately after trying it, check you error log for messages.

If none there, check the regular log if you have logging turned on.

=C=

[Author]

Posts