Apache Friends Support Forum

Hello,

I want to move my data folder. How can I change the default destination?
I make change in my.ini in "WINDOWS" folder but change no effect.

phaphane wrote:Hello,

I want to move my data folder. How can I change the default destination?
I make change in my.ini in "WINDOWS" folder but change no effect.

Stop MySQL

Open up your text editor and drag this file into it:
xampp\mysql\bin\my (or my.cnf if you have that)
Change the datadir to where you moved it to so that it is the same as what you changed it to in Windows\my.ini
Save the file and restart MySQL.
Example (your paths may be different):

Code: Select all

# The MySQL server
[mysqld]
basedir="C:/xampp/mysql"
tmpdir="C:/xampp/tmp"
datadir="C:/xampp/mysql/data"

Changed to:

Code: Select all

# The MySQL server
[mysqld]
basedir="C:/xampp/mysql"
tmpdir="C:/xampp/tmp"
datadir="C:/xampp/data"

Ok good job.

Thank you for your fast answer.