I downloaded a TAR file from a link I found at
http://www.itis.usda.gov/ftp_download.html
The page also includes the following instructions:
* The schema file (itis.sql) is an ASCII file that
includes all of the create table statements plus
additional information. This will allow comparison to
the schema files that are available in the future to
determine any changes. The table files are in an ASCII
pipe delimited format. Within the schema file the
information about each table may be found:
{ TABLE "itis".kingdoms row size=18 number of
columns=3 index size=12 }
{ unload file name=kingd00104.unl number of rows=5 }
create table "itis".kingdoms
(
kingdom_id serial not null ,
kingdom_name char(10) not null ,
update_date date not null
);
revoke all on "itis".kingdoms from "public";
create unique index "itis".kingdoms_key on
"itis".kingdoms
(kingdom_id);
alter table "itis".kingdoms add constraint primary key
(kingdom_id)
constraint "itis".u119_9 ;
In addition to the create table statements, the
itis.sql file provides the "unload file name"
information and constraint and index statements. The
unload file name can be used to map the unload file to
the table. For example, to load the kingdom, the
kingd00104.unl file is used.
* * * * * * * * * *
Can someone tell me what all this means???
After unzipping the file, I have an SQL file named
itis, along with a bunch of files with an .unl
extension. If I understand correctly, I'm supposed to
activate the .unl files with the SQL file, right?
But I'm not even sure how to open the SQL file. I
tried importing it into my database with phpMyAdmin
but got this error message:
SQL-query :
{ DATABASE itis delimiter | } GRANT dba TO "itis"
MySQL said:
#1064 - You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server
version for the right syntax to use near '{ DATABASE
itis delimiter | }
grant dba to "itis"' at line 1
So what's the easiest way to get all these tables
imported into my database?
Thanks.
__________________________________
Do you Yahoo!?
All your favorites on one personal page – Try My Yahoo!
http://my.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
