On Fri, May 13, 2011 08:21, 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: /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
Since your are on a linux box, the simplest method is to create the
database, but no tables and then replace the directory with a symbolic
link to the desired location. Make sure the permissions at the new
directory match that of the other directories. If you are using innodb
you will need to set it to use separate files for each table.
Hope this helps.
William R. Mussatto