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: Lьneburg, Germany
Posts: 35,792
Thanks: 821
Thanked 5,338 Times in 4,188 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: Lьneburg, Germany
Posts: 35,792
Thanks: 821
Thanked 5,338 Times in 4,188 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: Lьneburg, Germany
Posts: 35,792
Thanks: 821
Thanked 5,338 Times in 4,188 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: Lьneburg, Germany
Posts: 35,792
Thanks: 821
Thanked 5,338 Times in 4,188 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: Lьneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 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 09:07.


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