LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   MySQL migration from UNIX (Solaris) to Red Hat Linux 6.2 (https://www.linuxquestions.org/questions/linux-newbie-8/mysql-migration-from-unix-solaris-to-red-hat-linux-6-2-a-4175418973/)

mrcox54 07-27-2012 12:10 PM
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

Kustom42 07-27-2012 12: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 12:47 PM
Thanks Kustom42!

Wim Sturkenboom 07-27-2012 07: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 11:38 AM
Quote:
Originally Posted by Wim Sturkenboom (Post 4739718)
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


All times are GMT -5. The time now is 11:20 AM.