Why is the MySql-5.1.32's data folder not found?

Source: Internet
Author: User

The installed MySQL does not have a data folder, but it can be used normally. Do you have any of them? How can I see the data folder? If there is no data folder, where should I store my database files? I did not find the entire computer.
How can this problem be solved?
========================================================== ================

You can viewMySQLFile directoryMy. iniFile, similar
Datadir= "D:/beeagle/program files/MySQL Server 5.0/data/" this path is the MySQL DATA DIRECTORY
The default value is "C: \ Documents ents and Settings \ All Users \ Application Data \ mysql \ MySQL Server 5.1 \ data \"
Note: The application data folder is hidden !!!
You can modify the above configuration to put the data folder where you want to put it.

--- The modification method is as follows:

1.Stop mysql. In the command window, enter and run:Net stop MySQLYou can;

2.Cut the data folder in "C: \ Documents ents and Settings \ All Users \ Application Data \ mysql \ MySQL Server 5.1 \ data \" to the destination. I put it in the "D: \ PHP \ mysql \ MySQL Server 5.1" Directory (with MySQL), and put the directory "C: \ Documents and Settings \ All Users \ Application Data \ mysql \ MySQL Server 5.1 \ "are deleted.

3.ModifyMy. iniFile, putDatadirChange to datadir = "D: \ PHP \ mysql \ MySQL Server 5.1 \ data \"

4.Start MySQL and enter and run in the Command window:Net start MySQLYou can;

5.After the modification is completed, you can copy the database appended object to it.

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.