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]