A database of authors who contributed to the IPCC Assessment Reports, including contributions chapter per chapter (participations) with roles, institutions and countries.
Run import-from-csv-to-mysql.sh.
The import script creates a new database named ipcc (deleting
the previous database of the same name, if any) and loads data
from the CSV files in the folder data into tables. Extra columns
are included in the CSV files with names to explicit the identifiers;
these columns, which include "(INFO)" in their names, are skipped
at import; they are absent from created tables.
Run export-from-mysql-to-csv.sh.
The export script exports tables of the database ipcc to CSV files
in the folder data, adding extra columns with names to explicit
identifiers: author name for author id, institution and country names
for institution-country id, etc.
Both scripts connect by default to a local MySQL database as root user; a different user and host can be provided as parameters (see details at the start of each script file).