LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 07-27-2012, 01:10 PM   #1
mrcox54
LQ Newbie
 
Registered: Jul 2012
Posts: 2

Rep: Reputation: Disabled
MySQL migration from UNIX (Solaris) to Red Hat Linux 6.2


I am new to the Linux and mysql world and have a question I hope someone can point me to some documentation.

I am migration from a Solaris 10 OS to RHEL 6.2 and need some information on migrating myqsl on solaris to linux.

Does anyone know of a place I can find some information/steps for doing this?

I have found a little info on mysqldump but need to do a little more research on it.

Thanks in advance for any suggestions.

Mike Cox
 
Old 07-27-2012, 01:19 PM   #2
Kustom42
Senior Member
 
Registered: Mar 2012
Distribution: Red Hat
Posts: 1,604

Rep: Reputation: 415Reputation: 415Reputation: 415Reputation: 415Reputation: 415
Uh yea, just dump your mysql tables to a .sql file and then import them.

dev.mysql.com/doc/refman/5.0/en/copying-databases.html
http://www.cyberciti.biz/tips/howto-...te-server.html
 
Old 07-27-2012, 01:47 PM   #3
mrcox54
LQ Newbie
 
Registered: Jul 2012
Posts: 2

Original Poster
Rep: Reputation: Disabled
Thanks Kustom42!
 
Old 07-27-2012, 08:36 PM   #4
Wim Sturkenboom
Senior Member
 
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Slackware 10.1/10.2/12, Ubuntu 12.04, Crunchbang Statler
Posts: 3,786

Rep: Reputation: 282Reputation: 282Reputation: 282
Depending on the versions, you might have to pay attention to passwords.

I ran into that problem after upgrading from 3.23 to 4.1. The user table in the mysql database is the obvious one, but other databases might also have passwords stored that were generated with the mysql password() function.

See e.g. https://dev.mysql.com/doc/refman/5.5...d-hashing.html
 
Old 07-30-2012, 12:38 PM   #5
Kustom42
Senior Member
 
Registered: Mar 2012
Distribution: Red Hat
Posts: 1,604

Rep: Reputation: 415Reputation: 415Reputation: 415Reputation: 415Reputation: 415
Quote:
Originally Posted by Wim Sturkenboom View Post
I ran into that problem after upgrading from 3.23 to 4.1. [/url]
That is a HUGE jump. MySQL has created a binary for upgrading the MySQL database.

Code:
mysql_upgrade -uroot -p
And its always good to do a repair/optimize check:

Code:
mysqlcheck -Aro -uroot -p
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Migration of C++ Application from SuSE Linux to Red Hat Linux Ghare123 Linux - Newbie 3 04-04-2010 12:32 PM
LXer: Novell Attacks Red Hat with Linux Migration Offer LXer Syndicated Linux News 0 11-12-2008 02:30 PM
LXer: Novell Launches New Training to Ease Red Hat-to-SUSE Linux Migration LXer Syndicated Linux News 0 02-01-2007 07:21 AM
LXer: Solaris Whoops Red Hat Linux 4 in MySQL Benchmark LXer Syndicated Linux News 0 04-23-2006 03:33 AM
Red Hat 9 to Red Hat EL Mozilla Migration Question rharvey@cox Linux - Software 2 01-13-2004 07:43 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 09:04 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration