Page 1 of 1

Change mysql "datadir"

PostPosted: 20. June 2006 22:51
by Funkeroxp
I like change the default directory "C:../xampp/mysql/data" and move to "D:/mysql/data"
I have changed the configuration file "My.cnf" in C:/WINDOWS and copy this file in "../xampp/mysql/bin" too but xampp report error.
I copy the directory "C:../xampp/mysql/data" to "D:/mysql/data" but it the same error
Can you help me?

PostPosted: 20. June 2006 23:35
by Wiedmann
but xampp report error.
..
but it the same error

Cool... Should we guess which error messsage you have?

PostPosted: 21. June 2006 15:30
by Funkeroxp
PhpAdmin:

"#

Error: 2003 (CR_CONN_HOST_ERROR)

Message: Can't connect to MySQL server on '%s' (%d)"


When I move "C:..mysql/data" to "D:...mysql/data".

PostPosted: 21. June 2006 15:37
by Wiedmann
Well, this is a PHP error message...

You have no error message during the start of MySQL with "mysql_start.bat"?

PostPosted: 21. June 2006 16:14
by Funkeroxp
I have the XAMPP Control Panel. when I push the botton to start MySql and light green say "Running" but a few moment, then light green off.

If I choose datadir mysql default "C:...\xampp\mysql\data" , I havent got any problem.

The problem is when I choose datadir mysql in the unit "D:\mysql"

PostPosted: 21. June 2006 16:44
by Funkeroxp
I try with another distributions how "easyphp" and "Wamp" and the error is the same.

Example:

Code: Select all
[wampmysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306


#Path to installation directory. All paths are usually resolved relative to this.
basedir=c:/wamp/mysql

#log file
log-error=c:/wamp/logs/mysql_error.log

#Path to the database root
datadir=d:/mysql/data


but the database not connected

PostPosted: 21. June 2006 16:45
by Funkeroxp
Sorry this code is the "my.ini"
Have I change another thing?
Thanks