OK!, first of all, do you have a complete-working directory of mysql in whatever drive you installed mysql?, this is usually in c:\mysql. I asked this because the installer doesn't seems to work. Also there is no need for a my.cnf and a my.ini, you should only use one, one is enough, i rather use my.cnf in c:\
To start mysql, giving that: 1.- my.cnf is in c:\ and correct 2.- you have a complete install in x:\mysql, where x is the drive where you installed mysql go into mysql directory, go to bin, there you have a few choices, 1.-mysqld.exe the standard server 2.-mysqld-max.exe the max server, with bdb and innodb support 3.-mysql-max-nt.exe server, with dbd, innodb and named pipes To start the server type: 1.- mysqld --standalone 2.- mysqld-max --standalone 3.- mysqld-max-nt --standalone To install mysql server as service: 1.- mysqld --install 2.- mysqld-max --install 3.- mysqld-max-nt --install One advice, mysql.com has copies of the mysql server in a zip package, with no installer, is quite easy to install it, i always prefer this method, i just don't like installers :) You just unzip it, edit the my.cnf and copy it to c:\ that's all. Now for the my.cnf, you did move the data dir to somewhere else, did you move your mysql internal data bases to the new locations?? >From you my.cnf: # Uncomment the following rows if you move the MySQL distribution to another > > # location > > basedir = c:/mysql/ > > datadir = c:/SQLData > > did you move the "data" dir to the new location? > C:\MySQL\bin>mysqld --console > > 040109 9:53:02 InnoDB: Started > > 040109 9:53:02 Fatal error: Can't open privilege tables: Table > 'mysql.host' d > > esn't exist > > 040109 9:53:02 Aborting > > > > 040109 9:53:02 InnoDB: Starting shutdown... > > 040109 9:53:04 InnoDB: Shutdown completed > > 040109 9:53:04 mysqld: Shutdown Complete MySQL can't find the internal data bases (tables used to store config data), because it is looking for it in c:\sqldata dir. You must move the data dir inside c:\mysql to c:\sqldata for it to work Hope this works! Best regards from venezuela! -- |...........................................................| |____ _____ ____ _ |Victor Medina M | |\ \ \| ____| _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_____|_| /_/ \_\|ext. 325 | | |geek by nature - linux by choice | |...........................................................|
