childes-db will be updated every 6 months with a most recent parse of the CHILDES database, reflecting the addition of new corpora and the revision of older annotations (more details can be found in the documentation). Visualizations and the childesr package will always use the most recent database version by default. The primary method of interacting with childes-db, the R API
childesr, can be directed to use any recent database version by using the
version parameter. We provide here compressed .sql files for users wanting to refer to older releases or to install the database locally.
To use the .sql file you will need to have a working version of MySQL server and a client. We recommend MAMP and SequelPro as easy-to-use server and client software. Loading the database from the .sql file is fastest and easiest from the command line client. Remember to replace the name of the .sql file with the filename you downloaded.
mysql --host=127.0.0.1 --port 8889 --user=root --password=root(assumes default MAMP credentials)
.bashrcfile in your home directory:
create database childesdb
mysql --host=127.0.0.1 --port 8889 --user=root --password=root childesdb < childes-db-version-0.1.0.sql
childesrregarding how to use a local database server