Blog

Posted 2008/01/16

Dumping the IADB schema

VERA is collaborating on cross database searching with Oxford who are working on the VRE for the Study of Documents and Manuscripts (SDM). Each VRE has a database, VERA has an archeology database (the IADB) and SDM will have a database of ancient texts. We want to produce a system for both VREs to query each other’s databases so users can find related information.

We have setup a joint wiki to help us collaborate and the first step to understand what information is being stored in each database. I have begun this process by dumping the schema for the IADB database into the wiki. The mysql command to do this is:

mysqldump -u USERNAME -p --all-databases -d > dump.sql

The important switch is -d which suppresses dumping of the actual data (the default behavior).