Hi Dave, --- "Christensen, Dave" <[EMAIL PROTECTED]> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
