On Thu, Jun 23, 2011 at 3:17 PM, Larry Linder
<[log in to unmask]> 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,
just a thought - can you put /var on a logical volume instead moving the mysql?
to see what's mysql is unhappy about try to find it's log files (
http://dev.mysql.com/doc/refman/5.0/en/server-logs.html)
Andrew