Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Recovering From A Crashed Database

forums forums SQLyog Using SQLyog Recovering From A Crashed Database

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #13253
      TimothyPaul
      Member

      Hi Folks – I had a MYSQL server crash.  I do not have any backups that are working, but I do have the FRM files.

       

      Is there a way to import them?   Or at the very least see the table structure

       

       

      Thank you….TP

    • #35027
      peterlaursen
      Participant

      First of all, this is a support question for the MySQL server.  In principle we support our own programs (SQLyog and MONyog) and not the MySQL server or any other program from Oracle (or any other vendor). We also do not provide any consultacy services for resolving such problems.

       

      The .frm files do not contain any data. The only contain table definitions and similar. How data are stored depends on the storage engine used (MyISAM or InnoDB – find details here http://dev.mysql.com/doc/refman/5.5/en/storage-engines.html).

       

      It is very unlikely you can solve this problem by just copying files around. 

       

      First of all you should ensure a copy of the complete ‘datadir’ (MySQL data folder) before doing anything else. 

       

      Also the term ‘crash’ can mean a lot of things. InnoDB has automatic crash- recovery (that will work in 99.99% of cases at least).  So I assume that you are using MyISAM? In that case please refer mySQL documentation http://dev.mysql.com/doc/refman/5.5/en/myisam-repair.html.

       

      But basically you should ask this another place, such as the MySQL Forums at http://forums.mysql.com/ for instance. And if somebody should be able to help you, you will have to be much more specific about the problem. What exactly hapenned. And what is now the problem? Will the server not start for instance? Also check the MySQL error log (http://dev.mysql.com/doc/refman/5.5/en/error-log.html) for details.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.