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

Recover Droped Database

forums › forums › SQLyog › Using SQLyog › Recover Droped Database

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • February 5, 2007 at 9:36 pm #10166
      FernaN
      Member

      Is there a way to recover a droped database?

      I forgot to backup my database.

      Please help me…

    • February 6, 2007 at 5:21 am #23367
      peterlaursen
      Participant

      If the table is a MyISAM table then there is a chance that traditional file system recovery tools can recover.  For each database there is a .frm, .MYD and .MYI file.  You will need them all.

      I do not think there is any chance with InnoDB.  Here all databases share the same tables

      ace unles you have enabled the 'innodb file per table' -option in configuration.

      And the more you use this computer the bigger chance there is that the Hard Disk area form where you need to recover the files will be overwritten.  Also do not defragment the hard disk untill you have recovered!  

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