Professional Web Applications Themes

Table deleted from data directory - MySQL

I had a table with a huge amount of test data. For some reason, I started getting errors that said corrupt key file, try repairing the table. I fired a "repair table blah" and waited for more than 8 hours but the repairing never completed. As I was only working with test data, I decided to drop that table and start anew. The "drop table blah" was also taking forever. Then I finally decided to go inside mysql data directory and did a "rm -rf blah.*". Now when I try to create that table again, I get "ERROR 1105 (HY000): ...

  1. #1

    Default Table deleted from data directory

    I had a table with a huge amount of test data. For some reason, I
    started getting errors that said corrupt key file, try repairing the
    table. I fired a "repair table blah" and waited for more than 8 hours
    but the repairing never completed. As I was only working with test
    data, I decided to drop that table and start anew. The "drop table
    blah" was also taking forever. Then I finally decided to go inside
    mysql data directory and did a "rm -rf blah.*". Now when I try to
    create that table again, I get "ERROR 1105 (HY000): MyISAM table
    'blah' is in use (most likely by a MERGE table). Try FLUSH TABLES.". I
    tried "FLUSH TABLES" and I am waiting for more that 2 hours to let it
    complete.

    Is there any way to fix this problem _without_ restarting the server?

    vijay Guest

  2. #2

    Default Re: Table deleted from data directory

    HI,

    did you look into the mysql error log?
    On unix its somthing like: .../var/mysql/<hostname>.err
    Any proceedings there?

    Toni

    --
    Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner
    A. Guest

  3. #3

    Default Re: Table deleted from data directory

    "vijay" <com> wrote: 

    No. In fact deleting in the datadir with mysqld still running was the
    error. As long as you are *very* sure what you're doing, you must not
    fiddle around with files in the datadir.

    I don't think you will be able to cleanly shutdown mysqld anyway. You
    can try kill -USR1 or even kill -KILL. But probably you will end up
    with garbage in your tables.


    XL
    --
    Axel Schwenke, Support Engineer, MySQL AB

    Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
    MySQL User Forums: http://forums.mysql.com/
    Axel Guest

Similar Threads

  1. Replies: 0
    Last Post: June 1st, 03:15 AM
  2. Replies: 4
    Last Post: October 27th, 03:01 PM
  3. how many deleted records has a table
    By Ronald in forum Oracle Server
    Replies: 4
    Last Post: October 31st, 08:01 AM
  4. Modem ISP data deleted during XP download
    By Pat in forum Windows Networking
    Replies: 0
    Last Post: July 7th, 02:03 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139