[Tuxaloosa] install mysql in non-default location

[E Hanson]

ok... it looks like i've managed to botch things a bit. when i
/etc/init.d/mysql start
i get a failed message.
/var/log/syslog says:
Nov 18 11:05:17 inventory mysqld_safe[4367]: started
Nov 18 11:05:17 inventory mysqld[4370]: 081118 11:05:17  InnoDB: 
Operating system error number 13 in a file operation.
Nov 18 11:05:17 inventory mysqld[4370]: InnoDB: The error means mysqld 
does not have the access rights to
Nov 18 11:05:17 inventory mysqld[4370]: InnoDB: the directory.
Nov 18 11:05:17 inventory mysqld[4370]: InnoDB: File name ./ibdata1
Nov 18 11:05:17 inventory mysqld[4370]: InnoDB: File operation call: 
'create'.
Nov 18 11:05:17 inventory mysqld[4370]: InnoDB: Cannot continue operation.
Nov 18 11:05:17 inventory mysqld_safe[4376]: ended
Nov 18 11:05:32 inventory /etc/init.d/mysql[4511]: 0 processes alive and 
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov 18 11:05:32 inventory /etc/init.d/mysql[4511]: 
^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov 18 11:05:32 inventory /etc/init.d/mysql[4511]: error: 'Can't connect 
to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov 18 11:05:32 inventory /etc/init.d/mysql[4511]: Check that mysqld is 
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Nov 18 11:05:32 inventory /etc/init.d/mysql[4511]:
Nov 18 11:17:01 inventory /USR/SBIN/CRON[4518]: (root) CMD (   cd / && 
run-parts --report /etc/cron.hourly)
Nov 18 11:45:48 inventory -- MARK --
Nov 18 12:05:48 inventory -- MARK --
Nov 18 12:16:12 inventory mysqld_safe[4588]: started
Nov 18 12:16:12 inventory mysqld[4591]: 081118 12:16:12  InnoDB: 
Operating system error number 13 in a file operation.
Nov 18 12:16:12 inventory mysqld[4591]: InnoDB: The error means mysqld 
does not have the access rights to
Nov 18 12:16:12 inventory mysqld[4591]: InnoDB: the directory.
Nov 18 12:16:12 inventory mysqld[4591]: InnoDB: File name ./ibdata1
Nov 18 12:16:12 inventory mysqld[4591]: InnoDB: File operation call: 
'create'.
Nov 18 12:16:12 inventory mysqld[4591]: InnoDB: Cannot continue operation.
Nov 18 12:16:12 inventory mysqld_safe[4597]: ended
Nov 18 12:16:27 inventory /etc/init.d/mysql[4732]: 0 processes alive and 
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Nov 18 12:16:27 inventory /etc/init.d/mysql[4732]: 
^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Nov 18 12:16:27 inventory /etc/init.d/mysql[4732]: error: 'Can't connect 
to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Nov 18 12:16:27 inventory /etc/init.d/mysql[4732]: Check that mysqld is 
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

so i assume that i need to change permissions on the new dirs and their 
contents.
is the mysql user just mysql? is there a group mysql?
should i #chown mysql:mysql new/dirs/ ?
is that a little broad sweeping?

thanks
e hanson

Mark Greene wrote:
> 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
>
> _______________________________________________
> TUXaloosa mailing list
> TUXaloosa at tuxaloosa.org
> http://tuxaloosa.org/mailman/listinfo/tuxaloosa
>
>