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
---------------------------------------------------------------------
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
