git.defcon.no Git - hermes/blob - 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