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
On Fri, May 13, 2011 at 9:21 AM, Tina Matter 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
On Fri, May 13, 2011 08:21, Tina Matter 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
Add:
datadir=/path/to/datadir/mysql
to your my.cnf file and restart mysql.
-Original Message-
From: Tina Matter [mailto:ti...@umich.edu]
Sent: Friday, May 13, 2011 8:22 AM
To: mysql@lists.mysql.com
Subject: URGENT: Change Default Location of where Database Files get written?
I have a
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/da