On Thursday 23 June 2011 4:47 pm, Connie Sieh wrote:
> On Thu, 23 Jun 2011, Larry Linder wrote:
> > I have a need to move an installation of mysql from /var/lib/mysql to
> > another disk.  /var has limited size.
> > I installed a new 1 T disk on new system.
> > used "yum" to install mysql-server mysql it installs and runs
> > from /var/lib/mysql
> > /etc/init.d/mysqld  stop
> > I followed the procedure in RH to move the data files etc.
> > Once you change the my.cnf to new location
> >
> > /etc/init.d/mysqld start
> > long delay
> > (failed)
> > Not much of an error message.
> >
> >
> > The last time I use ln -s to link new disk to /var/lib/mysql.   When
> > system was rebuilt this went away and I need a reliable way to move mysql
> > to new disk.
> >
> > Thank You
> > Larry Linder
>
> Larry,
>
> Does this system have Selinux enabled?  If so does selinux like how you
> did the move.  I assume you mounted the new disk on /var/lib/mysql .
>
> There is a mysql log file in /var/log/mysql.log is there any entries
> from when you did the /etc/init.d/mysqld start .
>
> -connie sieh
The log files are good clue - 

The solution to problem was to turn off  selinux move and initialize new 
location.
If you have any existing Data make sure you back it up.

New location for mysql is 1 T drive /mcdb

/etc/init.d/mysqld stop
mkdir /mcdb/mysql						# make new direcotory
cp -R  /var/lib/mysql/*   /mcdb/mysql		  	# copy recursively mysql files
chown mysql:mysql /mcdb/mysql			# changes owner to mysql
vi /etc/my.cnf
Change datadir=/mcdb/mysql				# changes path to mysql data

echo 0 >/selinux/enforce
/etc/init.d/mysql start	       					#starts from new location
echo 1 >/selinux/enforce					

Run python apps and it all works!  in a few minutes.

Incredibly simple and logical  -  Just not thinking about selinux and how it 
works.  Will have to give it more study.

Thank You
Larry Linder