Displaying 5 results from an estimated 5 matches for "ibdata2".
Did you mean:
ibdata1
2015 May 29
3
Using Mariadb databases from old server
...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
2015 May 29
2
Using Mariadb databases from old server
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?
--
Timothy Murphy
gayleard /at/
2015 May 30
0
Using Mariadb databases from old server
...stem,
> 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 tra...
2015 May 31
1
Using Mariadb databases from old server
...'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...
2015 May 29
0
Booting back into CentOS-6
...stem,
> 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
>
>
>
>
> ------------------------------
>
> _______________________________________________
> CentOS...