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 <ti...@umich.edu> 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=eroomy...@gmail.com > >