MySQL migration from UNIX (Solaris) to Red Hat Linux 6.2

mrcox54 · 07-27-2012, 01:10 PM

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

Kustom42 · 07-27-2012, 01:19 PM

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

mrcox54 · 07-27-2012, 01:47 PM

Thanks Kustom42!

Wim Sturkenboom · 07-27-2012, 08:36 PM

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

Kustom42 · 07-30-2012, 12:38 PM

Quote:

Originally Posted by Wim Sturkenboom

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