Mysql database rescue

Mysql database rescue
Sometimes overtime is really not desirable. It happened at a.m.: a very slow server was lent to us by other departments. I was so drunk that Nima could also run the service, I decided to restart the server after two hours of tangle. It would not affect their business in the early hours of the morning. As for the Application Service and other servers, I started it manually, that's all you need to do. Ah, it's really a stuck mindset, So I restarted someone else's server ...... as a result, I had no idea who deleted the Startup File and waited for half an hour without any response. At that time, my soul was scared, I restarted and hung up the business server. Although the files were not deleted by me, the consequences came from my hands. You can't imagine what kind of mentality I came home with that day.
The next day, I was really sorry, and I was ready to take everything. I found our boss and explained everything clearly. At that time, I was ready to say how to deal with it, the boss said this, but he didn't blame me for communication, and he didn't know whether it was a consolation or a real idea for me. However, after the development, the boss took responsibility for the incident, thank him with an eye
The next thing is to do everything possible to communicate and rescue. Since our R & D center is located in Chongqing, I tried every means to communicate and find all the data and rebuild the server.
The method used is the Linux system rescue. Use a CD or USB flash disk for system rescue. when the machine is restarted, choose linuxrecuse mode to enter the system, and then mount the original system disk to any new directory, at this time, I used a USB flash drive and mounted my USB flash drive to a new directory. As for mounting the USB flash drive, I can find some parameters and then cp all the MySQL directories to the USB flash drive.
At last, we can place the MySQL directory on any local server under the MySQL directory of the server, and restart MySQL. At this time, we can export the SQL, and the data has been completely exported without any loss.