Hi Dave,
--- "Christensen, Dave" <DChristensen@stripped>
wrote:
> Did you set up a my.ini file in your Windows
> directory? If so, what is in
> the file?
I found the problem about why I was not able to get my
WinMySQLadmin tool to start the service. My my.ini
contents are below this email the password x'd out.
For some reason, I had told WinMySQLadmin to write the
file to D:/MySQL/share/english instead of
C:/MySQL/share/english. I've also verified that my.ini
is living in C:\WINNT. The green light on
WinMySQLadmin is now lit instead of the red light! :)
With the green light lit, can I assume that the
mysqld-nt is now running as a service or do I have to
start myself?
Now, when I type in the DOS shell:
C:\mysql\bin>mysqld --console
I get this. Is this correct?
Cannot initialize InnoDB as 'innodb_data_file_path' is
not set. If you do not want to use transactional
InnoDB tables, add a line skip-innodb to the [mysqld]
section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add for
example, innodb_data_file_path =
ibdata1:30M:autoextend But to get good performance you
should adjust for your hardware the InnoDB startup
options listed in section 2 at
http://www.innodb.com/ibman.html
mysqld: ready for connections
Then, I tried to do this DB creation and
post-installation testing, but mysql_install_db and
mysqld_safe are not in my scripts directory:
For a binary distribution (not RPM or pkg packages),
do this:
shell> cd mysql_installation_directory
shell> ./scripts/mysql_install_db
shell> ./bin/mysqld_safe --user=mysql &
Here is the content of my my.ini file. Where to go
from here?, Thanks, Scott
:
#This File was made using the WinMySQLAdmin 1.4 Tool
#6/24/2003 5:42:24 PM
#Uncomment or Add only the keys that you know how
works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=C:/mysql
bind-address=169.254.81.137
datadir=C:/mysql/data
language=C:/MySQL/share/english
#slow query log#=
#tmpdir#=
port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=scott
password=xxxxxx
=====
Scott D. Spiegler
President
Innovative Technical Solutions
Pawtucket, RI 02861
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
