On Fri, May 13, 2011 at 9:21 AM, 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: