mysql> SHOW VARIABLES LIKE "have_innodb";
+---------------+----------+
| Variable_name | Value    |
+---------------+----------+
| have_innodb   | DISABLED |
+---------------+----------+
1 row in set (0.02 sec)

mysql>

===

Goodygood, Victoria !!!
Thank you Sir, 

This saves my keyboard, 

now please, how can I enable this fundamental Value have_innodb?


Yours sincerely 

Morten Gulbrandsen



-----Ursprüngliche Nachricht-----
Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED] 
Gesendet: Donnerstag, 31. Juli 2003 16:01
An: [EMAIL PROTECTED]
Betreff: Re: I Specify explicitly TYPE = InnoDB But My SQL gives me
TYPE=MyISAM ?

"Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote:
> 
> according to what I experience, 
> I do definitely run the default binaries,   perhaps the daemon  mysqld
> has to be started with an option in order to support InnoDB ?
> 
> How can this be investigated ?
> 
> C:\mysql\bin>mysqld  -v
> mysqld  Ver 3.23.55-max-debug for Win95/Win98 on i32
> 
> C:\mysql\bin>mysql  -v
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 264 to server version: 3.23.55-nt
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> 
> mysql> 
> 
> C:\mysql\bin>ver
> 
> Microsoft Windows 2000 [Version 5.00.2195]
> 
> 
> This seems fine to me,  I believe I have the default binaries. 
> 
> If InnoDB is not supported in MySQL, then I would have expected a
> warning,
> Or an error message.
> 
> As we all can see, no warning or error is issued,  
> perhaps another error level can give me more feedback ?
> 

See output of SHOW VARIABLES LIKE "have_innodb".


-- 
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to