Skip to content

Accessing previous database versions

Mika Braginsky edited this page Sep 8, 2022 · 6 revisions

Periodic snapshots of the Wordbank database are saved and are available for download.

To set up a previous version of the database, you need to have MySQL server installed (the details of how to do this depend on your operating system).

You then need to pick which version of the database you'd like to download. The list of available versions can be accessed here.

Then run the following commands:

wb_version=22072022 # version you want goes here

# download .sql file
wget https://wordbank-versioning.s3.amazonaws.com/wordbank_${wb_version}.sql

# set up .sql file into a MySQL database
sudo mysql < wordbank_${wb_version}.sql

Once you have the database set up, you can access it from wordbankr by specifying the db_args that correspond to your local MySQL host, user, and password.