Tina Matter URGENT: Change Default Location of where Database Files get written?
May 13, 2011; 11:21
Tina Matter
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: /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
Thanks for any help. Tina
-- Tina Matter 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=listsearcharchive@lassosoft.com
May 13
David Brian Chait RE: URGENT: Change Default Location of where Database Files get written?
May 13, 2011; 08:23
David Brian Chait
RE: URGENT: Change Default Location of where Database Files get written?
May 13
Wm Mussatto Re: URGENT: Change Default Location of where Database Files get written?
May 13, 2011; 08:34
Wm Mussatto
Re: URGENT: Change Default Location of where Database Files get written?
May 13
Larry Martell Re: URGENT: Change Default Location of where Database Files get written?
May 13, 2011; 09:35
Larry Martell
Re: URGENT: Change Default Location of where Database Files get written?
May 13
Andrew Moore Re: URGENT: Change Default Location of where Database Files get written?
May 13, 2011; 18:39
Andrew Moore
Re: URGENT: Change Default Location of where Database Files get written?
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!