The critical steps of deleting an old copy of MySQL, and installing and starting up a nice new clean one!
(the numbers are my "history number" - I did a lot of ls-ing and vi-ing in between!)
1001 cd /usr/local
1004 rm -rf mysql-5.1.24-rc-linux-i686-icc-glibc23/
1006 rm mysql
1009 tar xzf /home/trainee/bristol/mysql-5.1.24-rc-linux-i686-icc-glibc23.tar.gz
1013 ln -s mysql-5.1.24-rc-linux-i686-icc-glibc23 mysql
1014 cd mysql
1016 vi INSTALL-BINARY
1017 chown -R mysql.mysql .
1019 scripts/mysql_install_db --user=mysql
1021 chown -R root .
1022 chown -R mysql data
1024 bin/mysqld_safe --user=mysql &
Notes:
a) There may be a need to shut the Ole Daemon down first.
b) Beware files /etc/my.cnf and /root/.my.cnf which may exist from a previous install and have the database parameters and directories set to goodness only knows where
c) I HAVE DESTROYED ALL THE DATA that was being held in the previous database (but then I have a good backup, yah?)
d) I need to go on and set up the password and accounts for the database. It's left wide open with the base install - but not as wide as it used to be
e) To make it reload on reboot, the mysql.server script that's supplied with the download should be put into /etc/init.d, with appropriate links from rc5.d or rc3.d
(written 2008-12-11)
Associated topics are indexed as below, or enter http://melksh.am/nnnn for individual articles
S153 - Sourcing, Running and Configuring MySQL [192] Current MySQL and PHP paths and upgrades - (2005-01-28)
[334] Symbolic links and hard links - (2005-06-02)
[489] Which MySQL server am I using? - (2005-11-07)
[515] MySQL - an FAQ - (2005-12-03)
[535] MySQL permissions and privileges - (2005-12-20)
[591] Key facts - SQL and MySQL - (2006-02-04)
[907] Browser -> httpd -> Tomcat -> MySQL. Restarting. - (2006-10-28)
[1095] Apache httpd , browser, MySQL and MySQL client downloads - (2007-02-28)
[1123] mysqldump and mysqlrestore - (2007-03-30)
[1131] MySQL - Password security (authentication protocol) - (2007-04-02)
[1689] Some sideways thoughts on the news - (2008-06-27)
[1731] Apache httpd, MySQL, PHP - installation procedure - (2008-08-01)
[1771] More HowTo diagrams - MySQL, Tomcat and Java - (2008-08-24)
[2085] MySQL - licensing issues, even with using the name - (2009-03-16)
[2209] Monitoring and Tuning your MySQL installation - (2009-05-31)
[2426] Which version of MySQL am I running? - (2009-09-26)
[2444] Potted MySQL installation - (2009-10-09)
[2445] Securing MySQL on a production server - (2009-10-09)
[2458] Cant connect to local MySQL server through socket /tmp/mysql.sock - (2009-10-17)
[4390] Checking MySQL database backups have worked (not failed) - (2015-01-10)
[4406] Fixing damaged MySQL tables - Error 1712 and Error 2013 - (2015-01-25)
[4487] Starting MySQL. ERROR! The server quit without updating PID file - how we fixed it. - (2015-05-06)
Some other Articles
mod_proxy_ajp and mod_proxy_balancer examplesPredictive Load Balancing - PHP and / or JavaGetting hold of the wrong end of the stickQuick Summary - PHP installationSummary of MySQL installation on a Linux systemLidl opens in MelkshamLearning to Program in CTraining Passports - booking a training programFrosty Morning, foggy eveningBath Christmas Market