[CentOS] Using Mariadb databases from old server

Fri May 29 11:00:07 UTC 2015
Timothy Murphy <gayleard at eircom.net>

Todor Petkov wrote:

>> I'm running CentOS-7, but I left some MySQL databases
>> on my old CentOS-6.5 partition which I'd like to retrieve.
>> I assume they are contained in the file /var/lib/mysql/ibdata1 ?
>> Could I just copy this file to /var/lib/mysql in CentOS-7?
>> Or is there some way Mariadb or phpMyAdmin can import mysql databases
>> from a server that is no longer running?
> The C6 partition is part of the new server, so you are able to mount it
> and copy files from it, is this correct? Have you done something with
> the MariaDB or it's still clean installation?

I did add something to Mariadb on the new CentOS-7 system,
but I don't mind deleting it and starting again.
I can mount the partition with the old mysql files on it.
Could I just copy the contents of /mnt/var/lib/mysql
to the new system?
There are files with the same name, eg ibdata1, on both systems.
Could I have an ibdata2 ?

Any suggestions gratefully received.

Timothy Murphy  
gayleard /at/ eircom.net
School of Mathematics, Trinity College, Dublin