Menu Desplegable

How to Move MySQL D/B Files (Windows)

Locate your MySQL installation files and central configuration file.

basedir="C:/Program Files/MySQL/MySQL Server 5.1/"

Your MySQL configuration is stored in "C:\Program Files\MySQL\MySQL Server 5.1\My.ini" file.

Locate your MySQL Database location:

datadir="C:/Documents and Settings/All Users/
Application Data/MySQL/MySQL Server 5.1/Data/"

Stop MySQL service.

Modify My.ini file to point to a new D/B location and Save.

Move your Data directory to a new location

Restart MySQL service.