Mysql database from cd
I have a cd with a mysql database that I want to use, but I can't figure out how to use the database. There is a directory on the cd called "books" on the cd that contains the files:
AuthorISBN.frm
Authors.frm
Publishers.frm
titles.frm
authorisbn.isd
authors.isd
publishers.isd
titles.isd
authorisbn.ism
authors.ism
publishers.ism
titles.ism
I am using Redhat 8.0, so I copied these files into /var/lib/mysql/books.
I then opened up the mysql client and typed:
mysql> connect books;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in table 'AuthorISBN'
Didn't find any fields in table 'Authors'
Didn't find any fields in table 'Publishers'
Didn't find any fields in table 'titles'
Connection id: 5
Current database: books
mysql> show tables;
+-----------------+
| Tables_in_books |
+-----------------+
| AuthorISBN |
| Authors |
| Publishers |
| titles |
+-----------------+
4 rows in set (0.00 sec)
mysql> select * from Authors;
ERROR 1017: Can't find file: 'Authors.ISD' (errno: 2)
mysql>
so, it looks like the database sees the files, but it doesn't work completely. Is there some way to import these files or can I make changes so they work properly?
Thanks in advance.
|