Move MySQL database to another disk under Windows

Preface

Today I installed MySQL and found that the database storage was installed on the C drive by default. Since the C drive has limited space, I wanted to move it to another drive.

Here are my steps

1. Start

2. Enter your password

3. Enter the command to query where the data is stored

show global variables like "%datadir%";

4. Move the Data file under C:\ProgramData\MySQL\MySQL Server 8.0 to the desired location

5. Modify the my.ini file under C:\ProgramData\MySQL\MySQL Server 8.0

Find datadir, add # to the original address and comment it out, then write the address of the data file you moved

6. Open Computer Management, find the MySQL service, and restart it

7. Check the data storage location again

show global variables like "%datadir%";

If the data position after the move is displayed, it means it is successful.

This is the end of this article about moving MySQL database to another disk under Windows. For more relevant MySQL database movement content, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!