Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 26th April 2006, 16:28
sushestvo sushestvo is offline
Join Date: Oct 2005
Posts: 72
Thanks: 0
Thanked 0 Times in 0 Posts
Default Upgrading MySQL from 3.28 to 5.0.20

Alright, my server has 99% CPU loaded by mysqld all the time unfortenetely. Everyone tells me I need to upgrade mysql and it would really help my server's performance, Plus you can tweak 5.xx better.
So I decided to upgrade =)
Hopefully someone can help me do that w/o loosing my MySQL Data =)
Current system:
OS: Fedora Core 3
PHP 5.1.2
ISPConfig 2.2.1
Looking for some easy way to upgrade.... apt-get didn't work. Says there is nothing to upgrade... actually didn't want to update my PHP either... I went through hell upgrading this a month ago.
So I found some RPMs: http://remi.collet.free.fr/index.php...4-mysql-5020-1
Well... should be easy to upgrade with yum? right? well, no, gave me an error:
[root@fc3 ~]# yum --enablerepo=remi update mysql\*                                    
Traceback (most recent call last):
  File "/usr/bin/yum", line 7, in ?
  File "/usr/share/yum-cli/yummain.py", line 34, in main
    locale.setlocale(locale.LC_ALL, '')
  File "/usr/lib/python2.3/locale.py", line 381, in setlocale
    return _setlocale(category, locale)
locale.Error: unsupported locale setting
yeah, btw, how do I change my default sys locale back to en_US? =) lol

surely, there is always an option to wipe out MySQL 3.xx rpms... and then install 5.0.20 Rpms... but is there a better way? I'm just really afraid to screw system up. It's a production server. Hope someone can help.
Reply With Quote
Sponsored Links
Old 26th April 2006, 19:30
sushestvo sushestvo is offline
Join Date: Oct 2005
Posts: 72
Thanks: 0
Thanked 0 Times in 0 Posts

ok, guys never mind =)
got everything upgraded and it works nicely =))))
Reply With Quote
Old 27th April 2006, 16:29
sushestvo sushestvo is offline
Join Date: Oct 2005
Posts: 72
Thanks: 0
Thanked 0 Times in 0 Posts

now i have huge problem. I hope someone can help.
After upgrade went through - site still works with MySQL.
But some functions stopped working. For example I have a function to edit desription for items on the web-site, well, I can't edit it any longer.
I took mysql query directly into phpmyadmin and got this:
#126 - Incorrect key file for table './web4_db1/table.MYI'; try to repair it
repairing it doesn't help. What happened? Help!
Reply With Quote


Thread Tools
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04
upgrading mysql from 3.23.58 to 4.xx sushestvo Installation/Configuration 10 9th December 2005 17:48
Failed at MySQL lhatle Installation/Configuration 4 29th November 2005 02:26
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 17:37
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 10:41

All times are GMT +2. The time now is 22:27.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.