[Tuxaloosa] install mysql in non-default location

Mark Greene mark at markgreene.info
Mon Nov 17 23:05:46 UTC 2008


Interesting question. I never thought about but I'm sure I will need this answer in the future. Its looking like you need to simply edit your 'my.conf' file for mysql, which is typically located in the root of /etc. 

Change the path of the following:
pid-file=
datadir=
basedir=

There you go. If you already have this in production simply copy everything from the original paths into the new paths. I would use rsync -a to preserve file attributes. 

Restart mysql when you're done of course. 

------Original Message------
From: E Hanson
Sender: tuxaloosa-bounces at tuxaloosa.org
To: Tuscaloosa Linux Users Group
ReplyTo: Tuscaloosa Linux Users Group
Sent: Nov 17, 2008 4:21 PM
Subject: [Tuxaloosa] install mysql in non-default location

i'm setting up vtigerCRM on Debian Etch.
the box has an old RAID card in it that i have 2x80G IDE-100 in raid1 
set up with dmraid.
OS is running on a separate 40G HD.
for the purpose of data redundancy i want the database running (or 
stored?) in the array.
so... how do i set up mysql to do this?

is this really what i want?
RAID is /dev/dm-0 mounted at /mnt/raid
i've never done anything like this before, so any input is very welcome.

erik hanson
_______________________________________________
TUXaloosa mailing list
TUXaloosa at tuxaloosa.org
http://tuxaloosa.org/mailman/listinfo/tuxaloosa



More information about the TUXaloosa mailing list