LinuxQuestions.org
Did you know LQ has a Linux Hardware Compatibility List?
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 08-02-2006, 09:18 AM   #1
mclinkor
Member
 
Registered: Nov 2005
Posts: 63

Rep: Reputation: 15
Gentoo mysql 5.x


I've just installed mysql on gentoo (in order to migrate my server from a windows machine to linux), but gentoo automatically emerge 4.1.20. However, I installed the latest release on my Windows machine in February, which was 5.0.18. How can I get this version of mysql installed in gentoo.

I have mediawiki, so I need to be able to import the databases from the old server to the new server and data files between mysql versions are incompatible. Thanks.

- Ryan
 
Old 08-02-2006, 10:56 AM   #2
weibullguy
ReliaFree Maintainer
 
Registered: Aug 2004
Location: Kalamazoo, Michigan
Distribution: Slackware-current, Cross Linux from Scratch, Gentoo
Posts: 2,753
Blog Entries: 1

Rep: Reputation: 238Reputation: 238Reputation: 238
MySQL 4.1.20 is the latest stable version in the Gentoo repository that's why. To use one of the testing versions, currently 4.1.21 and 5.0.22, edit /etc/portage/package.keywords. Add this...
Code:
=dev-db/mysql-5.0.22 ~amd64
Then re-emerge mysql...
Code:
emerge -av mysql
That should give you mysql-5.0.22.

You'll need to use the correct testing branch. That is, replace amd64 with your processor type. The ~ means use testing. Also, once 5.0.22 moves to the stable branch, you'll need to remove that line from package.keywords. Until then, updates and recompilations with new USE flags will continue to use 5.0.22.
 
Old 08-02-2006, 10:31 PM   #3
mclinkor
Member
 
Registered: Nov 2005
Posts: 63

Original Poster
Rep: Reputation: 15
OK, cool that worked.

Now I have a new problem: I now have the upgraded version of mysql and I rebooted my machine and now I get the following error when attempting to start apache:

Apache2 has detected a syntax error in your configuration files:
Syntax error on line 5 of /etc/apache2/modules.d/70_mod_php5.conf: Cannot load /usr/lib/apache2/modules/libphp5.so into server: libmysqlclient.so.14: cannot open shared object file: No such file or directory.

I've checked for this libphp5.so file, and sure enough, it does exist. Everything was working before, so I odn't know why my php5 configuration has crapped out since I haven't changed it (only mysql configuration have I changed)
 
Old 08-02-2006, 11:25 PM   #4
mclinkor
Member
 
Registered: Nov 2005
Posts: 63

Original Poster
Rep: Reputation: 15
OK, I re-emerged php and that solved the problem
 
  


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
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 17 09-17-2014 03:13 PM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. suziecorbett Linux - Software 8 10-09-2008 02:52 AM
Gentoo + apache + mysql problem el_pajaro! Linux - Distributions 1 06-23-2006 03:46 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
Mysql Installation on Gentoo - mysqld.sock? Bob Gaskin Linux - Software 1 12-05-2003 12:27 AM


All times are GMT -5. The time now is 05:30 AM.

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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration