At 19:10 18/10/2001 +0200, [EMAIL PROTECTED] wrote: Hi! I am guessing that you are run the client tool called mysql.exe. The servers of MySQL begin with the name mysqld, then you have in your /mysql/bin directory the following servers:
mysqld-opt.exe mysqld-max.exe mysqld-nt.exe mysqld-max-nt.exe I recommend you to use the mysqld-max-nt.exe running as service on Win2K. This server has the InnoDB table, which provides you with transaction support and other features, however this tables need some configuration variables. Now, create with the notepad.exe, a file on \winnt\my.ini with the following section and keys: [mysqld] basedir=c:/mysql datadir=c:/mysql/data innodb_data_file_path = ibdata1:200M innodb_data_home_dir = c:\ibdata 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=lower_case_table_names =0 set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Notice above that there are some variables where are specified the size of the data and logs files that InnoDB will creates at the first start. Set them, according with your necessities. Now, create manually the directories for to hold the InnoDB stuff: c:\ibdata and c:\iblogs. Install the server as service, with a DOS prompt shell: \mysql\bin\mysqld-max-nt --install Now start the service: net start mysql If you don't want to use InnoDB tables, your my.ini file should be: [mysqld] basedir=c:/mysql datadir=c:/mysql/data skip-innodb You should notice that the sample above, contains paths that you can modify according with your environment. Regards, Miguel >I am a new mysql user. I have been unable to start mysql on my laptop running >Windows 2000. Each time I start mysql, I get the following error: >ERROR 2003: Can't connect to MySQL server on 'localhost' (10061). I have >searched through the archive for earlier mails on this problem. This looks >like >a known problem that has been there for a long time. Is there a solution? > >Thanks in advance! > > >Mohamed > > > > >********************************************************************** >This footnote confirms that this email message has been swept by >MIMEsweeper for the presence of known computer viruses. > >Denne mailen er sjekket for kjente virus, uten at noen ble funnet. > >http://www.hydrotexaco.no >********************************************************************** > >--------------------------------------------------------------------- >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
