bin/export_sql.bash

   1 #!/bin/bash
   2
   3 # This script is used to export the MySQL structure of the plat/al MySQL
   4 # databases.
   5
   6
   7 # Developers: list 'public' tables here.
   8 SHARED_TABLES="account_types
   9 forums
  10 geoloc_administrativeareas
  11 geoloc_countries
  12 geoloc_localities
  13 geoloc_subadministrativeareas
  14 log_actions
  15 newsletter_cat
  16 profile_binet_enum
  17 profile_corps_enum
  18 profile_corps_rank_enum
  19 profile_education_degree_enum
  20 profile_education_enum
  21 profile_education_field_enum
  22 profile_job_entreprise_term
  23 profile_job_enum
  24 profile_job_term_enum
  25 profile_job_term_relation
  26 profile_langskill_enum
  27 profile_medal_enum
  28 profile_medal_grade_enum
  29 profile_name_enum
  30 profile_networking_enum
  31 profile_section_enum
  32 profile_skill_enum
  33 reminder_type
  34 skins"
  35
  36 usage()
  37 {
  38 cat << EOF
  39 usage: $0 OPTIONS
  40
  41 Will dump the necessary data from MySQL.
  42 Note that all options should have sane defaults if you have correctly configured
  43 your .my.cnf file.
  44
  45 OPTIONS:
  46 -h          Show this message
  47 -H HOST     MySQL host to connect to (default: none)
  48 -P PORT     MySQL port to connect to (default: none)
  49 -u USER     User for MySQL (default: none)
  50 -p PASS     MySQL password to use (default: none)
  51 -d SQL_DB   Database to read from (default: x5dat)
  52 -n          Dry run, don't actually write anything
  53 -o FILE     Write to file instead of stdout (- for stdout as well)
  54
  55 EOF
  56 }
  57
  58 HOST=
  59 PASS=
  60 PORT=
  61 USER=
  62 SQL_DB="x5dat"
  63 FILE="-"
  64 DRY_RUN=0
  65
  66 while getopts "hns:u:p:o:" OPTION
  67 do
  68     case $OPTION in
  69       h)
  70         usage
  71         exit 1
  72         ;;
  73       n)
  74         DRY_RUN=1
  75         ;;
  76       o)
  77         FILE=$OPTARG
  78         ;;
  79       p)
  80         PASS=$OPTARG
  81         ;;
  82       H)
  83         HOST=$OPTARG
  84         ;;
  85       P)
  86         PORT=$OPTARG
  87         ;;
  88       u)
  89         USER=$OPTARG
  90         ;;
  91       d)
  92         SQL_DB=$OPTARG
  93         ;;
  94       ?)
  95         usage
  96         exit
  97         ;;
  98     esac
  99 done
 100
 101
 102 DUMPER="mysqldump --add-drop-table --default-character-set=utf8 --force"
 103
 104 if [ -n "$USER" ]; then
 105     DUMPER="$DUMPER --user=$USER"
 106 fi
 107
 108 if [ -n "$PASS" ]; then
 109     DUMPER="$DUMPER --password=$PASS"
 110 fi
 111
 112 if [ -n "$HOST" ]; then
 113     DUMPER="$DUMPER --host=$HOST"
 114 fi
 115
 116 if [ -n "$PORT" ]; then
 117     DUMPER="$DUMPER --port=$PORT"
 118 fi
 119
 120 if [ "$FILE" == "-" ]; then
 121     FILE=""
 122 else
 123     if [ $DRY_RUN -ne 1 ]; then
 124         # Blank the file
 125         echo "" > $FILE
 126     fi
 127 fi
 128
 129 dump () {
 130     local command=$1
 131
 132     if [ $DRY_RUN -eq 1 ]; then
 133         if [ -n "$FILE" ]; then
 134             echo "$command >> $FILE"
 135         else
 136             echo $command
 137         fi
 138     else
 139         if [ -n "$FILE" ]; then
 140             $command >> $FILE
 141         else
 142             $command
 143         fi
 144     fi
 145 }
 146
 147 # Dump structure
 148 STRUCT_DUMPER="$DUMPER --no-data $SQL_DB"
 149 dump "$STRUCT_DUMPER"
 150
 151 SHARED_DUMPER="$DUMPER $SQL_DB $SHARED_TABLES"
 152 dump "$SHARED_DUMPER"