Menu

#2707 (ok 2.11.8) export fails if one table is marked as crashed

2.11.4
fixed
1
2013-06-11
2008-06-10
No

I have a table in the following condition:

MySQL said: #144 - Table '.\xaangst_dbo\credencial' is marked as crashed and last (automatic?) repair failed

I do not know how to reproduce a table crash (this one was imported with MySQL migration tool from MS SQL MSDE 2000), but exporting the entire database seems to end successfully with no error messages at all. But at the end of the dump file you can find the page (as in, HTML code) that would display the error mentioned previously when trying to view the contents of the table:

<br />
<b>Warning</b>: Cannot modify header information - headers already sent by (output started at C:\xampp\phpMyAdmin\export.php:190) in <b>C:\xampp\phpMyAdmin\libraries\ob.lib.php</b> on line <b>83</b><br /> [...] <code>
#144 - Table '.\nahrin_dbo\credencial' is marked as crashed and last (automatic?) repair failed
</code>
...etcetera

A dump of all the normal tables with a warning for the ones that can't be imported would be nice.

Discussion

  • Marc Delisle

    Marc Delisle - 2008-06-26
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2008-06-26

    Logged In: YES
    user_id=210714
    Originator: NO

    Fixed in subversion, thanks for reporting.

     
  • Marc Delisle

    Marc Delisle - 2008-06-26
    • priority: 5 --> 1
    • summary: export fails if one table is marked as crashed --> (ok 2.11.8) export fails if one table is marked as crashed
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2008-07-28
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed