RtkDev:Project Materials:Data files

From RevTK

This page will maintain a list of data files used by the project, or that may be useful.

See data/datafiles/README file for instructions on downloading data files required by various scripts.

kanjis (table)

Download kanjidic2.xml and name it as listed in data/datafiles/README.

Run the script to build data/generated/table_kanjis.utf8 :

$ cd data/scripts
$ perl table_kanjis.pl > ../generated/table_kanjis.utf8

Load it up in the database, run mysql console from the project root folder :

mysql> DROP TABLE kanjis;
mysql> ( copy and paste the CREATE TABLE `kanjis` definition from data/schemas/revtk_schema.sql ) then press enter
mysql> LOAD DATA LOCAL INFILE 'data/generated/table_kanjis.utf8' INTO TABLE kanjis;

If you get garbled characters make sure to do these before importing data:

mysql> ALTER DATABASE DEFAULT CHARACTER SET 'utf8';
mysql> SET NAMES 'utf8';