|
|
A version of the full ITIS database is available for downloading via HTTP.
We create database dump files once a month as new data are added to ITIS. The
updated files are posted near the end of each month at: http://www.itis.gov/downloads.
Note: You must have your own database server installed and running to use these files.
The basic steps to access and use the files are:
- Select the appropriate file for your database (Informix, MySql, or MS SQL Server).
- Download and extract the file on the system you will use to load the database.
- Use the instructions contained in the download's readme file to create and load the database on your system.
- You should now be able to access the data via your local database system.
Notes:
- For Informix, a Linux tar command
"tar cfz itisInformix.tar.gz itis.mmddyy"
was used to create a compressed tar file with all the ISO Latin 1 (ISO 8859-1) files associated with
the database, where mmddyy is the month, day and year the file was created.
- For MS Sql Server, a zip command
"zip itisMSSql.zip itisMS.mmddyy"
was used to create a tar file with all the ISO Latin 1 (ISO 8859-1) files associated with
the database.
- The MySql bulk load SQL script (ITIS.sql) was created with the mysqldump command. The zip file was
then created with a zip command
"zip itisMySQLBulk.zip itisMySQLmmddyy"
Data in this file uses the ISO Latin 1 (ISO 8859-1) representation.
- The MySql load by tables file was created with a Linux tar command
"tar cfz itisMySQLTables.tar.gz itisMySQLmmddyy"
was used to create a compressed tar file with all the ISO Latin 1 (ISO 8859-1) files associated with
the database
- For the Informix and MySql files, the end-of-line character on all these files is the new line (LF)
or (\n) character.
- For the MS Sql Server zip file, the end-of-line characters on all
files is the carriage return and newline (CR LF) or (\r\n) characters.
- About Diacritical Characters: All diacritical characters in ITIS have
been modified to reflect their ISO Latin 1 (ISO 8859-1) representation.
|
|