MySQL 5.7.21 decompressed version of the tutorial to restore data through the historical data directory
|
Situation description: The database was started and shut down abnormally, resulting in the prompt "Starting" when the service was started again. I had no choice but to reinstall the unzipped version of the program. About how to install: https://www.jb51.net/article/148140.htm Please visit this article. The installation is successful and the data file directory is generated. The user password and other things are set. The directory effect is as follows:
The following is data recovery, which is very simple. 1. Find the data folder in the database directory (I have been unable to start the path F:\mysql-5.7.21-winx64 before), the directory is as follows:
There are many historical files in it, don't worry about the others, 1 is ibdata1, this file must be copied, 2 is the name of the database I want to restore Shut down the mysql service, copy these two files to the data file directory of the newly installed mysql (F:\Program Files\mysql-5.7.21-winx64), restart the service, and you will find OJBK.
After clicking it, you will see that all the tables are there. Summarize The above is the tutorial illustration of how to recover data from the historical data directory of the decompressed version of MySQL 5.7.21. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website! You may also be interested in:
|
<<: Detailed explanation of Angular routing animation and advanced animation functions
>>: Detailed explanation of daily_routine example code in Linux
Recommend
Some summary of MySQL's fuzzy query like
1. Common usage: (1) Use with % % represents a wi...
mysql subquery and join table details
Table of contents 1. What is a subquery? 2. Self-...
Solution to inconsistent display of cursor size in input box
The cursor size in the input box is inconsistent T...
The process of quickly converting mysql left join to inner join
During the daily optimization process, I found a ...
Vue.set() and this.$set() usage and difference
When we use Vue for development, we may encounter...
(MariaDB) Comprehensive explanation of MySQL data types and storage mechanisms
1.1 Data Type Overview The data type is a field c...
Summary of XHTML application in web design study
<br />Generally speaking, the file organizat...
Analyze the difference between ES5 and ES6 apply
Table of contents Overview Function signature Opt...
Simple implementation of vue drag and drop
This article mainly introduces the simple impleme...
Detailed explanation of several API examples commonly used in advanced javascript front-end development
Table of contents MutationObserver API Features I...
Detailed explanation of galera-cluster deployment in cluster mode of MySQL
Table of contents 1: Introduction to galera-clust...
nginx proxy_cache batch cache clearing script introduction
Preface: I used the official nginx proxy_cache as...
Vue implements countdown between specified dates
This article example shares the specific code of ...
Use SQL statement to determine whether the record already exists before insert
Table of contents Determine whether a record alre...
MySQL deep paging (how to quickly paginate tens of millions of data)
Table of contents Preface Case optimization summa...