Forums



Page 1 of 2 12 LastLast
Results 1 to 15 of 19

Thread: how to upgrade mysql using SSH or WHM?

  1. 05-19-2004, 05:36 AM #1
    Sinewy
    Sinewy is offline
    Member Sinewy's Avatar
    Join Date
    May 2004
    Location
    Sydney, Australia
    Posts
    370

    Default how to upgrade mysql using SSH or WHM?

    anyone know how i can upgrade my server's mysql from 4.0.18 to 4.0.20?
    Reply With Quote Reply With Quote
  2. 05-19-2004, 08:13 AM #2
    mickalo
    mickalo is offline
    Member mickalo's Avatar
    Join Date
    Apr 2002
    Location
    N.W. Iowa
    Posts
    755

    Thumbs up Use at your own RISK!

    This is what I did on a RH 7.3 and 9.0 w/cpanels and haven't run into any problems yet But use at your own risk.... BESURE TO BACKUP ALL YOUR DATABASE FIRST!!
    Code:
    #First Do a complete back up of all databases
mysqldump --all-databases --opt -u root -p > /path/to/backup_file/ALL-db_backups.sql

#Stop MySQL:
service mysql stop 
(or /etc/init.d/mysql stop)
# make sure it all is stopped.

kill -9 mysqld
kill -9 mysql

# change to your install directory,. where we do it.
cd /usr/src/rpms

# then do the "wget" to get the new RPM files
#(Std Server)
wget http://mirror.services.wisc.edu/mysq....20-0.i386.rpm
#(Client programs)
wget http://mirror.services.wisc.edu/mysq....20-0.i386.rpm
#(Libraries and header files)
wget http://mirror.services.wisc.edu/mysq....20-0.i386.rpm
#(Dynamic client libraries)
wget http://mirror.services.wisc.edu/mysq....20-0.i386.rpm
wget http://mirror.services.wisc.edu/mysq....20-0.i386.rpm
#(Embedded Server)
wget http://mirror.services.wisc.edu/mysq....20-0.i386.rpm
#(BenchMark)
wget http://mirror.services.wisc.edu/mysq....20-0.i386.rpm

# then to do upgrades run the follow RPM commands.

rpm -Uvh MySQL-Max-server-4.0.20-0.i386.rpm
rpm -Uvh MySQL-client-4.0.20-0.i386.rpm
rpm -Uvh MySQL-devel-4.0.20-0.i386.rpm
rpm -Uvh MySQL-embedded-4.0.20-0.i386.rpm
rpm -Uvh MySQL-shared-compat-4.0.20-0.i386.rpm
rpm -Uvh MySQL-shared-4.0.20-0.i386.rpm
rpm -Uvh MySQL-bench-4.0.20-0.i386.rpm

# Start up MySQL again.
service mysql start 
#or 
/etc/init.d/mysql start
# then do
mysql -V
# to check version
    You should now have the MySQL 4.0.20 running. All privileges should remain the same as they where with 4.0.18. Again, besure you have a valid backup copy of all your databases.

    Good luck :
    Mickalo

    Thunder Rain Internet Publishing
    Providing Internet Solutions that work!
    Custom Perl and Database Programming
    Reply With Quote Reply With Quote
  3. 05-19-2004, 04:52 PM #3
    Born2Kill
    Born2Kill is offline
    Registered User Born2Kill's Avatar
    Join Date
    Jan 2004
    Location
    localhost or dev/null
    Posts
    119

    Default error

    [root@shells mysql-src]# rpm -Uvh MySQL-server-4.0.20-0.i386.rpm
    warning: MySQL-server-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
    error: Failed dependencies:
    libmysqlclient.so.10 is needed by (installed) mod_auth_mysql-1.11-12
    libmysqlclient.so.10 is needed by (installed) perl-DBD-MySQL-2.1021-3
    libmysqlclient.so.10 is needed by (installed) php-mysql-4.2.2-17.2
    [root@shells mysql-src]#


    what i need to do ?

    is this ok ?
    rpm -e perl-DBD-Mysql mysql-3.23 mysql-devel mysql-server qt-Mysql Mysql-python
    php-mysql perl-DBI.rpm
    Last edited by Born2Kill; 05-19-2004 at 05:03 PM.
    Reply With Quote Reply With Quote
  4. 05-19-2004, 05:04 PM #4
    mickalo
    mickalo is offline
    Member mickalo's Avatar
    Join Date
    Apr 2002
    Location
    N.W. Iowa
    Posts
    755

    Default

    do you have the libmysqlclient.so.10 installed, normally in the /usr/lib folder.

    what type of box are you installing this on ??

    Mickalo

    Thunder Rain Internet Publishing
    Providing Internet Solutions that work!
    Custom Perl and Database Programming
    Reply With Quote Reply With Quote
  5. 05-19-2004, 06:47 PM #5
    Born2Kill
    Born2Kill is offline
    Registered User Born2Kill's Avatar
    Join Date
    Jan 2004
    Location
    localhost or dev/null
    Posts
    119

    Default

    rh 9

    locate libmysqlclient.so.10
    /usr/lib/mysql/libmysqlclient.so.10.0.0
    /usr/lib/mysql/libmysqlclient.so.10

    Reply With Quote Reply With Quote
  6. 05-19-2004, 06:55 PM #6
    mickalo
    mickalo is offline
    Member mickalo's Avatar
    Join Date
    Apr 2002
    Location
    N.W. Iowa
    Posts
    755

    Default

    strange. that should be in the /usr/lib folder on the RH 9 we've installed the RPM's on...

    how was the MySQL version 4.0.18 installed, by RPM's or from source ??

    is the MySQL 4.0.18 running now ??

    Mickalo

    Thunder Rain Internet Publishing
    Providing Internet Solutions that work!
    Custom Perl and Database Programming
    Reply With Quote Reply With Quote
  7. 05-20-2004, 01:53 AM #7
    Born2Kill
    Born2Kill is offline
    Registered User Born2Kill's Avatar
    Join Date
    Jan 2004
    Location
    localhost or dev/null
    Posts
    119

    Default

    mysql -V
    mysql Ver 12.22 Distrib 4.0.18, for pc-linux (i686)

    from rpm
    Reply With Quote Reply With Quote
  8. 05-20-2004, 03:27 AM #8
    Sinewy
    Sinewy is offline
    Member Sinewy's Avatar
    Join Date
    May 2004
    Location
    Sydney, Australia
    Posts
    370

    Default

    will that procedure work on fedora 1.0?
    Reply With Quote Reply With Quote
  9. 05-20-2004, 03:28 AM #9
    Sinewy
    Sinewy is offline
    Member Sinewy's Avatar
    Join Date
    May 2004
    Location
    Sydney, Australia
    Posts
    370

    Default

    also /usr/src/rpms doesnt exist on my server. what should i do?
    Reply With Quote Reply With Quote
  10. 05-20-2004, 06:54 AM #10
    mickalo
    mickalo is offline
    Member mickalo's Avatar
    Join Date
    Apr 2002
    Location
    N.W. Iowa
    Posts
    755

    Default

    Originally posted by Sinewy
    will that procedure work on fedora 1.0?
    that I don't know. just did it on RH 7.3 and 9.0

    Thunder Rain Internet Publishing
    Providing Internet Solutions that work!
    Custom Perl and Database Programming
    Reply With Quote Reply With Quote
  11. 05-20-2004, 06:56 AM #11
    mickalo
    mickalo is offline
    Member mickalo's Avatar
    Join Date
    Apr 2002
    Location
    N.W. Iowa
    Posts
    755

    Default

    Originally posted by Sinewy
    also /usr/src/rpms doesnt exist on my server. what should i do?
    this is just a private folder we use off of the /usr/scr folder to install RPM files... you can use any folder you like,... this just keeps it tidy

    Mickalo

    Thunder Rain Internet Publishing
    Providing Internet Solutions that work!
    Custom Perl and Database Programming
    Reply With Quote Reply With Quote
  12. 05-20-2004, 07:09 AM #12
    mickalo
    mickalo is offline
    Member mickalo's Avatar
    Join Date
    Apr 2002
    Location
    N.W. Iowa
    Posts
    755

    Default

    Originally posted by Born2Kill
    mysql -V
    mysql Ver 12.22 Distrib 4.0.18, for pc-linux (i686)

    from rpm
    this is from our RH 9 cpanel box:
    mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686) where we update MySQL yesterday.

    You may to do some symbolic linking to see if that helps. Otherwise, if this on a Cpanel box, wait till Cpanel updates it via the upcp nigthly update.

    Are you sure this is on a RedHat 9.0 server w/Cpanel ?

    Mickalo

    Thunder Rain Internet Publishing
    Providing Internet Solutions that work!
    Custom Perl and Database Programming
    Reply With Quote Reply With Quote
  13. 05-20-2004, 09:11 AM #13
    Sinewy
    Sinewy is offline
    Member Sinewy's Avatar
    Join Date
    May 2004
    Location
    Sydney, Australia
    Posts
    370

    Default

    cpanel are slow updating :P

    i got the same thing as born2kill when i did mysql -V.
    Reply With Quote Reply With Quote
  14. 05-21-2004, 10:57 AM #14
    bikersraw
    bikersraw is offline
    Member
    Join Date
    Feb 2004
    Posts
    27

    Default

    Originally posted by mickalo
    this is from our RH 9 cpanel box:
    mysql Ver 12.22 Distrib 4.0.20, for pc-linux (i686) where we update MySQL yesterday.

    You may to do some symbolic linking to see if that helps. Otherwise, if this on a Cpanel box, wait till Cpanel updates it via the upcp nigthly update.

    Are you sure this is on a RedHat 9.0 server w/Cpanel ?

    Mickalo
    ./upcp didnt update mysql, said 4.0.18 was current

    also the link
    http://mirror.services.wisc.edu/mysq....20-0.i386.rpm

    has no file its for MySQL-shared-compat-4.0.20-0.i386.rpm
    Last edited by bikersraw; 05-21-2004 at 11:20 AM.
    Reply With Quote Reply With Quote
  15. 05-22-2004, 10:24 AM #15
    Sinewy
    Sinewy is offline
    Member Sinewy's Avatar
    Join Date
    May 2004
    Location
    Sydney, Australia
    Posts
    370

    Default

    root@server1 [/usr/src/rpms]# rpm -Uvh MySQL-bench-4.0.20-0.i386.rpm
    warning: MySQL-bench-4.0.20-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
    error: Failed dependencies:
    perl-DBI is needed by MySQL-bench-4.0.20-0


    what do i need to do there?
    Reply With Quote Reply With Quote
Page 1 of 2 12 LastLast
« ModSSL | Session timeouts »

Similar Threads

  1. MySQL query_cache_size = 0 after WHM Upgrade
    By yoachan in forum cPanel & WHM Discussions
    Replies: 13
    Last Post: 08-12-2011, 01:20 AM
  2. MySQL Upgrade via SSH.
    By comp99 in forum Database Discussions
    Replies: 3
    Last Post: 02-04-2011, 01:38 PM
  3. MySQL Upgrade via SSH.
    By comp99 in forum cPanel & WHM Discussions
    Replies: 0
    Last Post: 01-21-2011, 06:41 AM
  4. SOS I reinstall the mysql server under the SSH, and the WHM can't find mysql anymore!
    By Tanay in forum cPanel & WHM Discussions
    Replies: 1
    Last Post: 12-24-2003, 01:43 AM
  5. MySQL 3.23.53a Upgrade in latest WHM upgrade?
    By jsteel in forum cPanel & WHM Discussions
    Replies: 3
    Last Post: 10-19-2002, 03:11 AM