1 #!/usr/bin/env /bin/bash
5 source `dirname $0`/setup.conf
6 source `dirname $0`/setup.lib.sh
8 # someone might want to use empty password for development,
9 # let's make it possible - we asked before.
10 if [ -z $DBPASS ]; then # password still empty
13 PASSWDSECTION
="-p$DBPASS"
23 echo; echo "Dropping civicrm_* tables from database $DBNAME"
24 # mysqladmin -f -u $DBUSER $PASSWDSECTION $DBARGS drop $DBNAME
26 MYSQLADMCMD
=$
(mysqladmin_cmd
)
27 MYSQLDUMP
=$
(mysqldump_cmd
)
28 echo "SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='${DBNAME}' AND TABLE_TYPE = 'VIEW'" \
30 |
grep '^\(civicrm_\|log_civicrm_\)' \
31 |
awk -v NOFOREIGNCHECK
='SET FOREIGN_KEY_CHECKS=0;' 'BEGIN {print NOFOREIGNCHECK}{print "drop view " $1 ";"}' \
33 echo "SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='${DBNAME}' AND TABLE_TYPE = 'BASE TABLE'" \
35 |
grep '^\(civicrm_\|log_civicrm_\)' \
36 |
awk -v NOFOREIGNCHECK
='SET FOREIGN_KEY_CHECKS=0;' 'BEGIN {print NOFOREIGNCHECK}{print "drop table " $1 ";"}' \
39 $MYSQLCMD < civicrm.mysql
40 $MYSQLCMD < civicrm_data.mysql
41 $MYSQLCMD < civicrm_sample.mysql
42 echo "DROP TABLE IF EXISTS zipcodes" |
$MYSQLCMD
43 $MYSQLCMD < zipcodes.mysql
45 ## For first boot on fresh DB, boot CMS before CRM.
46 cms_eval
'civicrm_initialize();'
51 $MYSQLCMD -e "DROP TABLE zipcodes; DROP TABLE IF EXISTS civicrm_install_canary; UPDATE civicrm_domain SET config_backend = NULL; DELETE FROM civicrm_extension; DELETE FROM civicrm_cache; DELETE FROM civicrm_setting;"
52 TABLENAMES
=$
( echo "show tables like 'civicrm_%'" |
$MYSQLCMD |
grep ^civicrm_ |
xargs )
56 $MYSQLDUMP -cent --skip-triggers $DBNAME $TABLENAMES > civicrm_generated.mysql
57 #cat civicrm_sample_report.mysql >> civicrm_generated.mysql
58 cat civicrm_sample_custom_data.mysql
>> civicrm_generated.mysql
59 #cat civicrm_devel_config.mysql >> civicrm_generated.mysql
60 cat civicrm_dummy_processor.mysql
>> civicrm_generated.mysql
61 $MYSQLADMCMD -f drop
$DBNAME
62 $MYSQLADMCMD create
$DBNAME
63 $MYSQLCMD < civicrm.mysql
64 $MYSQLCMD < civicrm_generated.mysql