From: Daevid Vincent
Date: September 19 2003 6:20pm
Subject: RPM Upgrade from 3.23.52 to 4.0.15 :: all my database show up as empty.
List-Archive: http://lists.mysql.com/mysql/150155
Message-Id: <002701c37eda$abbb6060$8d0aa8c0@gabriel>
MIME-Version: 1.0
Content-Type: text/plain;	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Sorry for the double post. I sent this yesterday without any replies, so =
I'm
wondering if it made it out there?

-----Original Message-----
From: Daevid Vincent [mailto:daevid@stripped]=20
Sent: Thursday, September 18, 2003 11:29 AM
To: mysql@stripped
Subject: Upgrade from 3.23.52 to 4.0.15 all my database show up as =
empty.
Importance: High

After the rpm upgrade, all my databases show up (ie. In
phpMyAdmin for example), but they all show (-) for the tables -- in
otherwords, they're aren't any tables. /var/lib/mysql/ shows all the
databases and there appears to be data and files in the directories.
Reverting back to the 3.23 version they all work. No errors shown in the
.err file either...

[root@daevid mysql]# cat daevid.err=20
030918 11:29:50  mysqld started
030918 11:29:50  InnoDB: Started
/usr/sbin/mysqld: ready for connections.
Version: '4.0.15-standard'  socket: '/tmp/mysql.sock'  port: 3306

I have a RedHat 8 system that's run solid for years. I was running the
3.23.52 RPMS and recently a project required me to have 4.0.15 (for
cascading updates). I removed all the old rpms, then installed the new =
rpms.
No problems encountered except I can't seem to remove
"mysql-server-3.23.52-3" from the rpm list but I don't think it's really
there on my system. I performed this same update last week on another =
RH8
system running 2.23.56. in fact I'm using the exact same 4.0.15 rpms =
copied
from the other machine.  Google search didn't turn up any solutions that =
I
saw.

[root@daevid mysql]# rpm -qa | grep "mysql" -i
libdbi-dbd-mysql-0.6.5-2
MySQL-shared-compat-4.0.15-0
qt-MySQL-3.0.5-17
php-mysql-4.1.2-7.3.4
mysql-server-3.23.52-3
MySQL-python-0.9.1-4
MySQL-client-4.0.15-0
perl-DBD-MySQL-2.1017-3
mod_auth_mysql-1.11-1
arkpmysql-5.1.7-1
MySQL-devel-4.0.15-0
MySQL-shared-4.0.15-0
MySQL-server-4.0.15-0

[root@daevid mysql]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10 to server version: 4.0.15-standard

[root@daevid mysql]# mysql --version;
mysql  Ver 12.21 Distrib 4.0.15, for pc-linux (i686)


[root@daevid mysql]# cat /etc/my.cnf=20
[client]
socket=3D/tmp/mysql.sock

[mysqld]
port=3D3306
socket=3D/tmp/mysql.sock

innodb_data_home_dir=3D

#                                  Data file(s) must be able to
#                                  hold your data and indexes.
#                                  Make sure you have enough
#                                  free disk space.
innodb_data_file_path =3D ibdata1:10M:autoextend

#                                  Set buffer pool size to
#                                  50 - 80 % of your computer's
#                                  memory
set-variable =3D innodb_buffer_pool_size=3D70M
set-variable =3D innodb_additional_mem_pool_size=3D10M

#                                  Set the log file size to about
#                                  25 % of the buffer pool size
set-variable =3D innodb_log_file_size=3D20M
set-variable =3D innodb_log_buffer_size=3D8M

#                                  Set ..flush_log_at_trx_commit
#                                  to 0 if you can afford losing
#                                  some last transactions=20
innodb_flush_log_at_trx_commit=3D1

set-variable =3D innodb_lock_wait_timeout=3D50
#innodb_flush_method=3Dfdatasync
#set-variable =3D innodb_thread_concurrency=3D5

skip-locking
set-variable =3D max_connections=3D200
#set-variable =3D read_buffer_size=3D1M
set-variable =3D sort_buffer=3D1M
#                                  Set key_buffer to 5 - 50%
#                                  of your RAM depending on how
#                                  much you use MyISAM tables, but
#                                  keep key_buffer + InnoDB
#                                  buffer pool size < 80% of
#                                  your RAM
set-variable =3D key_buffer=3D10M


--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    =
http://lists.mysql.com/mysql?unsub=3Ddaevid@stripped