|
Thanx for yr help
but now One more problem comes, that is descibed below
C:\>mysqld
InnoDB: operating system error number 3 in a
file operation.
InnoDB: operating system error number 3 in a file
operation.
InnoDB: Error in creating or opening
c:\iblogs\ib_logfile0
010629 19:50:14 Can't init
databases
C:\>mysqld
InnoDB: Log file .\ib_logfile0 did not exist:
new to be created
InnoDB: Setting log file .\ib_logfile0 size to
5242880
InnoDB: Log file .\ib_logfile1 did not exist: new to be
created
InnoDB: Setting log file .\ib_logfile1 size to
5242880
InnoDB: Cannot initialize created log files
because
InnoDB: data files are corrupt, or new data files
were
InnoDB: created when the database was started
previous
InnoDB: time but the database was not shut
down
InnoDB: normally after that.
010629 19:53:46 Can't
init databases
How can I remove these errors?
Can u plz give me a my.cnf file?
thanx
byee
-------Original
Message-------
Date: Saturday,
June 30, 2001 06:26:40 AM
Subject: Re:
Problem in initializing mySQL on Windows Plateform
You did not put the
line
[mysqld]
before the server options so the server
knows which lines belong to it.
Bhartendu Maheshwari
wrote:
> Hello
>
> I had installing mySQL as
well myODBC, but when I run mysqld it has given an
>
error
>
> C:\>mysqld
> error: Found option
without preceding group in config file: c:\my.cnf at
> line:
1
> Program aborted
>
> Next time I had write a
file my.cnf as
>
> innodb_data_file_path =
ibdata1:400M;ibdata2:400M
> innodb_data_home_dir =
c:\mysql
> 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=8M
>
innodb_flush_log_at_trx_commit=1
> innodb_log_arch_dir =
c:\iblogs
> innodb_log_archive=0
> set-variable =
innodb_buffer_pool_size=80M
> set-variable =
innodb_additional_mem_pool_size=10M
> set-variable =
innodb_file_io_threads=4
> set-variable =
innodb_lock_wait_timeout=50
>
> Since my harddisk have
only 900MB free space. So i choose
> innodb_data_file_path to
be 400MB each. Now when I again run mysqld, It has
> given
again error as
>
> C:\>mysqld
> Can't
initialize InnoDB as 'innodb_data_file_path' is not set
>
> Now Please tell me what to do?
>
> Thank
you
--
Gerald L. Clark
[EMAIL PROTECTED]
| 
