Hi Miguel, Yes, they are there. Already had the my.ini set up in c:\winnt since I needed to specify a non-standard location for my data files. (I used the medium conf. file included with the binaries as a starting point).
UPDATE: I decided to try the install on a different Win2k machine slightly different build. It worked with files in standard location specified in a my.ini (c:\mysql\data). I added innodb support. Still worked. However, when I tried to change the data output to c:\__work\data\mysql... 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 On Mon, 4 Mar 2002, Miguel Angel Solorzano wrote: > At 13:22 04/03/2002 -0500, [EMAIL PROTECTED] wrote: > Hi! > >Hi All, > > New to mysql. Running: Win2k as Administrator > > mysql-3.23.49-win.zip (binaries) > > > > Keep getting error (complete output below sig): > > mysqld: Table 'mysql.host' doesn't exist > > Take a look in the \mysql\data\mysql directory if there are > the grant tables, like below: > > Microsoft Windows 2000 [Versão 5.00.2195] > (C) Copyright 1985-1999 Microsoft Corp. > > f:\>dir f:\mysql\data\mysql > O volume na unidade F é WIN2K > O número de série do volume é 8C89-59D6 > > Pasta de f:\mysql\data\mysql > > 04/03/2002 10:07 <DIR> . > 04/03/2002 10:07 <DIR> .. > 06/10/2001 19:33 8.778 columns_priv.frm > 06/10/2001 19:33 0 columns_priv.MYD > 06/10/2001 19:33 1.024 columns_priv.MYI > 06/10/2001 19:33 8.982 db.frm > 06/10/2001 19:33 151 db.MYD > 06/10/2001 19:33 3.072 db.MYI > 06/10/2001 19:33 8.641 func.frm > 06/10/2001 19:33 0 func.MYD > 06/10/2001 19:33 1.024 func.MYI > 06/10/2001 19:33 8.958 host.frm > 06/10/2001 19:33 0 host.MYD > 06/10/2001 19:33 1.024 host.MYI > 06/10/2001 19:33 8.877 tables_priv.frm > 06/10/2001 19:33 0 tables_priv.MYD > 06/10/2001 19:33 1.024 tables_priv.MYI > 06/10/2001 19:33 9.148 user.frm > 06/10/2001 19:33 428 user.MYD > 06/10/2001 19:33 2.048 user.MYI > 18 arquivo(s) 63.179 bytes > 2 pasta(s) 17.428.426.752 bytes disponíveis > > If you don't find them, re-install the MysQL stuff again. > > Before to run the server, delete the first files that InnoDB > has created. > > Create manually two directories (for the InnoDB data\log files): > > c:\ibdata and c:\iblogs > > Now create on \winnt the file called my.ini and edit the below > contents: > > [mysqld] > basedir=c:/mysql > datadir=c:/mysql/data > innodb_data_file_path = ibdata1:200M > innodb_data_home_dir = c:\ibdata > set-variable = innodb_mirrored_log_groups=1 > innodb_log_group_home_dir = c:\iblogs > set-variable = innodb_log_files_in_group=3 > set-variable = innodb_log_file_size=30M > set-variable = innodb_log_buffer_size=18M > innodb_flush_log_at_trx_commit=0 > innodb_log_arch_dir = c:\iblogs > innodb_log_archive=0 > set-variable = innodb_buffer_pool_size=5M > set-variable = innodb_additional_mem_pool_size=5M > set-variable = innodb_file_io_threads=4 > set-variable = innodb_lock_wait_timeout=50 > > Notice above the files sizes and memory values which you should > change according with your machine and necessities. > > Start the server. > > Regards, > Miguel > > > -- > For technical support contracts, goto https://order.mysql.com/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Miguel A. Solórzano <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer > /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil > <___/ www.mysql.com > > |------------------------------------------------| | Ryan Russo | | Academic Computing Web Group, (518) 442-4772 | |------------------------------------------------| --------------------------------------------------------------------- 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
