Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 9th December 2005, 15:38
sushestvo sushestvo is offline
Member
 
Join Date: Oct 2005
Posts: 72
Thanks: 0
Thanked 0 Times in 0 Posts
Default upgrading mysql from 3.23.58 to 4.xx

How can I upgrade mysql on my server from 3.23.58 to latest 4.xx version?
will I loose data or functionality?
Reply With Quote
Sponsored Links
  #2  
Old 9th December 2005, 15:43
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,488
Thanks: 813
Thanked 5,259 Times in 4,123 Posts
Default

Which linux distribution do you use?
Reply With Quote
  #3  
Old 9th December 2005, 15:49
sushestvo sushestvo is offline
Member
 
Join Date: Oct 2005
Posts: 72
Thanks: 0
Thanked 0 Times in 0 Posts
Default

fedora core 3
i have apt installed
Reply With Quote
  #4  
Old 9th December 2005, 15:52
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,488
Thanks: 813
Thanked 5,259 Times in 4,123 Posts
Default

Have you checked if there is an mysql 4 package available?

Run:

apt-get update
apt-cache search mysql

and search in the output for a mysql 4 package. If there is one, i recommend to make a abckup from your mysql databases (/var/lib/mysql) install the mysql 4 package with apt.
Reply With Quote
  #5  
Old 9th December 2005, 15:59
sushestvo sushestvo is offline
Member
 
Join Date: Oct 2005
Posts: 72
Thanks: 0
Thanked 0 Times in 0 Posts
Default

how do i install mysql 4.1 with apt and all the dependencies? like client, dev and etc.
Reply With Quote
  #6  
Old 9th December 2005, 16:02
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,488
Thanks: 813
Thanked 5,259 Times in 4,123 Posts
Default

Please post the package names with mysql and 4 in the name that you got after you run the commands above.
Reply With Quote
  #7  
Old 9th December 2005, 16:05
sushestvo sushestvo is offline
Member
 
Join Date: Oct 2005
Posts: 72
Thanks: 0
Thanked 0 Times in 0 Posts
Default

[root@local ~]# apt-get update
: 1 http://ayo.freshrpms.net fedora/linux/3/i386 release [2136B]
: 2 http://ayo.freshrpms.net fedora/linux/1/i386 release [1807B]
3943B 0s (5056B/s).
http://ayo.freshrpms.net fedora/linux/3/i386/core pkglist
http://ayo.freshrpms.net fedora/linux/3/i386/core release
: 1 http://ayo.freshrpms.net fedora/linux/3/i386/updates pkglist [1187kB]
http://ayo.freshrpms.net fedora/linux/3/i386/updates release
: 2 http://ayo.freshrpms.net fedora/linux/3/i386/freshrpms pkglist [242kB]
http://ayo.freshrpms.net fedora/linux/3/i386/freshrpms release
: 3 http://ayo.freshrpms.net fedora/linux/3/i386/tupdates pkglist [75,1kB]
http://ayo.freshrpms.net fedora/linux/3/i386/tupdates release
http://ayo.freshrpms.net fedora/linux/3/i386/core srclist
: 4 http://ayo.freshrpms.net fedora/linux/3/i386/updates srclist [76,9kB]
: 5 http://ayo.freshrpms.net fedora/linux/3/i386/freshrpms srclist [44,9kB]
: 6 http://ayo.freshrpms.net fedora/linux/3/i386/tupdates srclist [5332B]
http://ayo.freshrpms.net fedora/linux/1/i386/core pkglist
http://ayo.freshrpms.net fedora/linux/1/i386/core release
http://ayo.freshrpms.net fedora/linux/1/i386/updates pkglist
http://ayo.freshrpms.net fedora/linux/1/i386/updates release
http://ayo.freshrpms.net fedora/linux/1/i386/freshrpms pkglist
http://ayo.freshrpms.net fedora/linux/1/i386/freshrpms release
1631kB 5s (281kB/s).
[root@local ~]# apt-cache search mysql
MySQL-python - An interface to MySQL
libdbi-dbd-mysql - MySQL plugin for libdbi
mod_auth_mysql - Basic authentication for the Apache web server using a MySQL database.
perl-DBD-MySQL - A MySQL interface for perl
tora - A GUI-based database development program.
unixODBC - A complete ODBC driver manager for Linux.
MyODBC - ODBC driver for MySQL
freeradius-mysql - MySQL bindings for freeradius
gda-mysql - GDA MySQL Provider
koffice - A set of office applications for KDE.
mysql - MySQL client programs and shared libraries.
mysql-bench - MySQL benchmark scripts and data.
mysql-devel - Files for development of MySQL applications.
mysql-server - The MySQL server and related files.
openoffice.org-libs - OpenOffice.org shared libraries
php-mysql - A module for PHP applications that use MySQL databases.
qt-MySQL - MySQL drivers for Qt's SQL classes.
lighttpd-mod_mysql_vhost - Virtual host module for lighttpd that uses a MySQL database
proftpd - Flexible, stable and highly-configurable FTP server
squale - Persistent SQL database connection libarary and daemon
Reply With Quote
  #8  
Old 9th December 2005, 16:10
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,488
Thanks: 813
Thanked 5,259 Times in 4,123 Posts
Default

Ok. As there are no mysql4 packages, you cant upgrade to mysql 4.x with apt. Maybe you can install a mysql .rpm package from mysql:

http://dev.mysql.com/downloads/mysql/4.1.html

But I'am not sure if you will get dependency problems and if you will have to uninstall or deactivate your current mysql daemon before.
Reply With Quote
  #9  
Old 9th December 2005, 16:29
sushestvo sushestvo is offline
Member
 
Join Date: Oct 2005
Posts: 72
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Found this interesting link
http://resources.angelosystems.com/c...5/MySQL_4.html
Does that mean I should use yum and install FC4 package on FC3? Will that work?
Reply With Quote
  #10  
Old 9th December 2005, 16:36
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
 
Default

Quote:
Originally Posted by sushestvo
Found this interesting link
http://resources.angelosystems.com/c...5/MySQL_4.html
Does that mean I should use yum and install FC4 package on FC3? Will that work?
I don't know. This is a trial and error thing...
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Failed at MySQL lhatle Installation/Configuration 4 29th November 2005 01:26
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 16:37
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 09:41
Mysql ejs Installation/Configuration 5 12th August 2005 07:01
MySQL Privileges mcfly Server Operation 4 26th May 2005 19:00


All times are GMT +2. The time now is 15:42.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.