Thanks for the quick reply! As root, I tried:
mysql> use research1data; mysql> show tables; +-------------------------+ | Tables_in_research1data | +-------------------------+ | oldreports | +-------------------------+ 1 row in set (0.00 sec) mysql> CREATE TABLE oldreport_2002_12_08 LIKE oldreports; But I got the following error: ERROR 1: Can't create/write to file './research1data/oldreport_2002_12_08.frm' (Errcode: 13) I'm SU and root in mysql so I don't thinks it's a permissions problem. Is my SQL correct? Cam On Mon, 2004-02-16 at 13:09, Bing Du wrote: > Have you tried creating a table called 'oldreport_2002_12_08' following > the instructions on http://www.mysql.com/doc/en/CREATE_TABLE.html? > > Bing > > > I have spent some time in the past with mysql but am far from an > > experienced database head. A while back I received a some mysql data > > for a research project. The files are: > > > > $ cd /usr/local/mysql/research1data > > $ ls -lh > > -rw-rw---- 1 mysql mysql 21G Jun 20 2003 oldreport_2002_12_08.MYD > > -rw-rw---- 1 mysql mysql 12G Jun 20 2003 oldreport_2002_12_08.MYI > > -rw-rw---- 1 mysql mysql 17G Jun 19 2003 oldreports.MYD > > -rw-rw---- 1 mysql mysql 10G Dec 5 19:32 oldreports.MYI > > -rw-rw---- 1 mysql mysql 8K Jun 20 2003 oldreports.frm > > > > In mysql I type: > > > > mysql> show databases; > > +---------------+ > > | Database | > > +---------------+ > > | research1data | > > | mysql | > > +---------------+ > > mysql> use research1data; > > mysql> show tables; > > +-------------------------+ > > | Tables_in_research1data | > > +-------------------------+ > > | oldreports | > > +-------------------------+ > > 1 row in set (0.00 sec) > > > > I have fumbled around mailing lists, tutorials, and a reference manual > > or two. My newbie questions are: how do I load oldreport_2002_12_08 in > > addition to oldreports? Do I need to somehow create an > > oldreport_2002_12_08.frm file? I assumed that I would have been sent > > two .frm files but ... is there a way to use oldreports.frm for both? > > > > Many thanks for your help, > > > > Cam > > > > Additional info: > > OS = Freebsd 4.9 > > MySQL = 4.1.1 > > > > ---------------------------------------------------------------------- > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]