MySQL : How to Change data dir location in mysql on windows

MySQL : How to Change a MySQL Data Directory to a New Location on windows

Step 1 — Checking current MySQL Data Directory

mysql -u root -p
mysql1234

C:\ProgramData\MySQL\MySQL Server 5.6\Data\

Step 2 — ShutDown mysql services

locate MYSQL56 and stop it

Step 3 - Move files from old directory to new dir

C:\ProgramData\MySQL\MySQL Server 5.6\Data_1\

C:\ProgramData\MySQL\MySQL Server 5.6\Data_2\



replace C:\ProgramData\MySQL\MySQL Server 5.6\Data_1\ with C:\ProgramData\MySQL\MySQL Server 5.6\Data_2\

and save exit

step 5 - Start mysql service and verify the new configuration

locate MYSQL56 and start it

mysql -u root -p
mysql1234

[vinayakhegde]

Thanks it helped please some more video's on my SQL i am new to MySQL if you can make a video what source should i use to self study it will help a lot :)