can't install / uninstall MySQL

[pc]

hi everyone,

we have a server on which someone blew away the MySQL 4 progs directory
before installing MySQL 5. When installing MySQL 5 the installation
failed with an error stating that it was unable to create system tables
as the MySQL 4 directory did not exist.

We are now unable to uninstall MySQL 5:

[root@server1 local]# rpm -i
MySQL-server-standard-5.0.18-0.rhel3.i386.rp m
warning: MySQL-server-standard-5.0.18-0.rhel3.i386.rp m: V3 DSA
signature: NOKEY, key ID 5072e1f5
package MySQL-server-standard-5.0.18-0.rhel3 is already
installed

[root@server1 local]# rpm -e
MySQL-server-standard-5.0.18-0.rhel3.i386.rp m
error: package MySQL-server-standard-5.0.18-0.rhel3.i386.rp m is not
installed

Help!

TIA

eddiec :-)

[pc]

problem solved, just recreated the missing directories

eddiec :-)

[pc]

hi everyone,

I managed to uninstall MySQL 5 (just removed the rpm from the end of
rpm -e). but I can't remove MySQL 4 (rpm says it's not installed, maybe
this was a manual installation). When I try to install MySQL 5 this is
what we get:

[root@server1 local]# rpm -i
MySQL-server-standard-5.0.18-0.rhel3.i386.rp m
warning: MySQL-server-standard-5.0.18-0.rhel3.i386.rp m: V3 DSA
signature: NOKEY, key ID 5072e1f5
mkdir: cannot create directory
`/usr/local/mysql-standard-4.0.22-pc-linux-i686/d ata': No
such file or directory
chmod: failed to get attributes of
`/usr/local/mysql-standard-4.0.22-pc-linux-i6 86/data': No
such file or directory
mkdir: cannot create directory
`/usr/local/mysql-standard-4.0.22-pc-linux-i686/d ata/mysql':
No such file or directory
chmod: failed to get attributes of
`/usr/local/mysql-standard-4.0.22-pc-linux-i6 86/data/mysql':
No such file or directory
mkdir: cannot create directory
`/usr/local/mysql-standard-4.0.22-pc-linux-i686/d ata/test':
No such file or directory
chmod: failed to get attributes of
`/usr/local/mysql-standard-4.0.22-pc-linux-i6 86/data/test':
No such file or directory
chown: failed to get attributes of
`/usr/local/mysql-standard-4.0.22-pc-linux-i6 86/data': No
such file or directory
chown: failed to get attributes of
`/usr/local/mysql-standard-4.0.22-pc-linux-i6 86/data/mysql':
No such file or directory
chown: failed to get attributes of
`/usr/local/mysql-standard-4.0.22-pc-linux-i6 86/data/test':
No such file or directory
060112 11:39:37 [Warning] Can't create test file
/usr/local/mysql-standard-4.0.2
2-pc-linux-i686/data/server1.lower-test
/usr/sbin/mysqld: Can't change dir to
'/usr/local/mysql-standard-4.0.22-pc-linux -i686/data/'
(Errcode: 2)
060112 11:39:37 [ERROR] Aborting

060112 11:39:37 [Note] /usr/sbin/mysqld: Shutdown complete

/usr/bin/mysql_create_sy stem_tables: line 766: 8170 Broken pipe
cat <<END_OF_DATA
use mysql;
set table_type=myis am;
$c_d
$i_d

$c_h
$i_h

$c_u
$i_u

$c_f
$i_f

$c_t
$c_c

$c_ht
$c_hc
$c_hr
$c_hk

$c_tzn
$i_tzn
$c_tz
$i_tz
$c_tzt
$i_tzt
$c_tztt
$i_tztt
$c_tzls
$i_tzls

$c_p
$c_pp

END_OF_DATA

Installation of system tables failed!

Examine the logs in /usr/local/mysql-standard-4.0.22-pc-linux-i686/data
for more information.
You can also try to start the mysqld daemon with:
/usr/sbin/mysqld --skip-grant &
You can use the command line tool
/usr/bin/mysql to connect to the mysql
database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql
mysql> show tables

Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /usr/local/mysql-standard-4.0.22-pc-linux-i686/data
that may be helpful.

The latest information about MySQL is available on the web at
http://www.mysql.com
Please consult the MySQL manual section: 'Problems running
mysql_install_d b',
and the manual section that describes problems on your OS.
Another information source is the MySQL email archive.
Please check all of the above before mailing us!
And if you do mail us, you MUST use the /usr/bin/mysqlbug script!
Starting MySQL.......... ............... .......... ERROR!

It can't open the MySQL 4 directory as this has been deleted.

eddiec :-)