Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    6

    Unanswered: MySQL 4.1.7 Create innodb table

    When I try to create a simple InnoDB table, I have the following error :

    Code:
    ERROR 1005 (HY000): Can't create table './pilote/toto.frm' (Errcode: 121)
    My create query is :

    Code:
    create table toto (
      env_id                    numeric(10,0) not null,
      env_name                  varchar(100) not null,
      auth_password             varchar(100) null,
      env_ipaddr                char(15) null,
      constraint pk_environments primary key (env_id)
    ) type = InnoDB
    Removing the 'constraint' line doesn't make it work better... but if I remove "type = InnoDB" it works...
    "skip-innodb" is commented in my conf file and the rights seem good on the data directory..
    Is there somethinf I'm missing ?

    I'm running gentoo linux on an amd64.
    my_print_defaults mysqld outputs:
    --skip-bdb
    --user=mysql
    --pid-file=/var/run/mysqld/mysqld.pid
    --socket=/var/run/mysqld/mysqld.sock
    --log-error=/var/log/mysql/mysqld.err
    --basedir=/usr
    --datadir=/var/lib/mysql
    --tmpdir=/tmp
    --language=/usr/share/mysql/french
    --skip-locking
    --set-variable=key_buffer=16M
    --set-variable=max_allowed_packet=20M
    --set-variable=thread_stack=128K
    --bind-address=127.0.0.1
    --port=3306

    Thanks in advance for your help
    Last edited by Squatrem; 11-10-04 at 17:47. Reason: Added system information

  2. #2
    Join Date
    Oct 2004
    Posts
    6

    Solution

    Dropping the whole database and recreating it solved this issue...
    I think that the database was created when skip-innodb was still active.

  3. #3
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

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