[CentOS] Mysql databases from old system?
Leon Fauster
leonfauster at googlemail.com
Fri Nov 15 16:30:15 UTC 2013
Am 15.11.2013 um 16:55 schrieb Les Mikesell <lesmikesell at gmail.com>:
> On Fri, Nov 15, 2013 at 6:18 AM, 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.
>
> What you are 'supposed' to do is take the backup that you make
> regularly with 'mysqldump' and restore it with the mysql command line
> program. But if you are running on the same cpu type and mysql
> version, moving the disk or copying the directory contents will work
> (along with the things already mentioned about /etc/my.cnf and
> selinux).
provided that the old system had shutdown the mysql process
regularly. Means, the integrity of /var/lib/mysql is warranted.
--
LF
More information about the CentOS
mailing list