Free Download MySQL Recovery Tool to Recover MySQL Database

You are going to learn two ways to recover MySQL database for free. You can run EaseUS MySQL database recovery software to recover MySQL database files after deletion, careless format, system crash on PC and servers. This software supports recovering FRM, MYD, MYI files. You can also recover MySQL with Binlog.

 Download for Win Recovery Rate 99.7%
 Download for Mac Trustpilot Rating 4.4

Table of Contents

2 Ways to Recover MySQL Database Files (with Pictures)

Don't worry if you lost files or data from the MySQL database. You can perform MySQL recovery with a tool, or with Binlog.

Workable Solutions Step-by-step Troubleshooting
1. Recover MySQL with Reliable Tool
  1. 1. Select a location and start scanning.
  2. 2. Preview and select the files.
  3. 3. Recover lost data...Full steps
2. Recover MySQL from Binlog
  1. 1. log in to MySQL and use the command to view Binlog.
  2. 2. Find the wrong statement in Binlog.
  3. 3. Recover MySQL from Binlog.
  4. 4. Recover data to MySQL...Full steps

What Is MySQL Database

A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as MySQL Server. Since computers are very good at handling large amounts of data, database management systems play a central role in computing, as standalone utilities, or as parts of other applications.

what is MySQL database

MySQL is a relational database management system (RDBMS) based on SQL (Structured Query Language). First released in January 1998, MySQL is now one component of parent company MySQL AB's product line of database servers and development tools. It is used in a wide range of applications, including data warehousing, e-commerce, Web databases, logging applications, and distributed applications. Now, it becomes the world's most popular open-source database because of its fast performance, high reliability, ease of use, and dramatic cost savings.

The Best MySQL Database Recovery Software (Recommended)

MySQL database files usually end with an extension of FRM, MYD, MYI. The *.frm files contain the table definitions. The *.myi files are MyISAM index files. The *.myd files contain the table data. Similar to other types of data, you may lose your MySQL files due to accidental deletion, careless formatting, partitions loss, system crash, and virus infection. Even when you make every effort to avoid it, the data loss misery still happens.

Then, how to recover MySQL data when the problem occurs but you don't a backup? Here, our advice is to try data recovery software. And we recommend EaseUS Data Recovery Wizard. It can deal with various data loss situations and recover the MySQL database file from it. Besides, it has many highlights:

EaseUS Data Recovery Wizard

  • Recover deleted, formatted, and inaccessible data in different data loss situations.
  • Recover files from formatted hard drive, emptied recycle bin, memory card, flash drive, digital camera, and camcorders
  • Recover word files, photos, audio, music, and emails from any storage effectively.
 Download for Win Recovery Rate 99.7%
 Download for Mac Trustpilot Rating 4.4

How to Recover MySQL with EaseUS MySQL Data Recovery Tool

Download this hard disk data recovery software and get back lost MySQL data as soon as possible. Launch it and follow the next simple steps to recover lost MySQL files.

Step 1. Select a location and start scanning

Launch EaseUS Data Recovery Wizard, hover on the partition where you lost data, then click "Scan".

select a location and click scan

Step 2. Preview and select the files

Wait until the scanning completes. The Filter helps you find the files you want more quickly. If you need to preview the file, double-click the item you attempt to recover.

Choose files to recover

Step 3. Recover lost data

Click "Recover", choose a location to save the recovered data, then click "OK". You should store the data in another place instead of the original one.

Recover lost data

If you have other data loss problems, you can also download this MySQL file recovery software to get back pictures, videos, documents with simple clicks.

How to Recover MySQL from Binlog

The prerequisite for recovering data from Binlog is that the MySQL Binlog must be turned on. If the Binlog log is not turned on, ignore this method. You can check the MySQL configuration file if Binlog is enabled. The log location is generally in the /var/lib/mysql directory.

Step 1. log in to MySQL and use the command to view Binlog.

  • # cat /etc/my.cnf
  • # mysql -uroot -p
  • mysql> show variables like'log_bin%';
  • # ll /home/programs/mysql-5.6.26/data/mysql-bin*

how to recover mysql from binlog -1

Step 2. Find the wrong statement in Binlog.

You can find the execution time of the error statement in the Binlog, and restore the logs. You can also skip this step and directly restore the entire Binlog. Then, open the SQL file and delete the error statement.

  • # sudo mysqlbinlog --base64-output=DECODE-ROWS -v -d ids --start-datetime '2016-10-11 15:22:53' mysql-bin.000001 > /home/stack/data.sql

how to recover mysql from binlog - 2

Step 3. Recover MySQL from Binlog

Use MySQL Binlog command to directly restore the Binlog log to the SQL script, and you can specify the time of the start and the end. 

If multiple Binlog files are generated from the last backup (it is recommended to refresh the Binlog files at the same time as the backup) until the recovery time. Then, export them to SQL and import them into the database in order from smallest to largest.

  • # sudo mysqlbinlog --base64-output=DECODE-ROWS -v -d ids --start-datetime '2016-10-11 15:22:53' mysql-bin.000001 > /home/stack/data.sql

how to recover mysql from binlog -3

Step 4. Recover data to MySQL

When you are restoring data, there may be repeated data errors. It is recommended to use the -f parameter to ignore it.

  • # mysql -uroot -p -f ids < data.sql

how to recover mysql from binlog -4

Conclusion

That's all about MySQL database. If you have enabled Binlog, Method 2 is recommended. If you don't have any backup, Method 1 is recommended. EaseUS data recovery software can recover FRM, MYD, MYI files, and more.

 Download for Win Recovery Rate 99.7%
 Download for Mac Trustpilot Rating 4.4

Was This Page Helpful?

Updated by Daisy

Daisy is the Senior editor of the writing team for EaseUS. She has been working in EaseUS for over ten years, starting from a technical writer to a team leader of the content group. As a professional author for over 10 years, she writes a lot to help people overcome their tech troubles.

Read full bio

Written by Tracy King

Tracy joined in EaseUS in 2013 and has been working with EaseUS content team for over 7 years. Being enthusiastic in computing and technology, she writes tech how-to articles and share technical solutions about Windows & Mac data recovery, file/system backup and recovery, partition management and iOS/Android data recovery.

Read full bio

Product Reviews

TrustScore 4.7 | 323 reviews
  • EaseUS Data Recovery Wizard is a powerful system recovery software, designed to enable you to recover files you’ve deleted accidentally, potentially lost to malware or an entire hard drive partition.

    Read More
  • EaseUS Data Recovery Wizard is the best we have seen. It's far from perfect, partly because today's advanced disk technology makes data-recovery more difficult than it was with the simpler technology of the past.

    Read More
  • EaseUS Data Recovery Wizard Pro has a reputation as one of the best data recovery software programs on the market. It comes with a selection of advanced features, including partition recovery, formatted drive restoration, and corrupted file repair.

    Read More