As Suresh and others said, you have to stop the dbms, move to content of
the dir and restart the dbms.
Also, if you have a fresh install, innodb tables will be saved on a
datafile inside the same data dir, but if is not a fresh install you may
have innodb variables (ie. innodb_data_home_dir) in the config file, and
you may need to change those too.
Carlos
On 1/28/2010 9:25 PM, Lucky Wijaya wrote:
Is that all ? So, if i changed datadir on the config file, whenever i
create databases mysql will store it on selected directory ? How about
the created-before database ?
Btw, I'm using Windows.
Thanks in advance.
------------------------------------------------------------------------
*From:* Carlos Proal <carlos.pr...@gmail.com>
*To:* mysql@lists.mysql.com
*Sent:* Fri, January 29, 2010 10:16:31 AM
*Subject:* Re: How to change mysql default database directory
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=luckyx_cool_...@yahoo.com