Bug #3840 not able to make innodb tables

• Submitted: 21 May 2004 0:32
• Modified: 21 May 2004 1:56
• Reporter: shikhar kumar
• Status: Not a Bug
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 4.0.1 alpha
• OS: Windows (windows xp)
• CPU Architecture: Any

[21 May 2004 0:32] shikhar kumar

Description:
 I'm using Foxserv which uses MYSql 4.0.1 alpha ... I'm not able to make innodb tables ....when i try making innodb tables ...mysql automatically converts it to myisam.

How to repeat:
??

[21 May 2004 0:42] MySQL Verification Team

Please verify if your configuration file has
skip-innodb or the create table command is
using type = MyISAM.

Anyway I recommended you for to read the Manual
about the create table syntax.

[21 May 2004 0:48] shikhar kumar

i know the create table syntax and i have done it earlier a many times ...
the only thing new this time is foxserv and 4.0.1 Alpha ...
My.ini seems alright .... and i'm not able to locate my.cnf .. i think its no more  needed 
Can u suggest what i need to do with the my.ini file ???

[21 May 2004 1:16] MySQL Verification Team

You are with an MySQL version pretty older, then
if you can upgrade the version for to work together
with foxserv. Please do.

You can verify if InnoDB is enabled using the mysql.exe
client:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.18-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like "have_innodb";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb   | YES   |
+---------------+-------+
1 row in set (0.00 sec)

mysql> use test;
Database changed
mysql> create table t (id int) type=innodb;
Query OK, 0 rows affected (0.21 sec)

mysql> show create table t\G
*************************** 1. row ***************************
       Table: t
Create Table: CREATE TABLE `t` (
  `id` int(11) default NULL
) TYPE=InnoDB
1 row in set (0.00 sec)

[21 May 2004 1:26] shikhar kumar

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 19 to server version: 4.0.1-alpha-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like "have_innodb";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb   | NO    |
+---------------+-------+
1 row in set (0.02 sec)

The have_innodb variable is showing NO .. how do i fix it ??? should i directly edit it ??

[21 May 2004 1:56] MySQL Verification Team

Verify if you have the \mysql\bin\mysqld-max-nt.exe 
executable and use this server instead of mysqld-nt.exe.
Otherwise the only option you have is to download and
install the latest MySQL version.

[21 May 2004 2:12] shikhar kumar

oh this release seems to be a ultimate trash ...
i'm not even able to run mysql max .... there are problems with mysqladmin also i guess ..
i'm gonna download the stable version 4 and install it now .. no more debugging..

Thanks Miguel for all the help ...
Guys like u are keeping the opensource alive ....

[21 May 2004 2:29] shikhar kumar

i downloaded stable version 4 its working ....thank god and thank u