This is a SQL conversion of the EDICT file from the Electronic Dictionary Research and Development Group at Monash University in MySQL 5 dump format. The file should also work for MySQL 4.1.x.

If you have trouble using this file or find an error due to the conversion process please contact me with the details.

By downloading the file below you agree to the terms in the original EDICT license.

Download edict.sql.gz

Last updated: March 05 2010

This file is automatically generated directly from the EDICT file at Monash University unless the local file is less than 7 days old. The source code for this script can be found at http://kylehasegawa.com/edict-sql-generator-sourcecode

Usage

To import this file into MySQL from Bash:

1. Extract the file
2. Create an edict database
3. Import the data

Note to users of my original edict.sql file on Monash.edu.au:
This improved version will break existing applications built from the original version. I'm sorry for the inconvenience but I felt the improvements were justified. Future modifications to the structure are unlikely.

Changelog since the original version:

• There is no longer a numeric index column because any newly inserted words in the edict file break the number->word relation.
• Columns have been appropriately renamed "japanese", "yomigana", "english".
• Japanese entries without yomigana readings are duplicated to the yomigana field instead of inserting a NULL yomigana field.