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...
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:
> 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:
> Thanks for any help.
> 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