Monday, February 25, 2013

How to repair damaged MySQL database when everything else fails

Have your MySQL database got corrupted? Are you tired of trying every possible solution and nothing works or worse and you don’t have even updated backup of your database. Don’t stress! Your data is safe. You can try an amazing third party tool named Stellar Phoenix database repair for MySQL. It repairs damaged innodb and myisam tables in all possible cases of corruption. Using this tool you can repair damaged database created on both Windows and Linux OS.
Steps to repair damaged database using Stellar Phoenix database repair for MySQL on Windows:
  1. Select database: Select the database that you want to repair. There are two option for selecting a database.
  • Automatic: In automatic selection it will automatically select the database from default configuration location of MySQL.
  • Manual: In manual selection you have to manually select the database from the location where your corrupt file is stored.


  1. Scan: After selecting the database, click on the Scan button to start scanning of database.


  2. Preview: You can also see the preview of repairable objects in a tree like structure.
  3. Repair: Now click on Repair button from the File menu.
  4. Save: The repaired database file will be saved in a new folder at the same location where you have installed MySQL database.
Steps to repair damaged tables using Stellar Phoenix database repair for MySQL:
  1. In Linux, copy the ibdata1 and database folder from the location \var\lib\MySQL and paste it in your Windows system.
  2. Run the software.
  3. After recovery, copy the recovered database and database folder back in your Linux system at the same location \var\lib\MySQL.



4 comments:

  1. Glorious Live design philosophy is based on versatility and glamour with a clear focus on creating outfits to make each woman feel beautiful in whatever she wears. We also provide custom made design as per your requirement.
    GloriousLive.Net

    ReplyDelete
  2. We are the one who have development team behind Pakistan's largest media websites and who made wesbites which are busiest and most famous in Pakistan and very high ranking in Alexa and SEO point of view.
    Reserver Your Website Now...

    ReplyDelete
  3. Get Stellar Phoenix Database Repair for MySQL software can repair all the corrupt databases and restore the data from unreadable table and table spaces. It allows the user to recover the database completely and it ensures recovery of tables and other objects without changing original format.


    ReplyDelete