|
Home > Archive > MySQL ODBC Connector > January 2006 > setting the data directory.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
setting the data directory.
|
|
| Scott Johnson 2006-01-31, 7:23 am |
| Hi All,
I am trying to find out how to change the location of the data files. I have
not yet found a generic entry for the my.conf file to set a data and log
location.
Can I move the exiting data directory form the mySQL tree and put a soft
link to a new location on another partition?
thanks,
Scott Johnson
scott@wilty.ca
Tel.: (514) 917-4922
Fax: (514) 673-0011
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Adam Alkins 2006-01-31, 7:23 am |
| Hi,
There's a mysqld startup option --datadir=3D/path/to/data which you can
use to alter your data directory. Simply adjust your startup scripts
to suite.
Regards,
-Adam
On 1/31/06, Scott Johnson <scott@wilty.ca> wrote:
> Hi All,
>
> I am trying to find out how to change the location of the data files. I h=
ave
> not yet found a generic entry for the my.conf file to set a data and log
> location.
>
> Can I move the exiting data directory form the mySQL tree and put a soft
> link to a new location on another partition?
>
> thanks,
>
> Scott Johnson
> scott@wilty.ca
> Tel.: (514) 917-4922
> Fax: (514) 673-0011
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dadam.alkins@gmail=
..com
>
>
--
Adam Alkins
http://www.rasadam.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| David Logan 2006-01-31, 7:23 am |
| -------------- 01010107040700030901
0108
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Adam Alkins wrote:
>Hi,
>
>There's a mysqld startup option --datadir=/path/to/data which you can
>use to alter your data directory. Simply adjust your startup scripts
>to suite.
>
>Regards,
>-Adam
>
>On 1/31/06, Scott Johnson <scott@wilty.ca> wrote:
>
>
>
>
>--
>Adam Alkins
>http://www.rasadam.com
>
>
>
Hi Scott and Adam,
You don't even have to modify the startup scripts, just add
datadir=/path/to/mysql/stuff
to the my.cnf file and it will point to there.
Regards
--
David Logan
South Australia
when in trouble, or in doubt
run in circles, scream and shout
-------------- 01010107040700030901
0108--
|
|
|
|
|