Ok, I'm an idiot. I had datadir = c:/_data/mysql/ when I should have had datadir = c:/_data/mysql/data/
I had some help though (I can't place all the blame on myself, ego issues ya know). I find this paragraph utterly confusing in MySQL Ref. Manual version 4.0.2-alpha See "Node Windows prepare environment" #----------------------------------------- [mysqld] basedir=the_install_path #e.g. c:/mysql datadir=the_data_path #e.g. c:/mysql/data or d:/mydata/data If the data directory is other than the default c:\mysql\data, you must cut the whole \data\mysql directory and paste it on the your option new directory, e.g.: d:\mydata\mysql. #----------------------------------------- And, many of the user comments listed here: http://www.mysql.com/doc/N/T/NT_start.html seem to indicate there were problems when trying to _install_ in a non-standard location. There _may_ be. But, it seems the datadir path is respected (works) fine (although I didn't try a path name with spaces) Miguel, Thanks again for your time. Thanks to your persistance I have MySQL installed with the data where I want it. :) -Ryan >[Chop] > I need to confess you, that until now I didn't have in my mind to > use a directory name like __work. However I created the f:\__work dir > (on my machine I have the Win2K on F:), cut/paste the whole directory > \mysql\data to \__work and modified the my.ini for to have the datadir > like: datadir=f:\__work\data (notice that you did c:\__work\data\mysql). > > With the changes above, I ran the server without any problem. > > Regards, > Miguel > > >I get the same error. Note: I did copy the c:\mysql\data tree (with all > >files to the non-standard location and modified the my.ini). > > > >Anyway, I went back to the original machine and got it working by pointing > >back to the standard c:\mysql\data dir for all files.... > > > >I don't like this but, it works.... > > > >Thanks Anyway For Your Response, > >-Ryan > > > >[Chop] --------------------------------------------------------------------- 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