Note: This section describes how to create the database. See 2.3 for the current location of the database.
To set up the server, follow the instructions as listed on the mysql webpage manual. Contact ECN to get it to be correctly located and not get wiped out every night. See "ASL Server" for information on giving Java programs access to the server.
The database was originally populated from flat files, processed by the java program 'sqlsetup.java'. This program does not need to be run, except to extend/modify the mysql database. This will only need to be done if the video files are changed.
| Location data | |
| directory | /home/rvl2/d/asldata/ASLdatabaseSearch/sqlsetup |
| source file | sqlsetup.java |
| schema file | tables.txt |
| data files | maintable.txt |
| gloss.txt | |
| paragraph.txt | |
| subject.txt |
The text file named tables.txt is a schema file and describes all of the tables that are used in the mysql database. The other text files are the tables.
To set up all of the tables, run the java file 'sqlsetup.class' to populate the mysql database.
cd ~/ASLdatabaseSearch/sqlsetup/ java sqlsetup
Unless the database videos have changed, do not use this command.