Hi I am not familiar with the syntax
mysql> CREATE TABLE oldreport_2002_12_08 LIKE oldreports; try mysql> CREATE TABLE oldreport_2002_12_08 as select * from oldreports; to create populated copy or mysql> CREATE TABLE oldreport_2002_12_08 as select * from oldreports where 1=2; to create an empty copy I hope this helps Simon Windsor Eml: [EMAIL PROTECTED] Tel: 01454 617689 Mob: 07960 321599 -----Original Message----- From: Cameron Ortis [mailto:[EMAIL PROTECTED] Sent: 16 February 2004 21:35 To: Bing Du Cc: [EMAIL PROTECTED] Subject: Re: Newbie 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] -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. Mailscanner thanks transtec Computers for their support. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. Mailscanner thanks transtec Computers for their support. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
