[CentOS] Mysql databases from old system?

Fri Nov 15 14:41:45 UTC 2013
m.roth at 5-cent.us <m.roth at 5-cent.us>

Marios Zindilis wrote:
> On Fri, Nov 15, 2013 at 2:18 PM, Timothy Murphy <gayleard at eircom.net>
> wrote:
>
>> Last week I had a hard disk failure on my CentOS server.
>> I managed to re-install CentOS on a new disk.
>> I have the old mysql databases from /var/lib/mysql .
>> Can I just move them to my new disk?
>>
>> Any help or suggestions gratefully received.

> MySQL is usually confined in /var/lib/mysql, so if you move the
> /etc/my.cnf
> and the /var/lib/mysql from the old server to the new one, you should be
> able to start the server normally, otherwise you should get some useful
> errors.
>
> A typical error in such case is MySQL files ownership/permissions.
>
Marios, please don't top post.

And speaking of ownership/permissions... watch out for selinux contexts.
You may want to touch /.autorelabel and reboot, and walk away for a
while....

     mark

          mark