LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 02-22-2003, 03:08 PM   #1
JHuizingh
Member
 
Registered: Jun 2001
Distribution: Gentoo 1.4
Posts: 140

Rep: Reputation: 15
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Recovering a mysql database irvken Linux - Software 2 10-09-2005 06:27 PM
Writing an app that uses a mysql database without installing mysql server? QtCoder Programming 4 08-09-2004 03:43 PM
Rename mysql database pk21 Linux - Newbie 4 06-11-2004 06:54 AM
MYSQL help - mysql database missing eloviyandhi Linux - Software 1 03-20-2004 10:20 PM
mysql database huno Linux - General 8 02-11-2003 09:15 PM


All times are GMT -5. The time now is 07:01 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration