Install MySQL on Debian????

I am a Linux first timer and am trying to install MySQL 5.0.19 on to Debian V3.1r1

I am using this document as a reference: http://mirrors.dotsrc.org/mysql/doc/refman/5.0/en/installing-binary.html

I want MySQL to be installed in /etc/mysql

Can someone please tell me how to do this? i.e. where to put the .tar.gz file, etc... im really lost.

Thanks in advance

Bryan
LVL 1
bryanfordAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

nedvisCommented:
Installing application programs ( e.g. MySQL ) in /etc folder is BAD IDEA !!!
/etc folder in Linux operating system is place where various initialization scripts and configuration files are usually located and
no other program should be run from within that ( /etc ) folder.

http://docs.roxen.com/roxen/2.1/tutorial/database/install.xml
-----------------------------------------------------------------------------
2. Install MySQL

apt-get install libmysqlclient6
apt-get install mysql-client
apt-get install mysql-server

PerlLib uses the perl DBI database interface.

apt-get install libdbd-mysql-perl
http://www.w3.org/1999/02/26-modules/User/RdfDB-debian
-------------------------------------------------------------------------------
http://www.projektfarm.com/en/support/debian_setup/
 

good luck
nedvis
0
dcarrionCommented:
Hello  Nedvis

If that's the case, why are so many application and services built in /etc/ by default?

Regards

Daniel Carrion
0
bryanfordAuthor Commented:
If i install it by the apt-get method i get the old version, mysql4. I am wanting to install the latest version, mysql 5.0.19
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

nedvisCommented:
Hi, dcarrion!
"If that's the case, why are so many application and services built in /etc/ by default?"
If you take a look at /etc folder you'l see dosens of programs/services configuration files and scripts rather than program EXECUTABLES  , usually located in   /sbin  ,  /usr/bin ,   /opt , /local  or in users home partitions/directories.
Under /etc: A Simple Guide   --- >   http://www.linuxjournal.com/article/8601

nedvis



0
nedvisCommented:
On Unix, a tar file binary distribution is installed by unpacking it at the installation location you choose (typically /usr/local/mysql) and creates the following directories in that location:
Directory       Contents of Directory
bin       Client programs and the mysqld server
data       Log files, databases
docs       Documentation, ChangeLog
include       Include (header) files
lib       Libraries
scripts       mysql_install_db
share/mysql       Error message files
sql-bench       Benchmarks
( http://mirrors.dotsrc.org/mysql/doc/refman/4.1/en/installation-layouts.html )
0
verborghsCommented:
Pick a mirror from : http://www.dotdeb.org/mirrors
 add the two lines to  "/etc/apt/sources.list" (pref. on top)
run
> apt-get update
> apt-cache search mysql
th previous command should give you a list with mysql related packages on of them is names mysql-server (there is one for version 5.X)
the full name is the part before the '-'
run
> apt-get install <package-name>

done

it will not be installed in  /etc/mysql. only the config files will be there but thats the good way (/etc = config) th database files wil be in  /var/lib/mysql (or something) libs and so wil be in the usual places
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
badianeCommented:
If you are using the stable branch and this 5.0 package is not from that branch there is a great chance that it will be removed by a dist-upgrade.  You should either pin it in /etc/preferences or do a dpkg --get-selections> selections , edit selections and change the install next to mysql-server-5.0 to hold, save selections and execute dpkg --set-selections < selections and that will keep it from being removed.  If you are going to be using Debian I recommend reading the apt and dpkg guides and there is a wonderful new book which goes into the depth of the package management system (look on amazon).
You might also want to go to apt-get.org and look for sources for packages which interest you but be warned if you don't know how to fix a broken system do not try it on a production machine.

http://en.wikipedia.org/wiki/Advanced_Packaging_Tool
http://www.debian-administration.org/articles/67
http://www.debian.org/doc/manuals/apt-howto/ch-apt-get.en.html


0
bryanfordAuthor Commented:
Thanks for all your posts,

verborghs solution was the simplest and quickest way and it worked great.

Sorry about the delay, i needed to buy new hardware for the debian system.

Bryan
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux Distributions

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.