How about supplying an 'ls -l' listing of the /usr/local/mysql/data/books directory. Also give us the database connect code, and a snippet of you "select" code.
I haven't used mysql in a while, but it looks to me like there are some case sensitive issues with your file names. -- Hardy Merrill Senior Software Engineer Red Hat, Inc. Tay, William [[EMAIL PROTECTED]] wrote: > Hi, > > I am developing a Web application that invokes a Perl script, which in turn > access a mysql database. > > I have copied a sample database named books to the directory > /usr/local/mysql/data of a Linux machine, where I have also installed an > Apache Web server, mysql, DBI module and a DBD::mysql driver. A table named > Authors is in the books database. Within /usr/local/mysql/data/books, 3 > files (Authors.frm, authors.isd, authors.ism) belonging to the Authors table > are located. > > For testing purpose, I tried to execute the perl script on the command line > (perl -w test1.pl). The connection to the books database seemed to work > fine. However, executing the SELECT statement that follows gives the > following errors: > > DBD::mysql::st execute failed: Can't find file: 'Authors.ISD' (errno: 2) at > test1.pl line 30. > DBD::mysql::st execute failed: Can't find file: 'Authors.ISD' (errno: 2) at > test1.pl line 30. > > Would appreciate any comment on what could have happened and suggestions for > the solution. Thanks. > > Will
