At 11:50 17/08/2001 +0100, Bruce Scharlau wrote:
Hi!
>Thanks for the input Heikki,
>
>I got it the right version mysql-max-nt going now. The problem was that
>winmysqladmin automatically started the wrong service- mysqld - so I had
>to uninstall that service before it would recognise any changed I made in
>the my.ini file done with winmysqladmin.
>
>Now I can use bdb, and show variables gives InnoDB as disabled.
>I've tried setting up the InnoDB variables in winmysqladmin like this, but
>the server won't start:
>
>[mysqld]
>basedir=C:/mysql
>#bind-address=139.133.200.222
>datadir=C:/mysql/data
>language=C:/mysql/share/english
>#slow query log#=
>#tmpdir#=
>#port=3306
>#set-variable=key_buffer=16M
>
># startup parameters for InnoDB tables
>innodb_data_file_path = ibdata1:5M
You need to use a data file >= 10 MB and <= 2GB
Stop the server. Delete all the files from ..\ibadata
and ..\iblogs. Change the value above and restart the
server.
Regards,
Miguel
>innodb_data_home_dir = C:\mysql\data\bruce\ibdata
>set-variable = innodb_mirrored_log_groups=1
>innodb_log_group_home_dir = C:\mysql\data\bruce\iblogs
>set-variable = innodb_log_files_in_group=3
>set-variable = innodb_log_file_size=5M
>set-variable = innodb_log_buffer_size=5M
>innodb_flush_log_at_trx_commit=1
>innodb_log_arch_dir = c:\mysql\data\bruce\iblogs
>innodb_log_archive=0
>set-variable = innodb_buffer_pool_size=5M
>set-variable = innodb_additional_mem_pool_size=5M
>set-variable = innodb_file_io_threads=4
>set-variable = innodb_lock_wait_timeout=50
>
>I created all the directories mentioned, but something is preventing it
>working. If I comment out the InnoDB lines mysql starts.
>
>Thanks in advance.
>
>At 03:16 PM 8/16/2001 +0100, you wrote:
>>Hi all,
>>
>>I'm trying to work out which distribution of mysql supports BDB or InnoDB
>>tables.
>>I've downloaded 3.23.40 and checked 'show variables' asnd it says these
>>tables are not supported.
>>I know the docs say they should be available in the distro, but it seems
>>not in this version. So, who can tell me which one does?
>>
>>Cheers,
>>
>>Bruce
>>
>>
>>---------------------------------------------------------------------
>>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
>
>Cheers,
>
>Dr. Bruce A. Scharlau
>Dept. of Computing Science
>Aberdeen University
>Aberdeen AB24 3UE
>[EMAIL PROTECTED]
>01224 272193
>
>
>---------------------------------------------------------------------
>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
>
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - Săo Paulo, Brazil
<___/ 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