To administer your WestHost account, please enter your
Domain Name or Server Manager Username.

WestHost: Professional Website Hosting Company








Results 1 to 3 of 3
  1. #1
    Member
    Join Date
    Oct 2005
    Location
    RI, USA
    Posts
    49

    Default cannot create table (135) InnoDB

    When I tried to add to a database i am getting the following error:

    Code:
    CREATE TABLE IF NOT EXISTS `admin_assert` (
    `assert_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
    `assert_type` varchar( 20 ) NOT NULL default '',
    `assert_data` text,
    PRIMARY KEY ( `assert_id` )
    ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COMMENT = 'ACL Asserts' AUTO_INCREMENT =1;
    
    MySQL said: Documentation
    #1005 - Can't create table './dbase_name/admin_assert.frm' (errno: 135)
    Can anyone make sense of this?

    Thanks -- Tony
    Tony Lush
    Advance Web Marketing
    Jamestown | RI | USA

  2. #2
    Moderator wildjokerdesign's Avatar
    Join Date
    Jun 2003
    Location
    Kansas City Mo
    Posts
    5,687

    Default

    Tony,

    Do you have InnoDB enabled? http://forums.westhost.com/showthread.php?t=9770
    Shawn
    Please remember your charity of choice: http://www.redcross.org

    Handy Links: wildjokerdesign.net | Plain Text Editors: EditPlus | Crimson

  3. #3
    Member
    Join Date
    Oct 2005
    Location
    RI, USA
    Posts
    49

    Default

    I have discovered that that InnoDB creates several large files unless you configure it in advance to have a file per table. ibdata1 in particular had grown to 2 GB, which is a file limit in Red Hat, so that's why programs were acting funky.

    I found an article about how to salvage the situation here.

    Thanks -- Tony
    Tony Lush
    Advance Web Marketing
    Jamestown | RI | USA

Posting Permissions

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