What should I do if the restore wizard restores mysql?

Source: Internet
Author: User

What should I do if the restore genie restored mysql? I recently attended practical training courses in the school data center, so I had to frequently communicate with the data center. The recovery wizard installed on the computer room restores my mysql every day. It's a headache. Fortunately, the restore wizard only restores the Registry file and does not restore the hard disk. Therefore, we still have hope. 1. If the backup registry does not back up the registry, uninstall it and reinstall it again. At present, I have no solution... The backup process is as follows: the principle is that mysql has traces of user and local_machine in the registry, so we need to back up the data. 1. run regedit to enter the Registry 2. export the local machine-> software-> mysql registry 3. to export the user-> software-> mysql registry, save the settings. restore the registry and double-click the backup registry to import it. III. install mysql Services 1. enter the mysql/bin folder (for example, this folder is in E: \ Program Files \ MySQL Server 5.5 \ bin-> e: (enter the E disk)-> cd E: \ Program Files \ MySQL Server 5.5 \ bin (enter this directory) 2. -mysqld-install (install the service) 3. -net start mysql, # set basedir to your installation path set the mysql installation directory basedir = E: \ Program Files \ MySQL Server 5.5 # set datadir to the location of you R data directory set database directory datadir = E: \ Program Files \ MySQL Server 5.5 \ data [WinMySQLAdmin] Server = G: /mysql/bin/mysqld-nt.exe 4. -net start mysql service is finally started.

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.