Hello, This is the my.cnf that I use in my syste. It is located in C:\. You can use it as guide.
#### Start ################################################## #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=D:/MySql datadir=D:/MySql/data log-bin=D:/mysql/Data/mysqllogs/binarylog log-bin-index=D:/mysql/Data/mysqllogs/binaryindex binlog-do-db=GGData local-infile=1 #InnoDB Settings innodb_data_home_dir = D:/MySql/GGData innodb_data_file_path = ggdata1:20M;ggdata2:20M;ggdata3:20M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = D:/MySql/GGData/logs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=3M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = D:/MySql/GGData/logs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=5M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=60 ### End ############################################################ Make sure that the InnoDB directories exists in your computer, both the data_home_dir and the log_group_home_dir. Also make sure to delete the my.ini that was probably created in your windows directory. After you create the directories and the my.cnf file just open a dos windows and from the bin directory run mysqld or mysqld-max. Hope this helps JFernando *** sql *** -----Original Message----- From: Nikki Mason [mailto:nikki_mason@;btopenworld.com] Sent: October 21, 2002 15:22 To: Miguel Angel Solórzano Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Fw: Which files to download/install - problems running MySQL My email below was rejected for some reason, so I am trying again to send it. Regards, Nikki ----- Original Message ----- From: Nikki Mason <[EMAIL PROTECTED]> To: Miguel Angel Solórzano <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, October 20, 2002 8:41 AM Subject: Re: Which files to download/install - problems running MySQL > Miquel, > > I tried what you suggested, but still it didn't work properly. > > For the server: > C:\>cd mysql\bin > > C:\mysql\bin>mysqld-opt --standalone --console > 021020 8:20:30 InnoDB: Out of memory in additional memory pool. > InnoDB: InnoDB will start allocating memory from the OS. > InnoDB: You may get better performance if you configure a bigger > InnoDB: value in the MySQL my.cnf file for > InnoDB: innodb_additional_mem_pool_size. > > The cursor did not return to the prompt to allow anymore commands to be > typed. > (I haven't created a c:\my.cnf or c:\windows\my.ini) > > For the client: > C:\mysql\bin>mysql -uroot -p > Enter password: **** > > Again, nothing more was displayed on the screen and the cursor did not > return to the prompt to allow anymore commands to be typed. > > Regards, > Nikki Mason > > ----- Original Message ----- > From: Miguel Angel Solórzano <[EMAIL PROTECTED]> > To: Nikki Mason <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Saturday, October 19, 2002 9:29 PM > Subject: Re: Which files to download/install - problems running MySQL > > > At 15:16 19/10/2002 +0100, Nikki Mason wrote: > Hi, > >Hi, > > > >I wish to learn SQL, and as some of my friends already use MySQL, they > >recommended that I too use it. Please can you tell me what I need to > >download and install to get me going. > > > >I have: > >Pentium III 450Mhz, 256Mb Ram > >Windows 98 > >I don't have a C or C++ compiler installed. > >My PC is not connected to a network - it is standalone. > > > >I had earlier downloaded just the zip file for version 4.0.4-beta > (Windows). > >I unzipped it and ran the 'setup' program. > > > >Once setup had completed I tried the test on the server - at no point had I > >run the Admin program or created the my.cnf or my.ini. > > > >I opened a dos window and from the directory c:\mysql\bin entered: > >mysqld --standalone > > > >No other text was shown in the dos window and it appeared to hang. The > >whole computer also seemed to 'hang'. I had to use ctrl C to kill the > >application and get back normal operation to my PC. > > Why you had killed the mysqld server ?. The mysqld.exe is a console > application that when started with --standalone option it works in > the background. > > If you want to see the console screen then issue: > > C:\mysql\bin>mysqld-opt --standalone --console > 021019 17:25:31 InnoDB: Started > mysqld-opt: ready for connections > > and for to work with the mysql client: > > C:\>c:\mysql\bin\mysql -uroot -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 1 to server version: 3.23.53-max > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> > > after a fresh installation left the root password blank. > > for to shutdown the server: > > > C:\>c:\mysql\bin\mysqladmin shutdown > > 021019 17:27:27 mysqld-opt: Normal shutdown > > 021019 17:27:27 InnoDB: Starting shutdown... > 021019 17:27:29 InnoDB: Shutdown completed > 021019 17:27:29 mysqld-opt: Shutdown Complete > > > > > >I then tried manually creating the file c:\my.cnf and populated with the > >information given in the installation instructions. The server still hung. > > > >I then tried using the admin program with the similar results - the green > >traffic light was showing, but the dos window that was displayed appeared > >'hung' and again the PC itself seemed to have hung - it operated extremely > >slowly. The task manager showed the admin tool as 'not responding'. > > > >What have I/am I doing wrong? > > -- > Regards, > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Miguel Angel Solórzano <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer > /_/ /_/\_, /___/\___\_\___/ 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 --------------------------------------------------------------------- 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 <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
