Re: Porting database from Windows to Solaris?
Posted by: S C
Date: March 31, 2009 07:35PM

Hi Lance,

Remove old mysql-bin.xxxxxx files and mysql-bin.index in the data directory of the solaris.

Create my.cnf accoring to your current my.ini.
Give only limited access to my.cnf as: chmod 500 my.cnf
Global write will give you error and mysql will ignore this file.

Make sure that you have the ib_logfile0, ib_logfile1, ibdata1, your_current_database_folder, mysql copied to the mysql data directory.

Recursively change user to mysql for data directory.
Give right accesses to log files as: chmod 660
Give right access to the directories: chmod 755

Good luck!
SC

Options: ReplyQuote


Subject
Written By
Posted
Re: Porting database from Windows to Solaris?
S C
March 31, 2009 07:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.