From: Carlos Proal (carlos.proalgmail.com)
Date: Thu Jan 28 2010 - 21:52:50 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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.proalgmail.com>
> *To:* mysqllists.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_boyyahoo.com
>
>

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]