SCIENTIFIC-LINUX-USERS Archives

June 2011

SCIENTIFIC-LINUX-USERS@LISTSERV.FNAL.GOV

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Reply To:
Date:
Thu, 23 Jun 2011 21:47:01 +0100
Content-Type:
text/plain
Parts/Attachments:
text/plain (33 lines)
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
 

ATOM RSS1 RSS2