Re: RE: InnoDB and Windows

[Egor Egorov]

Alexandre,
Monday, June 03, 2002, 8:08:14 PM, you wrote:

AZ Maybe this thread has already been solved. If so im sorry for the disturb.

AZ Here is my problem:

AZ I want to use InnoDB transactionnal table types with mysql on Windows 2000 .

AZ I set my ini file correctly, start the console  and my ibdata table is
AZ created and I can now create InnoDB tables.
AZ The problem is I cnat specify the autoincrement option for the Innodb data
AZ file  .

AZ Here is what my ini looks like now :

AZ innodb_data_home_dir = C:\mysql\ibdata

AZ innodb_data_file_path =ibdata1:100M

AZ This setting works perfectly but the ibdata1 file is not autoincrementing
AZ when it is full .

AZ And here is what it should look like to have an auto extending innodb data
AZ file

AZ innodb_data_home_dir = C:\mysql\ibdata

AZ innodb_data_file_path =ibdata1:100M:autoextend:max:2000M


AZ Now if I try this last setting I get a syntax error on  the
AZ innodb_data_file_path  line  when I try to start the Mysql-max server in
AZ console mode.
AZ I know it is supposed to work as said in the manual. Now is it a known bug
AZ on windows platform ???

What version of MySQL server are you using?
Autoextend is only supported since version 3.23.50





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   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

RE: InnoDB and Windows

[Alexandre Zglav]

-Message d'origine-
De : Alexandre Zglav [mailto:[EMAIL PROTECTED]]
Envoyé : lundi, 3. juin 2002 19:05
À : mysql (Elektronikus levelek)
Objet : InnoDB and Windows






Hello all .

Nice to meet you.

Maybe this thread has already been solved. If so im sorry for the disturb.

Here is my problem:

I want to use InnoDB transactionnal table types with mysql on Windows 2000 .

I set my ini file correctly, start the console  and my ibdata table is
created and I can now create InnoDB tables.
The problem is I cnat specify the autoincrement option for the Innodb data
file  .

Here is what my ini looks like now :

innodb_data_home_dir = C:\mysql\ibdata

innodb_data_file_path =ibdata1:100M

This setting works perfectly but the ibdata1 file is not autoincrementing
when it is full .



And here is what it should look like to have an auto extending innodb data
file

innodb_data_home_dir = C:\mysql\ibdata



innodb_data_file_path =ibdata1:100M:autoextend:max:2000M


Now if I try this last setting I get a syntax error on  the
innodb_data_file_path  line  when I try to start the Mysql-max server in
console mode.
I know it is supposed to work as said in the manual. Now is it a known bug
on windows platform ???

Thanks . Any help apreciated .
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.365 / Virus Database: 202 - Release Date: 24.05.2002


-
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