How to config MYSQL ?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

How to config MYSQL ?

Postby phaphane » 12. October 2006 09:56

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
 
Posts: 2
Joined: 12. October 2006 09:01

Re: How to config MYSQL ?

Postby Izzy » 12. October 2006 10:47

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"
Last edited by Izzy on 14. October 2006 02:40, edited 1 time in total.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Postby phaphane » 12. October 2006 12:01

Ok good job.

Thank you for your fast answer. :wink:
phaphane
 
Posts: 2
Joined: 12. October 2006 09:01


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 97 guests