• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 672
  • Last Modified:

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
0
bryanford
Asked:
bryanford
1 Solution
 
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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
 
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now