List:General Discussion« Previous MessageNext Message »
From:sureshkumarilu Date:January 29 2010 3:25am
Subject:Re: How to change mysql default database directory
View as plain text  
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@stripped
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=sureshkumarilu@stripped



Sent from BlackBerry® on Airtel
Thread
How to change mysql default database directoryLucky Wijaya29 Jan
  • Re: How to change mysql default database directoryCarlos Proal29 Jan
  • Re: How to change mysql default database directoryprabhat kumar29 Jan
Re: How to change mysql default database directorysureshkumarilu29 Jan
Re: How to change mysql default database directoryCarlos Proal29 Jan
  • Re: How to change mysql default database directorySuresh Kuna29 Jan