to your my.cnf file and restart mysql.
From: Tina Matter [mailto:tinab@stripped]
Sent: Friday, May 13, 2011 8:22 AM
Subject: URGENT: Change Default Location of where Database Files get written?
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.
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=1