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
