How to change the storage location of mysql: First create a new 1653mydata folder under [D:\]; then cmd into the dos window, enter net stop mysql to stop the MySQL service, and copy the original file to [D:\ mydata] folder; finally change the datadir value and restart.
How to change the storage location of mysql:
1. After the mysql installation is completed, you need to modify the database storage location Location, such as moving from the E:\Program Files (x86)\MySQL\data folder in the installation directory to the D:\mydata folder.
2. Create a new 1653mydata folder under D:\
3. Enter cmd into the dos window, enter net stop mysql to stop the MySQL service, and change C:\ProgramData\MySQL\MySQL Server 5.5\ Copy the folders and files under data (ProgramData is a hidden folder) to the D:\mydata folder
4. Find the my.ini file in the installation directory and find:
#Path to the database root datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/"
Change the value of datadir to datadir="D:/mydata/"
5. After saving, enter cmd into the dos window and enter net start mysql to restart the mySQL service.
More related free learning recommendations: mysql tutorial(Video)
The above is the detailed content of How to change storage location in mysql. For more information, please follow other related articles on the PHP Chinese website!