Put MYSQL Database in other location

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

Put MYSQL Database in other location

Postby MPB » 21. April 2008 17:40

I am running XAMPP for Windows in a 6GB virtual machine with 1.5GB left. I would like to put the MYSQL databases on another drive (that I mapped as "V:"). I read on MYSQL's web site that I could change the database location by editing the My.cnf file as follows. Didn't work.

Any suggestions?

# The MySQL server
[mysqld]
port= 3306
socket= "C:/xampp/mysql/mysql.sock"
basedir="C:/xampp/mysql"
tmpdir="V:/xampp/tmp"
datadir="V:/xampp/mysql/data"

Many thanks in advance.
MPB
 
Posts: 2
Joined: 21. April 2008 17:31

Postby Nobbie » 21. April 2008 19:43

The connection to the drive and the mapping must be established BEFORE you start the MySQL Server. This is usually NOT the case if you start MySQL as a service (because services are started before drives are mapped).
Nobbie
 
Posts: 8759
Joined: 09. March 2008 13:04

ut MYSQL Database in other location

Postby MPB » 21. April 2008 21:14

Thank you, Nobbie for your prompt and curteous reply.

The "V:" drive is automatically mapped when I start the VM instance.
Any other thoughts or ideas, anyone?

javascript:emoticon(':idea:')
Idea
MPB
 
Posts: 2
Joined: 21. April 2008 17:31

Postby Wiedmann » 21. April 2008 21:41

(that I mapped as "V:")

What does you exactly mean with "is mapped"?
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 49 guests