On 05/29/2015 07:00 AM, Timothy Murphy wrote:
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 ?
This is what I ran into trying to clone a web server on C7 (doing this
from memory):
There is something in the database file /var/lib/mysql that has to match
something elsewhere on the machine. Apparently the match is created during
the mariadb-server.rpm installation. I found two ways to transfer
a /var/lib/mysql file successfully.
1. Transfer the file before installing mariadb-server.rpm
or
2. After copying the file over the existing one,
yum reinstall mariadb-server
Hope this helps,
Ted Miller, Indiana, USA
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
