opengeodb-installer

rich1.0phorkiehttps://p.cweiske.de/opengeodb-installerAnonymous86400900900 <link rel="stylesheet" href="https://p.cweiske.de/css/embed.css"/> <div class="phork" id="13"> <div class="phork-file"> <div class="phork-content"> <style type="text/css">/** * GeSHi (C) 2004 - 2007 Nigel McNie, 2007 - 2008 Benny Baumann * (http://qbnz.com/highlighter/ and http://geshi.org/) */ .bash .de1, .bash .de2 {font: normal normal 1em/1.2em monospace; margin:0; padding:0; background:none; vertical-align:top;} .bash {font-family:monospace;} .bash .imp {font-weight: bold; color: red;} .bash li, .bash .li1 {color: #DDD;} .bash .ln {width:1px;text-align:right;margin:0;padding:0 2px;vertical-align:top;} .bash .kw1 {color: #000000; font-weight: bold;} .bash .kw2 {color: #c20cb9; font-weight: bold;} .bash .kw3 {color: #7a0874; font-weight: bold;} .bash .co0 {color: #666666; font-style: italic;} .bash .co1 {color: #800000;} .bash .co2 {color: #cc0000; font-style: italic;} .bash .co3 {color: #000000; font-weight: bold;} .bash .es1 {color: #000099; font-weight: bold;} .bash .es2 {color: #007800;} .bash .es3 {color: #007800;} .bash .es4 {color: #007800;} .bash .es5 {color: #780078;} .bash .es_h {color: #000099; font-weight: bold;} .bash .br0 {color: #7a0874; font-weight: bold;} .bash .sy0 {color: #000000; font-weight: bold;} .bash .st0 {color: #ff0000;} .bash .st_h {color: #ff0000;} .bash .nu0 {color: #000000;} .bash .re0 {color: #007800;} .bash .re1 {color: #007800;} .bash .re2 {color: #007800;} .bash .re4 {color: #007800;} .bash .re5 {color: #660033;} .bash span.xtra { display:block; } </style><div class="code"><table class="bash"><tbody><tr class="li1"><td class="ln"><pre class="de1">1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 </pre></td><td class="de1"><pre class="de1">#!/bin/bash   # - INSTALL instructions: # mkdir /your/preferred/path/opengeodb # cd /your/preferred/path/opengeodb # - copy this script to install_opengeodb.sh # - make script executable: # chmod +x install_opengeodb.sh # - edit you mysql credentials # # IMPORTANT: # This script uses wget to retrieve requested files, verify that wget is installed on your system. # # before you start installing opengeodb you have to download: # setup_innodb_geodb.sql from gist https://gist.github.com/3942251 in the same directory than this script # or # setup_myisam_geodb.sql from gist https://gist.github.com/3942244 in the same directory than this script # and # CREATE_ZIP_SQL from gist https://gist.github.com/3942008 as create_zip.sql in the same directory than this script #   # # start install process: # ./install_opengeodb.sh   # edit your mysql credentials DB=dbname DB_USER=dbuser DB_PASS=xxx   # do not touch URL=http://fa-technik.adfc.de/code/opengeodb/ ALTER_SQL=opengeodb-end.sql EXTRA_SQL=extra.sql CREATE_ZIP_SQL=create_zip.sql # CREATE_ZIP_SQL from gist https://gist.github.com/3942008   read -n1 -p "This script is installing the opengeodb schema and is importing lot of data. Do you really want to proceed? y|n " key echo case $key in "Y" | "y") true ;; "N" | "n") echo 'Installation aborted'; exit;; *) exit; echo ' ' ;; esac   read -p "Do you want to install a InnoDB or MyISAM driven opengeodb driven schema? [myisam] " engine case "$engine" in         innodb) SCHEMA=setup_innodb_geodb.sql                 echo "creating InnoDB opengeodb schema"                 echo " "         ;;         *)      SCHEMA=setup_myisam_geodb.sql                 echo "creating MyISAM opengeodb schema"                 echo " "         ;; esac   mysql -u $DB_USER -p $DB_PASS $DB < $SCHEMA   read -p "Which country data do you want to import? (comma separated) [AT,BE,CH,DE,LI] " country   if [ "$country" == "" ]; then         country="AT,BE,CH,DE,LI" fi   IFS=',' for sql in $country do         echo "downloading $sql.sql"         wget $URL$sql.sql         echo "importing $sql data"         mysql -u $DB_USER -p $DB_PASS $DB < $sql.sql done   echo "Downloading metadata, creating indices" wget $URL$ALTER_SQL echo "Inserting metadata, creating indices" mysql -u $DB_USER -p $DB_PASS $DB < $ALTER_SQL   read -p "Do you want to install extra information (Höhenangaben, Kontinente, Daten mit Versionierung etc.)? y|n " extra echo case $extra in "Y" | "y")      echo "Downloading $EXTRA_SQL"                 wget $URL$EXTRA_SQL                 echo "Inserting extra informations"                 mysql -u $DB_USER -p $DB_PASS $DB < $EXTRA_SQL ;; *)      echo "No extra data will be installed" ;; esac   read -p "Do you want to install hierachy informations? y|n " location echo case $location in "Y" | "y")      echo "Downloading hierarchy data for selected countries"                 for sql in $country                 do                         echo "Downloading ${sql}hier.sql"                         wget $URL${sql}hier.sql                         echo "Importing ${sql}hier data"                         mysql -u $DB_USER -p $DB_PASS $DB < ${sql}hier.sql                 done ;; *)      echo "No hierachy data will be installed" ;; esac   read -p "Do you want to create a single zip table for better radius search? y|n " single echo case $single in "Y" | "y")      echo "Installing zip table"                 mysql -u $DB_USER -p $DB_PASS $DB < $CREATE_ZIP_SQL ;; *)      echo "No zip table will be installed" ;; esac   echo echo "Installing opengeodb finished" echo</pre></td></tr></tbody></table></div> </div> <div class="phork-meta"> <a href="https://p.cweiske.de/13/rev-raw/f3065e237787c92498a42768a990902dfd8eb562/install_opengeodb.sh" style="float: right">view raw source</a> <a href="https://p.cweiske.de/13#install_opengeodb.sh">install_opengeodb.sh</a> </div> </div> </div>