469,331 Members | 5,302 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,331 developers. It's quick & easy.

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.rpm
warning: MySQL-server-standard-5.0.18-0.rhel3.i386.rpm: 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.rpm
error: package MySQL-server-standard-5.0.18-0.rhel3.i386.rpm is not
installed

Help!

TIA

eddiec :-)

Jan 12 '06 #1
2 5843
pc
problem solved, just recreated the missing directories

eddiec :-)

Jan 12 '06 #2
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.rpm
warning: MySQL-server-standard-5.0.18-0.rhel3.i386.rpm: 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_system_tables: line 766: 8170 Broken pipe
cat <<END_OF_DATA
use mysql;
set table_type=myisam;
$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_db',
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 :-)

Jan 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by DaveHenrie | last post: by
reply views Thread by John Richardson | last post: by
3 posts views Thread by Chris Wagner | last post: by
2 posts views Thread by John Keers | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by haryvincent176 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.