[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