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.
Datadir=path In MySQLD section of your cnf file. Thanks Suresh Kuna MySQL DBA ------Original Message------ From: Carlos Proal To: mysql@lists.mysql.com 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). Carlos 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:. > > Thanks. > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com Sent from BlackBerry® on Airtel
