After the system reload, the MySQL database reloads the original database

Source: Internet
Author: User

I believe it's not just me. A problem that causes the MySQL database to be unusable after reinstalling the system. Although you can reinstall a MySQL server program on your computer, how can you restore the previous database as well?

Today, I found a way to solve it.

First, the MySQL server program has a data directory that is primarily used to store information about the entities (tables, etc.) in the database and database.


Also part of the installation of the server program, you will be asked to choose the location of the data, here I put D:\MySQL datafiles.

So whenever you reinstall the MySQL server program, you also select the path where the data is stored. Then copy the files from the original data folder to the new data merge. This restores the original database.


After the system reload, the MySQL database reloads the original database

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.