On Fri, May 13, 2011 at 9:21 AM, 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
http://lmgtfy.com/?q=mysql+location+of+database+files -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org