List:General Discussion« Previous MessageNext Message »
From:Andrew Moore Date:May 13 2011 5:39pm
Subject:Re: URGENT: Change Default Location of where Database Files get written?
View as plain text  
There absolutely is;

there is a configuration file belonging to MySQL named `my.cnf`. It can
exist in many places and there's a hierarchal order of precedense. The most
common of which is /etc/my.cnf.

Within this file you may specify the `datadir` option to identify location
you wish your data to reside. This is a static variable that can't be
altered whilst the server is in motion and there are things you may need to
do before considering changing this value. There is a wealth of
documentation on this configuration file that can be found at...

http://dev.mysql.com/doc/refman/5.5/en/mysqld-option-tables.html

HTH

Andy

On Fri, May 13, 2011 at 4:21 PM, Tina Matter <tinab@stripped> wrote:

> I have a MySQL question that I'm hoping someone can help answer.
>
> We have a linux machine which has MySQL 5.5.8 installed.
> It is currently installed in this location:    /opt/mysql
>
> When creating a new database, a folder (with the name of the databas) gets
> created in this location:
> /opt/mysql/data
>
> Is there any way to change the location of where data is stored?
> The database that I need to create is going to have over a billion records
> in it,
> so it needs to be in a specific place.
>
> I want the database folder to get created here:
>
> /science/databases/databasename
>
> Thanks for any help.
> Tina
>
> --
> Tina Matter
> Web Applications Developer
> University of Michigan
> Department of Epidemiology
> 1415 Washington Heights, Suite 4605
> Ann Arbor, MI 48109
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

Thread
URGENT: Change Default Location of where Database Files get written?Tina Matter13 May
  • RE: URGENT: Change Default Location of where Database Files getwritten?David Brian Chait13 May
  • Re: URGENT: Change Default Location of where Database Files get written?Wm Mussatto13 May
  • Re: URGENT: Change Default Location of where Database Files get written?Larry Martell13 May
  • Re: URGENT: Change Default Location of where Database Files get written?Andrew Moore13 May