Maryland History and Culture Bibliography, PHP 5.3 app with Docker
Place a copy of the mdhc MySQL database dump file in the data directory.
docker-compose build
docker-compose up
Alternatively, manually load or re-load the database dump file
cat data/*.sql | docker exec -i mdhc_mysql_1 /usr/bin/mysql --user=root --password=123456 mdhc
- http://localhost:8080/ - MDHC website
- http://localhost:8080/admin - MDHC admin interface
- http://localhost:8081/ - phpMyAdmin
A MySQL client (such as MySQL Workbench) can connect to the database on port 3306.
This script will fix some characters in place in the database, export to TSV, then convert to CSV. Final result is in data/export.csv
bash scripts/export.sh
- Determine why some columns/rows are not aligning properly
- Run the export automaticaly using the mysql container
See the LICENSE file for license rights and limitations (Apache 2.0).