LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 05-06-2003, 01:43 AM   #1
SForsgren
Member
 
Registered: Apr 2003
Location: San Jose
Distribution: Red Hat 9
Posts: 68

Rep: Reputation: 15
MySQL Upgrade


Has anyone gotten a 3.23 MySQL upgraded to 4.1? I have had all kinds of issues. I think I am getting close, but it has been painful and I really didn't understand whether or not I was supposed to uninstall 3.23 first or just blast in 4.1?

Thanks
 
Old 05-06-2003, 04:36 AM   #2
markus1982
Senior Member
 
Registered: Aug 2002
Location: Stuttgart (Germany)
Distribution: Debian/GNU Linux
Posts: 1,467

Rep: Reputation: 46
4.1 is DEVELOPMENT and should not be used in a production environment. Use 4.x
 
Old 05-06-2003, 05:15 AM   #3
jharris
Senior Member
 
Registered: May 2001
Location: Bristol, UK
Distribution: Slackware, Fedora, RHES
Posts: 2,243

Rep: Reputation: 46
I've sucessfully gone from 3.23 upto 4.0 without any problems. I just did the usual build process then ran the mysql_fix_privilege_tables script in the 'scripts' directory of the source. The install docs have a pretty good explination of the upgrade process.

cheers

Jamie...
 
Old 05-06-2003, 10:57 PM   #4
SForsgren
Member
 
Registered: Apr 2003
Location: San Jose
Distribution: Red Hat 9
Posts: 68

Original Poster
Rep: Reputation: 15
Do I have to rebuild all of the products that used to depend on 3.23? It seems like there are quite a few. I've not yet actually built / compiled on my Linux box. Thanks
 
Old 05-07-2003, 03:43 AM   #5
jharris
Senior Member
 
Registered: May 2001
Location: Bristol, UK
Distribution: Slackware, Fedora, RHES
Posts: 2,243

Rep: Reputation: 46
When you say all the products exactly what do you mean? Everything within the MySQL suite will get recompiled when you do the usual build processes (like my mysql command, and mysqladmin etc). Thing that act as clients, say an admin tool (like MyCC) and PHP scripts that talk to the database should still work fine.

cheers

Jamie...
 
Old 05-08-2003, 12:35 AM   #6
SForsgren
Member
 
Registered: Apr 2003
Location: San Jose
Distribution: Red Hat 9
Posts: 68

Original Poster
Rep: Reputation: 15
When I tried to upgrade to 4.x, it had about 10 dependencies of things that depend on 3.23. When I read the MySQL install guide, it said that they changed the libmysql.so and that I would have to recompile/build anything that previously depended on 3.23 to make sure it was using the new header for libmysql. Does that make sense? Thanks
 
Old 05-08-2003, 04:21 AM   #7
jharris
Senior Member
 
Registered: May 2001
Location: Bristol, UK
Distribution: Slackware, Fedora, RHES
Posts: 2,243

Rep: Reputation: 46
I can see what you mean from reading http://www.mysql.com/doc/en/Upgrading-from-3.23.html but it also says "Old clients should work with a Version 4.0 server without any problems" and all of my stuff it working fine. I'd be tempted to take a backup of you mysql directory and just give it a go! You can always roll back it it all goes Pear-Shaped...

cheers

Jamie...
 
Old 05-09-2003, 01:53 AM   #8
SForsgren
Member
 
Registered: Apr 2003
Location: San Jose
Distribution: Red Hat 9
Posts: 68

Original Poster
Rep: Reputation: 15
The one thing I can't get installed is the *shared*.rpm file. It keeps telling me it needs libssl.so.0.9.6 which I have, but apparently I have just the file and it wants an RPM that matches I guess. If I try to install that, it wants libssl and libcrypto files. If I do a force since I have the files in /usr/lib, it Segmentation Faults everytime. Are you running 4.0 or 4.1? I was trying 4.1 so that I could use the subquery functionality. Also, have you been able to get the Control Center GUI to work? I got it running, but every few clicks, it shutsdown with no warning or errors. Just gone. Fun! :-) Thanks
 
Old 05-09-2003, 03:11 AM   #9
jharris
Senior Member
 
Registered: May 2001
Location: Bristol, UK
Distribution: Slackware, Fedora, RHES
Posts: 2,243

Rep: Reputation: 46
Quote:
Originally posted by SForsgren
Also, have you been able to get the Control Center GUI to work? I got it running, but every few clicks, it shutsdown with no warning or errors. Just gone. Fun! :-) Thanks
I've only ever used MyCC under Windows, although I started a source build on my box at home but needed up update QT and a bundle of other libraries, which I still haven't got around to finishing.

cheers

Jamie...
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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



Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql 4.0.24 to mysql 4.1.12 upgrade problem tuxrules Slackware 7 08-13-2005 07:43 PM
mysql upgrade no_names_left Linux - Software 1 03-04-2005 10:30 AM
Upgrade to MySQL 4? VxJasonxV Red Hat 1 02-06-2004 04:15 PM
mySQL Upgrade from 3.23 to 4.0 SForsgren Linux - Software 6 12-29-2003 05:11 AM
How do I upgrade MySQL... correro Linux - General 1 04-16-2003 12:43 PM


All times are GMT -5. The time now is 06:09 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration