How can I upgrade mysql on my server from 3.23.58 to latest 4.xx version? will I loose data or functionality?
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.
Please post the package names with mysql and 4 in the name that you got after you run the commands above.
[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
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.
Found this interesting link http://resources.angelosystems.com/content/163/PHP_5/MySQL_4.html Does that mean I should use yum and install FC4 package on FC3? Will that work?
