=================================
= HOW TO DOWNLOAD THE DATABASE? =
=================================

The database can be freely downloaded using this FTP site. It contains a compressed gzip copy of the MySQL database (dpdb.contents.gz), with the following structure of related tables (please, refer to db_struct.gif).


Download the file and load it into a new database in you MySQL Server, as follows:
1. Create a new database:  mysqladmin create db_name -u root -p  
2. Decompress and load the database:  gzip -d < /PATH/db_name.contents.gz | mysql db_name -u root -p

(Note that you must do it from an account with privileges to create a new database in you MySQL server)



Figure legend for DPDB_Schema.png:
----------------------------------
- Green tables: primary database (information is retrieved from external databases: Genbank, Flybase, Popset)
- Red tables: secondary database (information is newly generated with PDA)
- Blue table = polsets: main table with the first basic storing unit: POLYMORPHIC SET (for a given gene and species)
- Yellow table = index_analysis: main table with the second basic storing unit: ANALYSIS UNIT (or ALIGNMENT) (for a given polymorphic set)