Results 1 to 4 of 4

Thread: FLUSH Table?

  1. #1
    Join Date
    Aug 2003
    Location
    Reston, VA
    Posts
    59

    Unanswered: FLUSH Table?

    Hey All,

    I'm trying to restore functionality to a table, but not having much luck. Basically, after running a CHECK TABLE I found some issues. The associated table files (.frm, .MYD, .MYI) were all backed up. Issued a REPAIR TABLE to fix the table. After running CHECK TABLE it looks like all the issues were gone. However, the associated table files were replaced with the backups (no, mysqlhotcopy was not used - bad, I know). The replaced files contained the information needed. Unfortunately, everytime I run a count query i get 0 records. I ran FLUSH TABLE, but that wasn't working either. Any ideas???

    Many thanks...

  2. #2
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Re: FLUSH Table?

    Originally posted by DrSmartman
    Hey All,

    I'm trying to restore functionality to a table, but not having much luck. Basically, after running a CHECK TABLE I found some issues. The associated table files (.frm, .MYD, .MYI) were all backed up. Issued a REPAIR TABLE to fix the table. After running CHECK TABLE it looks like all the issues were gone. However, the associated table files were replaced with the backups (no, mysqlhotcopy was not used - bad, I know). The replaced files contained the information needed. Unfortunately, everytime I run a count query i get 0 records. I ran FLUSH TABLE, but that wasn't working either. Any ideas???

    Many thanks...
    Which version of MySQL are you using?
    What OS the server runs on?
    Have you tried an extended check?

  3. #3
    Join Date
    Aug 2003
    Location
    Reston, VA
    Posts
    59
    Hi bstjean,

    Thanks for the reply (again). We are running MySQL 3.23 on Red Hat Linux 7.3. I'm not sure I'm familiar with an Extend Check. What does it do? I suppose I'll read the MySQL documentation on that.

    The table is repaired, but I can't get the records to show up. I'm thinking I just need to "reload" the table or something. But how? We may try to restart MySQL...restarting seems to do the trick sometimes. Thought there'd be a way to restart (refresh or reload) a table. I thought that is what FLUSH TABLE did.

    Anyway, thanks again for the response and continued help. It is much appreciated.

    Best Regards,
    DrSmartman

  4. #4
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1
    Originally posted by DrSmartman
    Hi bstjean,

    Thanks for the reply (again). We are running MySQL 3.23 on Red Hat Linux 7.3. I'm not sure I'm familiar with an Extend Check. What does it do? I suppose I'll read the MySQL documentation on that.

    The table is repaired, but I can't get the records to show up. I'm thinking I just need to "reload" the table or something. But how? We may try to restart MySQL...restarting seems to do the trick sometimes. Thought there'd be a way to restart (refresh or reload) a table. I thought that is what FLUSH TABLE did.

    Anyway, thanks again for the response and continued help. It is much appreciated.

    Best Regards,
    DrSmartman
    Plenty of ways/tricks to do the job... Check these links...

    http://www.mysql.com/doc/en/Repair.html
    http://www.mysql.com/doc/en/REPAIR_TABLE.html
    http://www.mysql.com/doc/en/Corrupte...AM_tables.html
    http://www.mysql.com/doc/en/Using_mysqlcheck.html
    http://www.mysql.com/doc/en/Table_maintenance.html

    Hope this helps!

Posting Permissions

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