I've not been using mysql for some time but did have it running for a
couple of small databases I use at home. It doesn't appear to work now,
the most obvious sympton being that msyqlshow shows a list of blank table
names.
[root@phoenix mysql]# rpm -q redhat-release
redhat-release-7.1-1
[root@phoenix mysql]# rpm -q MySQL; rpm -V MySQL
MySQL-3.23.36-1
[root@phoenix mysql]# mysqlshow
+-----------+
| Databases |
+-----------+
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
+-----------+
[root@phoenix mysql]#
The only thing I've noticed looking back at the mysql documentation is
that there appear to be new MyISAM tables which are different to the ones
I remember seing before (ISAM tables).
My machine has /var/lib/mysql point to /home/mysql and the directory
structure is the following:
[root@phoenix mysql]# ls -l /home/mysql
total 26
drwx------ 2 mysql mysql 1024 Jun 21 2000 ampr_database
drwx------ 2 mysql mysql 1024 Feb 24 2000 bounces
drwx------ 2 mysql mysql 1024 Oct 17 1999 cv
drwx------ 2 mysql mysql 1024 Mar 22 1999 ipaddress
drwx------ 2 mysql mysql 1024 Feb 9 1999 mysql
srwxrwxrwx 1 mysql mysql 0 Aug 31 18:38 mysql.sock
drwx------ 2 mysql mysql 1024 Nov 4 2000 negatives
-rw-r--r-- 1 root root 12264 Aug 31 17:46 negatives.tgz
drwx------ 2 mysql mysql 1024 May 18 2000 new_ip_address
-rw-r--r-- 1 mysql mysql 347 Aug 31 18:50 phoenix.ea4els.ampr.org.err
-rw-rw---- 1 mysql mysql 5 Aug 31 18:38 phoenix.ea4els.ampr.org.pid
drwx------ 2 mysql mysql 1024 Jul 18 2000 ricdb
drwx------ 2 mysql mysql 3072 Feb 19 2000 slash
drwx------ 2 mysql mysql 1024 Apr 22 21:54 test
[root@phoenix mysql]# ls -l /home/mysql/mysql
total 67
-rw-rw---- 1 mysql mysql 0 Feb 9 1999 columns_priv.ISD
-rw-rw---- 1 mysql mysql 1024 Feb 9 1999 columns_priv.ISM
-rw-rw---- 1 mysql mysql 8778 Feb 9 1999 columns_priv.frm
-rw-rw---- 1 mysql mysql 1309 Aug 31 18:22 db.ISD
-rw-rw---- 1 mysql mysql 3072 Aug 31 18:22 db.ISM
-rw-rw---- 1 mysql mysql 8982 Feb 9 1999 db.frm
-rw-rw---- 1 mysql mysql 0 Feb 9 1999 func.ISD
-rw-rw---- 1 mysql mysql 1024 Feb 9 1999 func.ISM
-rw-rw---- 1 mysql mysql 8641 Feb 9 1999 func.frm
-rw-rw---- 1 mysql mysql 0 Feb 9 1999 host.ISD
-rw-rw---- 1 mysql mysql 1024 Feb 9 1999 host.ISM
-rw-rw---- 1 mysql mysql 8958 Feb 9 1999 host.frm
-rw-rw---- 1 mysql mysql 0 Feb 9 1999 tables_priv.ISD
-rw-rw---- 1 mysql mysql 1024 Feb 9 1999 tables_priv.ISM
-rw-rw---- 1 mysql mysql 8877 Feb 9 1999 tables_priv.frm
The negatives.tgz file is copied from the negatives directory. When
copied over to a FreeBSD machine running the mysql version below the data
shows up correctly.
[ mysql Ver 10.12 Distrib 3.23.26-beta, for -freebsd4.2 (i386) ]
The mysql error log file shows no errors.
I'm sure that I'm doing something wrong which is in a FAQ but can't find
the answer at the moment. Any suggestions are greatly appreciated.
Thanks in advance.
Simon
--
Simon J Mudd, Madrid SPAIN. email: [EMAIL PROTECTED]
Tel: +34-91-408 4878, Mobile: +34-605-085 219
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php