At 00:57 21/06/2001 +0700, Aa wrote:
Hi,
First create the my.ini file at /WINNT directory.
Edit the following section and keys
[mysqld]
basedir=e:/_db/mysql
datadir=e:/_db/mysql/data
If you want the InnoDB table, below the samples of the keys for the
[mysqld] section:
[mysqld]
basedir=e:/_db/mysql
datadir=e:/_db/mysql/data
innodb_data_home_dir = c:\ibdata
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
set-variable = innodb_mirrored_log_groups=1
innodb_log_group_home_dir = c:\iblogs
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=30M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_log_arch_dir = c:\iblogs
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=80M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50
Pay attention in the following variable:
nnodb_data_file_path = ibdata1:2000M;ibdata2:2000M
The above sample will do InnoDB to create 2 files with 2GB each.
Change the size according with your necessities, so as the maximum
size is 2000M and the minimum is 10M.
Now create the directories for InnoDB's data and logs files:
e:\ibdata and e:\iblogs for example and edit the path for the variables:
innodb_data_home_dir = e:\ibdata
innodb_log_group_home_dir = e:\iblogs
Now for safe:
net stop mysql
mysqld-max-nt --remove
mysqld--max-nt --install
net start mysql
To understand well all the variables involved, read the Manual before
to do the instructions above.
Regards,
Miguel
>Hi,
>
>This is my first comeback to install mySQL on Windows 2000 Server and
>have some trouble on installing mysqld-nt as a service as told in readme
>and looking for some assistant from the expert. I have download the latest
>version of mySQL that is version : 3.23.39-max-nt.
>
>I try to follow step-by-step from the guidance with following sequence :
>
>** change basedir : mysqld-nt --basedir=e:\_db\mysql ... and got the
>following message :
>Can't initialize InnoDB as 'innodb_data_file_path' is not set
>
>** I skip those sequence, continue with registering mysql as a service :
>mysqld-nt --install
>We I check on Service Manager, I can see that mysql service is there but
>not started. When I try to start this service, I got this message :
>
>The MySql service could not be started
>A system error has occurred.
>System error 1067 has occurred.
>The process terminated unexpectedly.
>
>I've been try for couple of times, but still have the same result!, but
>when I try the Testing Sequence :
>- mysqladmin version
>- mysqlshow -u root mysql
>- mysql mysql
>- event I can use mysqlmanager and grant some user
>
>Stranger!!. Please advice, if I did the wrong task or sequence. Thank you
>and looking forward for your assiatance.
>
>
>regards
>
>Aa
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. 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
