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]
