Mysql Migrate


 
Thread Tools Search this Thread
Operating Systems Linux Mysql Migrate
# 1  
Old 08-16-2011
Question Mysql Migrate

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  
Old 08-16-2011
read about mysqldump from mysql website
# 3  
Old 08-16-2011
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  
Old 08-16-2011
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  
Old 08-23-2011
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
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. Linux

How to migrate a running lvm.?

Hi all, Please explain how do i. Migrate and backup a running lvm..!! Thanks, Sent from my LG-D802 using Tapatalk (3 Replies)
Discussion started by: lordkizzo
3 Replies

2. Shell Programming and Scripting

Migrate from FTP to SFTP

Hi,I am using following code for FTP in shell script file and it is working.Now I want to migrate from FTP to SFTP.What code changes/steps I have to perform for SFTP ? ftp -in <<FIN open $SAP_UP_SERVER user $SAP_UP_USER $SAP_UP_PASSWORD asc put... (7 Replies)
Discussion started by: Nitin Varshneya
7 Replies

3. UNIX and Linux Applications

MySQL Daemon failed to start - no mysql.sock file

After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)... (3 Replies)
Discussion started by: jastanle84
3 Replies

4. UNIX for Advanced & Expert Users

mysql would not start: missing mysql.sock

I recently installed mysql-standard-5.0.21-solaris9-sparc-64bit.pkg on a Solaris 9 machine (SunOS 5.9 Generic_118558-19 sun4u sparc SUNW,Ultra-250). The package installation went very smooth, however, starting mysql is a different story. I get the message below everytime I try to start mysql: #... (2 Replies)
Discussion started by: xnightcrawl
2 Replies

5. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

MySQL on my server is down.... I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock Any suggestions? Here's what I can't do: can't be root don't have physical access (do stuff via SSH) reinstall MySQL (need to keep the current MySQL... (8 Replies)
Discussion started by: _hp_
8 Replies

6. UNIX for Dummies Questions & Answers

How to migrate ?

Currently, I am planning a migration between machine which under True64UNIX. The new machine will run with higher version O/S. My question is, is there any solution on migrating one machine to another which with different O/S version? My goal is keeping minimum impact to the users. Excuse my... (1 Reply)
Discussion started by: coolmans
1 Replies
Login or Register to Ask a Question