------------ Original Message ------------
> Date: Saturday, May 30, 2015 12:27:26 AM -0400
> From: Ted Miller <tedlists@xxxxxxxxxxxxx>
>
> 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
>
The approach you can/need to take depends a bit on the type of db
table you have. If it's a MyISAM type you can (generally) simply
move the various db files from one machine to another. See:
<https://dev.mysql.com/doc/refman/5.0/en/copying-databases.html>
for some specific notes. I always move the whole directory.
If they are InnoDB tables, see the notes at:
<https://dev.mysql.com/doc/refman/5.6/en/innodb-migration.html>
for details.
Look at:
<http://serverfault.com/questions/487159/what-is-the-ibdata1-file-in-my-var-lib-mysql-directory>
for details on what's in the ibdata1 file.
You need to have mysql/mariadb shut down when you move the files.
- Richard
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
