Mysql Migrate

Linux and Unix-Like Linux
1

Hi ,

I would like to (MYSQL) migrate the all the data from solari's to linux box.

I have checked whether mysql is installed or not.

rpm -qa | grep -i mysql

I confirmed !!!!

I want to know the following points.

1) How can get to know what are mysql data files and location as well.
2) How can i transfer those thing from solaris to linux.(ftp).. any advance ?
3) Or else i have to follow any procedure..

Please advice the same

Thanks & Regards,
Mani

2

read about mysqldump from mysql website

3

ok, Thank you.

But, I am not clear yet. Actually I have to migrate the data from solaris to linux by using mysqldump.

1) I have to migrate Unit test system and Management system.

Do you have any idea about it.

Thanks,
Mani

4

You can offline the database server and then copy the data files directly if .
rsync also is an option if you would so.
But I prefer to take backup with tools such as mysqldump

5

I want to know i have solaris and linux box. Now we can able to connect to mysql through solaris box. I would like to connect from linux box. I have installed mysql in linux box.

Please advice for next steps!!!

Thanks,
Mani