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
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
