On 06/23/2011 03:47 PM, Nux Ro wrote:
> Larry Linder writes:
>
>> 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
>>
> Check /var/log/mysql.log (or similar). You shouldn't need to do symlinks and
> the like; instead edit /etc/my.cnf and change datadir to point to a new
> directory then restart. Make sure the new $datadir is chown mysql:mysql.
>
> --
> Nux!
> www.nux.ro
>
If you are under selinux please chcon -R -t mysqld_db_t  on the new dir.

Pat