Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    3

    Unanswered: Problem configurin InnoDB tables

    Hi all,
    I've got a problem in configuring my.ini file for using InnoDB tables.

    I am using mysql ver. 3.23.49 and winnt ws sp6.

    I read almost everything from the manual and I was not able to solve the problem.(The problem is the same for both mysqd and mysqld-max-nt)

    My 'my.ini' file looks as follows:
    -----------------------
    [mysqld]
    basedir=C:\mysql
    datadir=C:\mysql/data
    innodb_data_home_dir = C:\idb\data
    innodb_data_file_path = ibdata1:50M
    innodb_log_group_home_dir = c:\idb\log
    innodb_log_arch_dir = c:\idb\alog
    --------------

    For initialising Innodb I run the mysqld (or mysqld-max-nt) from the DOS prompt.

    When I use the 'my.ini' file with the lines concerning the InnoDB tables the server does not start and I get the following message in the mysql.err file:

    ---------------------
    InnoDB: Error: you must set the log group home dir in my.cnf the
    InnoDB: same as log arch dir.
    020520 15:47:43 Can't init databases
    ---------------------------------------

    The same thing happens if I use the my.cnf file insted of the my.ini file.

    If I erase the line concerning the InnoDB initialization in the 'my.ini' everything is ok and works.

    Please help me

    Alessio

  2. #2
    Join Date
    May 2002
    Location
    Greece
    Posts
    1
    Hi,

    i had the same problem.
    Rename the mysqld-max-nt.exe to mysqld-nt.exe and try to run the ini file

    [WinMySQLadmin]
    Server=C:/mysql/bin/mysqld-nt.exe
    user= the username you need
    password= the password you need
    [mysqld]
    innodb_data_home_dir=c:\ibdata
    innodb_data_file_path=ibdata1:2000M
    set-variable=innodb_buffer_pool_size=3000M
    set-variable=innodb_additional_mem_pool_size=1500M
    innodb_log_group_home_dir=c:\iblogs
    innodb_log_arch_dir=c:\iblogs
    innodb_log_archive=0
    set-variable=innodb_log_files_in_group=3
    set-variable=innodb_log_file_size=3000M

    good luck
    set-variable=innodb_log_buffer_size=800M
    innodb_flush_log_at_trx_commit=1
    set-variable=innodb_file_io_threads=4
    set-variable=innodb_lock_wait_timeout=50

  3. #3
    Join Date
    May 2002
    Posts
    3

    Now it's OK

    I solved the problem using "/" instead of "\".
    Thanks .

    Alessio

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •