hello
I am newbie to mysql , I needed to upgrade it to version 4.1 urgently .
so I tried to install from rpm it didn't work due to conflicts
so what I did is deleted all directories that contain the word mysql and got a new version (4.1) from mysql
when I try to run configure I got the following( as if it recognizes an installed version) and no make file is created!!!!!







thaknsOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you. If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h localhost password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
mysql.com
Support MySQL by buying support/licenses at order.mysql.com
Starting the mysqld server. You can test that it is up and running
with the command:
./bin/mysqladmin version
[root@localhost mysql-standard-4.1.13-pc-linux-gnu-i686]# Starting mysqld daemon with databases from /home/cbb/downloads/mysql-standard-4.1.13-pc-linux-gnu-i686/data
STOPPING server from pid file /home/cbb/downloads/mysql-standard-4.1.13-pc-linux-gnu-i686/data/localhost.pid




thanks
Camille
050814 20:55:41 mysqld ended

You are using an rpm, so use the rpm software manager.

Go into mandrake control centre.
Click on software management.
Click on remove software (The big red minus).
Type mysql into the search query, and remove the installed version of mysql.
Click on install software (The big green plus) and install the new rpm.

Many thanks for your help,
but I have a new problem
I did uninstall the 4.0 version with the mandrake remove utility,
and I have downloaded from rpmfind the v 4.1 version which needed some dependencies,
I managed to get them all except the perl-base which said it was conflicting with a previous installation,
again I went to the removal utility and it couldn't find the perl-base installed
so what should I do , can't install the server because it requires mysql-common which requires perl-base and perl-DBD and I can't install perl base




rpm -ivh perl-base-5.8.6-6mdk.i586.rpm
Preparing... ########################################### [100%]
file /usr/bin/perl5 from install of perl-base-5.8.6-6mdk conflicts with file from package perl-base-5.8.1-0.RC4.3.392mdk
file /usr/bin/suidperl from install of perl-base-5.8.6-6mdk conflicts with file from package perl-base-5.8.1-0.RC4..3.92mdk



MAnny thanks again
CAmille

You are trying to install a later version of perl (5.8.6) which is probably not a good idea.
Mandrake 9.2 is a bit out of date these days so install the one it came with which is 5.8.1 using the --replacepkgs or --replacefiles option. The rpm is on cd 1 in /Mandrake/RPMS.

OR

Using the mandrake update utility (the blue curly arrow), this should point you at 5.8.1 RC4.3.3.92. Install this, overwriting any installed version.


It also looks like you are using the command line to install the package. Using MCC will automatically install any depandancies.

so obviously installing 5.8.1 will not be enough for mysql-common-4.1 because it needs per 5.8.6
I loose any chance of upgrading mysql !!!
I have been using 9.2 for a longtime and it's fine and stable, guess I need to upgrade to mandriva 2005

Regards
Camille

This is a quote from the mysql site:
Perl support for MySQL is provided by means of the DBI/DBD client interface. The interface requires Perl Version 5.6.0 or later. It does not work if you have an older version of Perl.
endQuote.
5.8.1 > 5.6

What you need is the perl-mysql 2.9 or above.

This is the perl-dbd-mysql package from sourceforge. Try it, it can't make things any worse. Or maybe it can, but try it anyway. It is for redhat 7.3, so should work, since mandy is based on RH

http://rpmfind.net/linux/RPM/sourcef...03-1.i386.html