-
Btrfs Recovery Software: Recover Deleted/Lost Files from Btrfs Drives Synology/QNAP
September 29,20246 min read
-
-
-
-
Buffalo Nas Data Recovery Software | Recover NAS Data Quickly
October 29,20246 min read
-
-
-
-
How to Fix Windows 11 Installation Stuck at 35%, 85%, 100% in 2024
November 06,20246 min read
-
Page 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 |
|
2. Recover MySQL from Binlog |
|
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.
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 EaseUS Data Recovery Wizard. 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:
- 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.
How to Recover MySQL with EaseUS MySQL Data Recovery Tool
Download EaseUS Data Recovery Wizard 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. Run EaseUS Data Recovery Wizard on your computer. Choose the drive where you lost files and click "Search for Lost Data". If your lost files were on an external storage device, connect it to your computer firstly.
Step 2. The software will quickly scan the deleted files immediately, and then automatically perform a deep scan to find more lost files. After the scan is completed, you can use "Filter" or "Search box" to quickly locate specific file types.
Step 3. Click the "Preview" button or double-click on a file for a full preview. Finally, select the desired files, click "Recover" and choose another safe location or Cloud drive to save all the files at once.
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*
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
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
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
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.
Was this page helpful?
-
Dany is an editor of EaseUS who lives and works in Chengdu, China. She focuses on writing articles about data recovery on Mac devices and PCs. She is devoted to improving her writing skills and enriching her professional knowledge. Dany also enjoys reading detective novels in her spare time. …
-
Evan Galasso is a digital forensics and data recovery engineer with over 10 years of experience in the field. He presents opinions on the current state of storage media, reverse engineering of storage systems and firmware, and electro-mechanical systems of SSDs and HDDs.…
Why Trust EaseUSEditor Reviews
20+
Years of experience
160+
Countries and regions
72 Million+
Downloads
4.8 +
Trustpilot Score
Hot Recovery Topics
Search