Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: grahowler on May 01, 2004, 01:10:35 PM

Title: pre MySQL 4 upgrade advice
Post by: grahowler on May 01, 2004, 01:10:35 PM

Hi

I am about to update my SME 5.6 running MySQL 3.23 to MySQL 4

I've read the article here: http://no.longer.valid/phpwiki/index.php/How%20to%20Upgrade%20MySQL%20to%204.0.x%20for%20SME%20Server and the related forum topics.

It all seems pretty straight forward apart from the fact that I don't really understand most of what is going on in step 5. Regardless of that fact, I am capable of performing it competently enough but understanding what is happening is another matter.

Anyway, I have done all the necessary backups of both MySQL and all the files on my SME server. Before I proceed I am just wondering is there any other contingency I should consider that I may not have seen mentioned in the above articles?

It's just that I rely heavily on my SME, and MySQL, to keep a network/intranet up and I can't afford to have it any of it fall over. So if anyone has any input I would be most grateful.

Cheers/thanks in advance.

Title: pre MySQL 4 upgrade advice
Post by: ergozd on May 01, 2004, 01:28:29 PM

I'll try to explain step 5

Code: [Select]

chkconfig --levels 2345 mysql on

mv /etc/rc.d/init.d/mysql /etc/rc.d/init.d/mysqld
rm /etc/rc.d/rc7.d/S90mysqld
ln -s /etc/rc.d/init.d/mysqld /etc/rc.d/rc7.d/S90mysqld
Configuration so that MySQL will start when you start your server, mysql 3.23.x and MySQL 4.x has diffents initscripts
mysqld for 3.23.x
mysql for 4.x.
So the autors change the name and links

Code: [Select]

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no (to enable remote access)
so that MySQL can be accessed from other PCs running SQL clients DBTools, MySQL CC etc.

Code: [Select]

/sbin/e-smith/expand-template /root/.my.cnf
generating new root/.my.cnf file

Code: [Select]

ln -s /usr/sbin/mysqld /usr/libexec/
for conf-mysql-password script

Code: [Select]

service mysqld restart
restart you upgraded MySQL DB Server.

Hope it helps.

Rgds, Ergin

Title: thanks!
Post by: Anonymous on May 01, 2004, 10:44:32 PM

Yes, that is extremely helpful ergozd

Thanks a lot!