A REST API for https://www.openthesaurus.de/ data with Spring Boot.
Create
CREATE DATABASE `openthesaurus`;
CREATE USER 'openthesaurus' IDENTIFIED BY 'ztZC2nRxWKE4itV';
GRANT USAGE ON *.* TO 'openthesaurus'@'%' IDENTIFIED BY 'ztZC2nRxWKE4itV';
GRANT ALL privileges ON `openthesaurus`.* TO 'openthesaurus'@'%';
FLUSH PRIVILEGES;
Import
- Download mysql dump from https://www.openthesaurus.de/export/openthesaurus_dump.tar.bz2
- unzip and untar the file
- gzip the sql dump file
gunzip < openthesaurus_dump.sql.gz | mysql openthesaurus