From: Larry Martell Date: May 13 2011 3:35pm Subject: Re: URGENT: Change Default Location of where Database Files get written? List-Archive: http://lists.mysql.com/mysql/225003 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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: =C2=A0 =C2=A0/opt/mysql > > When creating a new database, a folder (with the name of the databas) get= s > 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 record= s > 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=3Dmysql+location+of+database+files