At 18:21 04/03/2002 -0500, [EMAIL PROTECTED] wrote: Hi, >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 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 > > >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 -- 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 --------------------------------------------------------------------- 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
