Re: [CentOS] Using Mariadb databases from old server

2015-06-01 Thread Timothy Murphy
Richard wrote: > 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: > > > > for some sp

Re: [CentOS] Using Mariadb databases from old server

2015-05-31 Thread Richard
Original Message > Date: Saturday, May 30, 2015 12:27:26 AM -0400 > From: Ted Miller > > 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 lik

Re: [CentOS] Using Mariadb databases from old server

2015-05-29 Thread Ted Miller
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 C

Re: [CentOS] Using Mariadb databases from old server

2015-05-29 Thread Todor Petkov
On 29/05/2015 02:00 PM, Timothy Murphy wrote: 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 f

Re: [CentOS] Using Mariadb databases from old server

2015-05-29 Thread Timothy Murphy
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 M

Re: [CentOS] Using Mariadb databases from old server

2015-05-28 Thread Todor Petkov
On 29/05/2015 04:52 AM, Timothy Murphy 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 s

[CentOS] Using Mariadb databases from old server

2015-05-28 Thread Timothy Murphy
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