As Carlos said, mention your required path in the my.ini file and restart the MySQL or move your current datadir to your required path and restart MySQL by mentioning the variable as below in the configuration file.
In MySQLD section of your cnf file.
From: Carlos Proal
Subject: Re: How to change mysql default database directory
Sent: Jan 29, 2010 8:46 AM
Absolutely, check for the variable "datadir" on the config file (my.ini
on windows and my.cnf on *nix).
On 1/28/2010 9:12 PM, Lucky Wijaya wrote:
> Hi all,
> I've installed MySQL on 320GB Harddisk (partitioned into 3 partitions). I want to know if there's a way to change MySQL default database directory from C: to D:.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumarilu@stripped
Sent from BlackBerry® on Airtel