]> git.defcon.no Git - hermes/blob - doc/sql-data/dump-sample.sh
Added doc/ directory for documentation et.al.
[hermes] / doc / sql-data / dump-sample.sh
1 #!/bin/bash
2 DB_HOST="database.example.com"
3 DB_USER="hermes"
4 KAMAILIO_DB="kamailio"
5 PROVISION_DB="provision"
6
7 mysqldump -p -u ${DB_USER} -h ${DB_HOST} \
8 --no-data \
9 --databases ${KAMAILIO_DB} ${PROVISION_DB} \
10 > structure.sql
11
12 mysqldump -p -u ${DB_USER} -h ${DB_HOST} \
13 --no-create-db --no-create-info \
14 --databases ${KAMAILIO_DB} ${PROVISION_DB} \
15 > sample-data.sql