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]